SSIS packages are handy. They can do all sorts of things and the developers here use them a lot. One very useful feature is that you can set up connection objects in your package so it can connect to any of your servers to do what it needs to do. This is also one of […]
Back in December, a couple of checks I wrote were included in Brent Ozar Unlimited’s sp_Blitz script. I was chagrined to see that some people discovered some bugs in my code and submitted fixes. To be fair, one was a bug in SQL 2008 & 2008 R2 where DBCC DBINFO WITH TABLERESULTS returned the dbccLastKnownGood […]
I recently performed an in-place upgrade of a SQL Server from SQL 2008 R2 to SQL 2012. All seemed to work well, until I tried taking a database backup. That failed. This particular SQL Server uses LiteSpeed for backups and the following error was being returned when it ran: Msg 17750, Level 16, State 0, […]
I’ve been playing around some more with SQL 2012 and I discovered another nice little improvement. This isn’t anything huge, but rather a nice little touch that makes my life as a DBA a little bit easier. If you have your SQL Agent jobs configured to send you email when they fail (or succeed or […]
This is a problem all DBAs will run into at some point – the drive a database’s transaction log is on runs out of space. In most cases, this was caused by the transaction log autogrowing until there is no room left on the drive. If your alerts are set up correctly, you’ll get an […]