I have had to migrate SQL Server instances many times over the years. Sometimes as part of an upgrade from one version to another, and other times just to move to new/bigger better hardware. In my current situation, the client wants to virtualize all of their SQL Server instances. Most of their database servers are already virtualized, […]
The value of a DBA can vary depending on numerous factors. Something that should be easy to answer is: what is a DBA worth?
If you follow industry trends at all, or if you have been in the situation where you were attempting to hire an experienced DBA, you no doubt are aware of the shortage […]
At this very moment, as I write this, I am visiting my daughter and my grand kids for Christmas. I am on “vacation.” I have been on vacation for a week, and will continue to be on vacation for another week. However, I have carried my phone with me the entire time, even while at […]
The subject for this T-SQL Tuesday is Giving Back. I have been a taker in the SQL community for many years.
In 2012 I went to my first PASS Summit (you know, the year with the nice Ogio bags). I was duly impressed with the quality, quantity, and variety of presentations available for the attendees. I learned […]
‘Twas the night before the upgrade, when all through the place
Not a backup was working, “there’s not enough disk space”;
The software was compiled and packaged with care,
In hopes that some QA was actually done there.
I called the PM and he proceeded to shout,
“You’re the DBA, you figure it out!”
When out of the lunchroom there arose […]
Query Optimizer Tips and Tricks Part 2
This is the second installment in a continuing series of articles on things to look for and change that will help your query optimizer perform at its best. If you missed part one, you can read it here.
Okay, now that you know about trusted vs. non-trusted check constraints, let’s […]
Query Optimizer Part 1
It may come as a surprise to you to find out that at its core, the SQL Server Query Optimizer is like a jealous lover. How so? The optimizer doesn’t trust the constraints on your data until you prove to it that your data is trustworthy! Why do you care? Because if the […]
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 […]