Monthly Archives: June 2010

I found a cool series of scripts from Jeremiah Peschka on getting disk space from SQL Server. They’re useful queries, and I think for the most part I like getting the information from sys.sysaltfiles for information on my databases. However, … Continue reading →

I was never a big fan of temp tables, mostly because there were serious contention issues in SQL Server v6.5. I know things were better in v7.0, but I managed to learn to code without them, so I have avoided … Continue reading →

I woke up this morning to find Kathi Kellenberger disagreeing with Andy Leonard’s blog on picking the pre/post conference speakers. I read through both, and found myself in the middle of the debate. I sense from frustration from Andy, and … Continue reading →

When you create a server audit, one of the things that might surprise you is that the audit doesn’t record data. So you create an audit for failed logins, as I did recently. You then login: Using a bad password … Continue reading →