New whitepaper on database snapshots
Well, it was released a year ago but I only just found out about it last week. The SQL CAT team published a whitepaper last
Well, it was released a year ago but I only just found out about it last week. The SQL CAT team published a whitepaper last
It’s become something of a tradition for me to do a Valentine’s Day blog post (the 2008 one about SQL Server blogs is at Wow
In SQL Server 2000 and before, the symptoms of database corruption would occasionally manifest themselves as asserts, such as: SQL Server Assertion: File: <recbase.cpp>, line=1378
One of the things I mentioned in my recent TechNet Magazine article on Understanding Logging and Recovery was the need to manage the transaction log
This year it looks like we’re not going to be involved in TechEd US in May so the SQL Connections show in Orlando in March (21-26)
(Yes I know I haven't posted for a while, we've been travelling – we're in Hyderabad right now – but I'll post a bunch over
OK – last content post today. I forgot that the February TechNet Magazine also has the latest edition of my regular SQL Q&A column. This
Wow – today is all about new content. As if I haven't already blogged about enough stuff to keep you reading through next week, the
TechNet Magazine is publishing a series of SQL Server 2008 tips every day through January – mostly taken from upcoming Microsoft Press books on SQL
Over the last few weeks Sunil Agarwal (from the SQL Storage Engine team) has posted a great series of blog articles about tempdb and the version
Kimberly also did an interview with TechNet Radio back in December – this time about partitioning. The links for the interview are: WMA – http://download.microsoft.com/download/F/5/2/F52567BB-D32D-437E-A9A7-60D898AA03C7/TechNetRadio-01132009-web.wma
Well, we're back from vacation finally (only for 10 days and then off to India and Thailand for 3 weeks… phew) and I've got a
[Edit 1/1/09] Well, actually its so nice here (St. Lucia) that we're staying on vacation another week – maybe I'll post some stuff next week
This blog post describes the demo "2 – NC Indexes" from my Corruption Survival Techniques conference session from various conferences in 2008. The links to
The January 2009 issue of TechNet Magazine is now available on the web and has a new article I wrote on Advanced Troubleshooting with Extended
For those of you who couldn't make it to a conference this year where I presented my Corruption Survival Techniques session, the folks at TechEd
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
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.