Follow-on from instant initialization privilege checking
I got bored on the first leg of the journey from Seattle to London so thought I’d bang out a quick blog post. After my
I got bored on the first leg of the journey from Seattle to London so thought I’d bang out a quick blog post. After my
(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
When I started blogging, way back in 2006 :-), the third post I made on the old Storage Engine blog was about rebuilding the msdb
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
Just go watch it – LEGO stop-go animation of a Metallica concert – it’s fantastic! http://www.sarahlacy.com:80/sarahlacy/2008/08/stop-what-you-a.html Thanks to Jason Massie for the heads-up (tons of
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
If you’ve been following my blog for a while, you’ll know that I’m a big fan of LEGO (see SQL Down Under podcast interview –
This is a quick post inspired by a question I was sent in email (thanks Marcos!) which very neatly lets me show a DMV I’ve
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
Over the last few weeks I’ve had lots of questions about FILESTREAM performance and how to coax NTFS into scaling nicely. I just finished writing
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
Just a bit off-topic on this one! I was sitting working on our top deck this morning when I spotted a large commerical airliner being
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",
Yes, it’s that time again (well a little bit earlier than usual). With the Fall SQL Server Connections show coming up soon, its time to
In conjunction with our Iceland partners Miracle, we’re offering three BI classes in Iceland in September, taught by Stacia Misner. The three classes are as
While we were on vacation at the start of July we spent a week on the live-aboard Kona Aggressor II catching up on some scuba-diving.
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
Fresh off a week of teaching classes on the Microsoft campus, we’ve finalized some user group dates. Here’s what we have coming up: Monday August
I’m sitting here writing my next article for TechNet Magazine – this time on Tracking Changes Using SQL Server 2008 – and was fooling around
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.