Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but....More
In my session on SQL Server Essentials for Non-DBAs I tried to provide a very high-level overview of key concepts and concerns that ‘reluctant’ or ‘....More
I’ve used gobs of tools this year. Too many to mention. Many of them just plain awesome. But one tool stands out above the rest – to the point where....More
Every once in a while, one of my SQL Server Consulting clients asks me for my opinions about running Anti-Virus on production SQL Servers. And,....More
If a picture is worth a thousand words, then the words associated with the following picture would probably involve a decent amount of muttering and....More
My grandfather (who was a Marine pilot during WWII and who was later issued the Navy Commendation Medal in person, by President John F. Kennedy, for....More
In my most recent post, I touched upon the importance of SQL Server Statistics by way of an analogy—in terms of comparing the importance of up-to-....More
It’s impossible to overstate just how important statistics are to SQL Server. Without them, SQL Server’s impressive cost-based optimizer simply....More
Michael K. Campbell is a contributing editor for SQL Server Pro and Dev Pro and is an ASPInsider. Michael is the president of OverAchiever Productions, a consultancy dedicated to technical evangelism...
What's Practical SQL Server?
Practical advice, insight, and help for core SQL Server considerations.