Friday, November 18, 2011 at 11:02PM I tried to apply the SP3 update to SQL 2008 and now none of my users can connect. They're greeted with "Server is in script upgrade mode".
I've done the Googling for you. Check out my "Upgrade Issues" link under the SQL heading on the right.
Sunday, October 23, 2011 at 8:48PM I recently discovered a tool that gives me a heads-up into performance across my SQL boxes: MDW. MDW provides graphical reports that allow me to quickly delve into the top waits in my system and what's causing them. Rather than rehash what's already been said about getting MDW configured in your environment I'll hit some of the things that came up in my configuration that haven't been exhaustively covered in other areas of the web. Check out my MDW link under the SQL heading to the right.
Tuesday, May 3, 2011 at 10:53PM Recently I was asked to report on the non-deliverable (bounceback) e-mails we were sending from an internal mailbox. I put together a Powershell script that grabbed the information from Exchange (version 2007 or above) then imported it into a SQL Server database using SSIS.
In my first post of this series I'll be going over the Powershell script to get e-mails out of the Exchange system then will be posting one of my first (and more exciting) attempts at an ETL solution using SSIS.
Check out the Bounceback Project heading under SQL on the right.
Stay tuned!
Friday, February 25, 2011 at 10:00PM We have a few nightly processes and day-end reports that are causing contention in the database and all around performing badly. Look at my latest post under the Oracle heading to the right, under "Oracle - performance tuning" for how I solved these issues using Oracle CLUSTER's.
Cheers!
Thursday, December 16, 2010 at 9:55PM I had to chase down a SQL Server permissions issue the other day. In the mess of Windows Integrated Security its sometimes difficult to unwind the tangle of permissions threads to see who actually has rights to the database.
Check out the post under SQL > Security for common queries to determine who has access to what.
Cheers
