One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines. Some people perform routine index maintenance, some people do not, and still others have done some sort of “set it and forget it” script provided by a vendor and may or may not […]
Moving databases is a common enough task for the DBA, and there are multiple ways to move physical database files from one drive to another. Depending on your preference, you can either use the DETACH/ATTACH method:
Or you can use the ALTER DATABASE method:
Whichever method you prefer, these work great when you are moving databases, especially […]
Frequently we hear the analogy that <insert item here> are like opinions, everybody has one and not all of them are good (some may stink).
Well, this may just be another one of those <items>. Whether it stinks or not may depend on your mileage. It’s a missing indexes script.
I had shared a similar script back […]
This last Saturday was the most recent iteration of Utah Code Camp and I have to say it was a resounding success. In addition to speaking, I was invited to participate in an “Ask a DBA” panel discussion and also had the opportunity to have SQL Solutions Group sponsor the event. So it was a […]
I ran into a problem a while back that caused me a lot of grief so I thought I’d post it here. The package in question was used to traverse hundreds of Oracle databases and run the same query on all of them. This data was then loaded into a data mart. The databases all […]
I just got done implementing the EPM Framework for a client and thought I’d post a few things here I learned along the way. Nothing earth shattering but stuff worth noting.
SQL Server Version
The SQL Server 2008 instance serving as the EPM Framework hosting instance must be 2008 SP1 CU3 or higher. What is interesting about […]
As an old-school DBA who has been around the block more times than I’d like to admit, I am always a bit slow to jump on the bandwagon with new features and technology. I’m the guy that still doesn’t like the idea of virtualizing databases for example. The CLR was no different when it came […]