Shrinking tempdb no longer prohibited
For the longest time the guidance around tempdb is that if you shrink it on a live system then it could cause tempdb corruption. A
Menu
For the longest time the guidance around tempdb is that if you shrink it on a live system then it could cause tempdb corruption. A
The July edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column (and I
[Edit January 2015: Everything in this post applies to SQL Server 2012 and 2014 still.] This blog post is part of the monthly T-SQL Tuesday
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
The March edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
Happy New Year! The January edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A
In last week's survey I asked how you manage the size of your database *data* files – see here for the survey. Here are the
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
Here’s a question I got from someone who attended our database maintenance workshop at PASS last week (paraphrased): I attended your pre-conference session on database
Every so often I’ll see posts on the various data corruption forums discussing causes of corruption. In this post I want to debunk some of
Well, we’re just back from vacation (photo blog post to follow) and I’ve heard that the feature article on Effective Database Maintenance I wrote for the
My first magazine article is in print! I’ve taken over the bi-monthly SQL Q&A column for TechNet Magazine and I just received the June magazine
I’m in the middle of a flight from Washington D.C. to Zurich on the way to Barcelona for TechEd IT Forum and I can’t sleep
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.