RunAs Radio interview on being an “involuntary DBA”
On Tuesday I recorded a couple of sessions with Richard and Greg on RunAs Radio. It’s been a while since either Kimberly or I have been
Menu
On Tuesday I recorded a couple of sessions with Richard and Greg on RunAs Radio. It’s been a while since either Kimberly or I have been
Now this one’s sure to spark some controversy… I was checking my RSS feeds of the SQL blogs that I follow and noticed an interesting
I woke up this morning and someone had replaced my wife with someone who likes to blog :-). Kimberly’s turned over a new leaf and is
Moving databases around is pretty common, as is moving databases between servers running different Editions of SQL Server, especially during a disaster recovery situation. You
This is a quickie in response to a blog comment from my previous post on instant initialization: How to tell if you have instant initialization
At the user group meeting on Monday I spent some time explaining how GUIDs can cause fragmentation in clustered indexes AND in non-clustered indexes, even
There's been a spate of problems on the forums and in my inbox with people's transaction logs filling up. With the increase in "involuntary DBAs",
I've had a few follow-ups on my two posts about boot page and file header page corruption – asking if its possible to do single-page
As you may already know, instant file initialization is a way to prevent data (not log) file create and grow operations having to zero-initialize the
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
Over the last few weeks I've seen (and helped correct) quite a few myths and misconceptions about index rebuild operations. There's enough now to make
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
Many times I've been asked to do a blog post about creating Agent alerts, and given that today I demo'd it as part of our
Over the weekend there was a question on one of the internal aliases at MS: how can I tell what percentage of a database has
[Edit: From 2016 SP2 onward, you can use SELECT DATABASEPROPERTYEX (‘dbname’ , ‘LastGoodCheckDbTime’ ); instead] This came up several times during the week so I
Here’s an interesting question that came in to our questions line (questions@SQLskills.com – no guarantee of an answer – I check it every so often): I
A couple of weeks ago I blogged about the three tracks of the SQL Server 2008 JumpStart course that SQLskills.com taught internally for Microsoft and
Almost a year ago to the day I asked a question on my old blog – how long does *your* CHECKDB take to run? Well,
It seems like all I’ve been talking about on the forums the last couple of days is the correct order of operations in a maintenance
While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL
This is a question that comes up a lot – how to run consistency checks on a VLDB? We’re talking hundreds of GBs or 1
This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so
One of the sessions we did yesterday at IT Forum was an Instructor-Led Lab on database snapshots, an Enterprise Edition feature of SQL Server 2005.
Last week at SQL Connections someone said that CHECKDB’s output is ‘useless’. Given that I wrote CHECKDB for SQL Server 2005 I was only mildly
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
As promised, here’s the first of the grab-bag of questions we were asked during conferences. I’m blogging a selection of the stuff I noted down. These
(Been a few days since I posted – had some real work to do :-) Today I'll post a few things from the queue that's been
There’s been some discussion over on the SQL Server Central forums about database mirroring performance, and one question in particular on how to do index
This has come up several times over the last few days, and is something that Kimberly and I discuss (and deplore) when we lecture –
Whenever I’m discussing index maintenance, and specifically fragmentation, I always make a point of saying ‘Make sure the index is being used before doing anything
This was a question from the MSDN Disaster Recovery forum I started while I was at Microsoft. I have a 600 gig database that has
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.