Ramblings of a DBA

Tara Kizer
posts - 166, comments - 835, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

July 2010 Blog Posts

What are the largest SQL projects in the world?

If you are interested in finding out the largest SQL projects in the world, you should check out this PowerPoint presentation.  It’s from Kevin Cox of SQL CAT at Microsoft.

posted @ Friday, July 23, 2010 10:06 AM | Feedback (3) | Filed Under [ SQL Server - General SQL Server - Database Administration ]

SQL Saturday #55 in San Diego

SQL Saturday is coming to my hometown, San Diego, on September 18th, 2010.  I have submitted my session and hope that it gets approved.  Let me know if anyone is attending the event in San Diego.  If you aren’t in Southern California, check their site for the location nearest you. 

posted @ Friday, July 16, 2010 3:16 PM | Feedback (3) | Filed Under [ SQL Server - General ]

Database Growth Tracker Tool – New Version

A while back I wrote a CLR object to track database growth.  The CLR object queries sp_databases for each passed in server and saves the data into a table.  By using this CLR object, I can track all of my systems in one location.  I blogged about this tool in this article. A few weeks ago, I noticed that my SQL Agent job that runs this CLR object was failing.  It was only failing on one of my database servers, so I ran sp_databases on that system to figure out what was going on.  I noticed that for one...

posted @ Friday, July 09, 2010 2:10 PM | Feedback (5) |

Fix for SQL Server 2005/Windows 2008 cluster issue with lower/mixed case server names

Last November, I blogged about a weird bug with SQL Server 2005 on a Windows 2008 cluster.  We were having issues with Database Mail and other things and learned that it was due to the server names being in lower case.  To workaround the issue, we had to follow the steps outlined here as there was no bug fix at the time.  I’ve now learned that this bug has been fixed!  The fix is included in cumulative update package 9 for SQL Server 2005 service pack 3.  Check it out here.

posted @ Friday, July 02, 2010 12:32 PM | Feedback (1) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET