SQL Server 2008 public class – database infrastructure and scalability
Over the last six months on the blog, you’ll have seen me mention internal training that Kimberly and I wrote for
Over the last six months on the blog, you’ll have seen me mention internal training that Kimberly and I wrote for
At the last Connections conference in April, the conference organizers tapped a bunch of speakers for interviews, articles, and other content to put into a
This is the second of the two sessions I recently recorded with Richard and Greg on RunAs Radio (the first one on being an “involuntary DBA”
In the last few classes I've taught, we've discussed the on-disk structures where everything is stored in a database, and I've also been asked privately
Well, it’s been a year since I left Microsoft (8/31/07) to join Kimberly running SQLskills.com – and what a blast it’s been! From 8/31/07 to
I just heard today that the first whitepaper I’ve written for Microsoft has been published! The abstract is: SQL Server Replication: Providing High-Availability using Database
(Quickie post #3 while it's Kimberly's turn to lecture this morning – better pay attention now before I get into trouble) Gail asked a (paraphrased)
(Quickie post #2 while it's Kimberly's turn to lecture this morning…) Greg asked a question regarding the script I posted to examine buffer pool contents (paraphrased)
(Quickie post #1 while it’s Kimberly’s turn to lecture this morning…) I had a comment on my post dealing with suspect databases, saying that the
Well, we’re here in England now to teach the first of our UK classes and we’re staying with our good friend Tony Rogerson (UK SQL Server
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
Following on from my previous post on boot pages and boot page corruption, I’ve been asked about file header pages – and I was already
While we were at TechEd in June, Kimberly and I participated in an hour-long discussion panel (Leveraging SQL Server Technologies to Build a Solid High-Availability
Now that I’ve done all the business-related blog posts, back to the good stuff to stop people complaining! Something that’s cropped up a few
Well, almost… Kimberly and I have agreed to co-author the upcoming SQL Server 2008 Internals book with our good friend Kalen Delaney. This is the
September, October, and November are going to be a whirlwind this year – after 3 weeks in the UK and Ireland in September, teaching and the San
People have been complaining that I’ve stopped blogging so much – vacation folks, vacation! Today I’ve got a few class and conference posts to get
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
One problem (the only one!) of going on vacation with Kimberly is that can be hard to banish SQL Server completely from conversation. Over breakfast this
TechEd US is done for another year! As I mentioned before, we did a lot of stuff but still found time to chill by the
Today I presented my brand new session Surviving Corruption: From Detection to Recovery at TechEd. I had a lot of fun putting together the demos, presenting
(I’m actually on-stage here at TechEd doing the DAT track pre-con with Kimberly – she’s on now until lunch so I’m catching up on forum problems…)
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
That time has rolled around again and we’re flying down to Orlando for TechEd US tomorrow – my first US TechEd since I left Microsoft.
Totally off-topic blog post this time. I haven’t blogged in a week as we’ve been in Chicago and Illinois for the memorial for Kimberly’s Father
Before I start, I want to make it clear that you can only hit this bug if you ALREADY have corruption, that it’s quite rare,
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.