Mar 30 2012
Until yesterday I never heard of World Backup Day. I checked Target and I couldn’t find a single greeting card either. I was wondering if I was being Punk’d by Brent Ozar in his post that tomorrow (March 31, 2012) has that distinction. Then I figured what the heck, I’ve some scripts I use frequently [...]
Dec 23 2011
On the Tenth day of Christmas I Give a Gift to Thee…Ten Quick Hit Thumbscripts A Nine Hour Work Day I FORGOT WHAT EIGHT WAS FOR… Seven Reports to Start My Day Six Gb of RAM Five Volumes Minimum… Four Words to Live By… Three Training Events… Two Twitter Handles… and Mirrored Disks with Parity [...]
Nov 15 2011
Recently I found myself in a situation where I needed to make a mass change to the operator that was to be notified in the event of a failure. This change had to occur across all SQL instances under my administrative control. Do I need to perform a repetitive process for hundreds of SQL Agent [...]
Nov 23 2009
I really don’t know why it took me so long to embrace the use of templates in SQL Server Management Studio. Really, they’re right there in plain sight. They even have their own Explorer for cryin’ out loud! Even the DMVs don’t have that and look how much press they get! Unless one of the templates [...]
Sep 2 2009
The 24 Hours of PASS kicked off at 19:45 EST yesterday and has so far, with about three hours to go, been a great technical and educational success. Presenters have been solid for the most part, and there have been limited technical issues to work out early on. PASS’s own Tom LaRock has also been [...]
Jul 27 2009
How do I determine if a login has the VIEW SERVER STATE permissions needed to query the Dynamic Management Views and Dynamic Management Functions in Microsoft SQL Server? A simple query…
Jul 7 2009
I originally planned this post to just vent about a vendor doing something evil to their own database hosted on a shared instance of SQL Server I administer. Then I thought that I may be able to make a contest out of this… So, what caused me to come up with this lame stunt to drive traffic to my blog? Well… you tell me!
Jun 23 2009
Need to return information on all indexes for a selected SQL Server database. Here is the code!
