Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

December 2008 Blog Posts

Synergy

I recently got setup at home with three identical monitors as I work from home often.  Here's a picture of them.  The left-most monitor is my main monitor for my work laptop.  I extend that desktop to the middle monitor.  The right-most monitor is for my home computer.  For productivity and neatness reasons, I wanted to use only one mouse and one keyboard for both my work laptop and my home computer.  There are many tools out there that allow you to use one keyboard and one mouse with multiple computers, but most of them require special hardware and aren't...

posted @ Wednesday, December 24, 2008 10:39 AM | Feedback (2) | Filed Under [ Other ]

How to track database growth across multiple SQL Server instances

It is easy to track database growth on a single SQL Server instance.  We simply just need to store the results of sp_databases or loop through the databases and call sp_spaceused for each database. If you support hundreds of SQL instances like I do, you'd want to store the database growth information in a central repository.  From this central server, you could create a linked server for each SQL Server instance to track, but I hate creating linked servers.  I especially hate having to create hundreds of them on one SQL Server instance.  Instead of using linked servers, I created...

posted @ Tuesday, December 16, 2008 10:28 AM | Feedback (6) | Filed Under [ SQL Server - Database Administration ]

SQL Server 2005 SP3 + SP3 CU1 is now available

Microsoft has released SQL Server 2005 service pack 3 and cumulative update package 1 for service pack 3.  For more information about SP3, check this out.  For more information about SP3 CU1, check this out.  If you upgrade to just SP3, your SQL Server version will be 9.00.4035.  If you upgrade to SP3 CU1, your version will be 9.00.4205. Make sure you also update Books Online on your client machine.  You can get the newest version of BOL here. 

posted @ Monday, December 15, 2008 9:11 PM | Feedback (5) | Filed Under [ SQL Server - General ]

Powered by:
Powered By Subtext Powered By ASP.NET