SQL Consultant Braves Weather to Serve Client
Spring may be only weeks away, officially, but the weather is plenty chilly in North Dakota. And Fargo, North Dakota,
March 5, 2015
Category: SQL Server
Automating DBCC PAGE, part 2: Determining object names on pages
In my last post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option. In
February 3, 2015
A Tale of Two DBAs: A Cautionary Tale
“It was the best of database consulting times…it was the worst of database consulting times…” One of the most common
January 27, 2015
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index
January 21, 2015
Moving Databases to New Drives: A Real-world Case Study Involving 120 Databases
Moving databases is a common enough task for the DBA, and there are multiple ways to move physical database files
July 29, 2014
Missing Indexes Script v2
Frequently we hear the analogy that <insert item here> are like opinions, everybody has one and not all of them
June 15, 2014
Utah Code Camp Spring 2012
This last Saturday was the most recent iteration of Utah Code Camp and I have to say it was a
March 12, 2012
Expired Passwords and the Oracle Provider
I ran into a problem a while back that caused me a lot of grief so I thought I’d post
January 15, 2011
EPM Framework Tips and Tricks
I just got done implementing the EPM Framework for a client and thought I’d post a few things here I
November 4, 2010
Converting a Hex value to an integer using the CLR
As an old-school DBA who has been around the block more times than I’d like to admit, I am always
November 4, 2010