SQL Server 2008: Using Change Data Capture with SSIS
I was perusing the latest release of the SQL Server 2008 Books Online on MSDN (look, Kimberly’s in Dublin this week – what else am
I was perusing the latest release of the SQL Server 2008 Books Online on MSDN (look, Kimberly’s in Dublin this week – what else am
This blog post describes the demo “1 – Fatal Errors” from my Corruption Survival Techniques conference session from various conferences in 2008. The links to
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
Wow – that was tough but *very* fulfilling. As you may know, Kimberly and I are each writing chapters for Kalen's next book – SQL
Now, I’m very thick-skinned and I know there are always some people in a conference session who don’t agree with everything I say (that’s human
While we were at PASS we hooked up with Eric Ostrowski from TechNet Radio to do an interview. Eric's compiled a bunch of interviews from
During the PASS Community Summit, Rick Heiges did an interview with Thomas Grohser, the Senior Database Engineer at the bwin Interactive Entertainment AG, the world's
As you may have noticed, I *really* like blogging and writing about SQL Server (to the point that Kimberly jokes in our sessions and workshops
This blog post explains the demo scripts and databases I've posted to cover all the Corruption Survival Techniques and DBCC CHECKDB sessions I've presented at
Wow – that was a bit of a wild ride! Another conference season is over and we're in the wind down to vacation time –
Here's another corruption bug that people are hitting on 2005 SP2 – something I didn't know about until today. The situation is this: a table
It's really scary how quickly time flies – seems like it was just last week when I last blogged about TechNet Magazine (actually it was
Today's post is based on a bunch of questions I've had around the various compression features in SQL Server 2008. Does turning on data compression
It's been a long time since the last Conference Questions Pot-Pourri – in fact it was at the last SQL Connections in Orlando in April.
(Posted with permission of the dev team) Here's an interesting bug that people are hitting. I found out about this while here in Barcelona at
As you'll have read last week, we were in Vienna all week teaching. This was Kimberly's first visit to the city (and country), I was
If anyone reading the blog was watching SQLServerCentral back in 2006, you'd have seen an email interview I did with Steve Jones while I was
On Tuesday we had a look around our customer's data centers here in Austria – hidden away in the labryinthine bowels of a very large
During early SQL Server 2008 development, the Storage Engine team introduced additional minimally-logged functionality. And then it was removed again for RTM. Now it seems
It's been almost exactly a week since the last post – an unusually long time for me. Kimberly and I were teaching the first week
The sparse columns feature in SQL Server 2008 is generating lots of interest from people looking to deploy extensible schemas. I've seen a few questions
One of our customers (and friends!) sent us this last week – a stark reminder why hardware redundancy is a good idea! The controller
Very exciting! The SQL Server 2008 Internals book we're working on with Kalen is now available to pre-order on Amazon, ahead of the planned
The feature article on SQL Server 2008: Tracking Changes in Your Enterprise Database I wrote for the November issue of TechNet Magazine is live on the web. It
Thanks for your patience while our blog engine back-end was updated. You should find that the response time is much better now. You'll notice that
Just found out that the 25-page FILESTREAM whitepaper I wrote recently for the SQL team has been published on MSDN. You can get it
Just a quick post to say that all our blogs and the SQLskills.com website is moving to a new software backend this coming Wednesday through
I finally got to take Kimberly to Scotland in September and show her some of the country where I was brought up. After spending 10
Just over a month since SQL Server 2008 went to RTM and the first Cumulative Update (CU1) has been released. Bob Ward, a very good
For the first time in ages, Kimberly sneaked in an interview without me! I was teaching a class on Database Maintenance for some Microsoft DBAs
It’s been almost two weeks since my last post as we’ve been offline in Scotland (another photo post to follow – I owe you two
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 –
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.