Aug 9 2012
Viva Las Vegas and Las Laziness In my presentation on Performance-Enhancing Laziness I’ll be presenting at Dev Connections this Fall in Las Vegas I’ll be providing a great number of productivity tips that will allow you to work a lot less – to get many more things accomplished in your day. I wanted to give [...]
Jun 12 2012
SharePoint is a fine tool for document management and sharing. However SharePoint likes to play by its own rules when it comes to how it stores and organizes the information it relies upon to serve out those mad skillz to the denizens of the cube farms and board rooms. It does so with the bravado that [...]
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…
