SQL Database Engine Blog
This is the blog of the engineering team managing and developing the Database Engine for SQL Server and Azure SQL Database
An exciting new feature in SQL Server 2005/SP2 is Vardecimal Storage Format. This storage format...
Author: Sunil Agarwal Date: 11/10/2006
We've released the second CTP (Community Technology Preview) of the SP2 for SQL Server 2005. All...
Author: Paul Randal - MSFT Date: 11/09/2006
I know this is jumping the gun a little as I haven't made it this far in my series on fragmentation,...
Author: Paul Randal - MSFT Date: 11/08/2006
(Yippee - just finished my certification dives and got my PADI Open Water certification - just in...
Author: Paul Randal - MSFT Date: 10/19/2006
There has already been a great deal of excitement over the release of SQLIOSim, and I know everyone...
Author: Jerome Halmans Date: 10/06/2006
I recently ran into a customer who wanted to import data into a table that did not allow NULL for...
Author: Sunil Agarwal Date: 09/29/2006
I've come across a few interesting DR scenarios lately, (interesting in the sense that the...
Author: Kevin Farlee [MSFT] Date: 09/26/2006
(Another airport, another blog post - I really must make an effort to come up with more original...
Author: Paul Randal - MSFT Date: 09/20/2006
Ok - really catching up with the various blog post series I started back in June/July - time to bang...
Author: Paul Randal - MSFT Date: 09/18/2006
(OK - I was wrong about the posting frequency - events overtook me and I got bogged down preparing...
Author: Paul Randal - MSFT Date: 09/18/2006
Time to cough up a real-life data recovery scenario to temporarily stop those people who badger me...
Author: Paul Randal - MSFT Date: 08/09/2006
I've been sitting and thinking a lot about guarantees this morning while drinking coffee in the...
Author: Paul Randal - MSFT Date: 07/23/2006
Totally off-topic post today. We recently had a private tour of the excellent Woodland Park Zoo here...
Author: Paul Randal - MSFT Date: 07/21/2006
In the previous post of this series, I covered the system table checks that have to be done before...
Author: Paul Randal - MSFT Date: 07/18/2006
(Been a week or so since the last post but I haven't burnt out with blogging yet - I was on vacation...
Author: Paul Randal - MSFT Date: 07/08/2006
Page checksum is new feature in SQL2005 that provides you a stronger mechanism than torn-page to...
Author: Sunil Agarwal Date: 06/29/2006
I've had some questions sent in comments and I wanted to reply to some of them using a post so...
Author: Paul Randal - MSFT Date: 06/28/2006
(Ok - another flight - another blog post. This time its Boston back to Seattle. The three of us...
Author: Paul Randal - MSFT Date: 06/28/2006
Apologies for the lack of a proper image in the previous post - as several people have pointed out....
Author: Paul Randal - MSFT Date: 06/28/2006
(I'm sitting here in Seattle airport at 7am on Sunday waiting to catch the same flight to Boston...
Author: Paul Randal - MSFT Date: 06/26/2006
I've reached a point in my various ramblings where I need to do some glossary work. First up is an...
Author: Paul Randal - MSFT Date: 06/24/2006
Ever see something like this in your SQL Errorlog?SQL Server has encountered 1 occurrence(s) of I/O...
Author: Jerome Halmans Date: 06/21/2006
I'm sure you've been there - something causes corruption in the database. You blame the hardware,...
Author: Paul Randal - MSFT Date: 06/21/2006
If you're interested in a little background, I did an email interview with Steve Jones of...
Author: Paul Randal - MSFT Date: 06/21/2006
Having multiple users each owning various objects is commonplace in the database world. When one...
Author: RobWalters Date: 06/21/2006
Here is the summary and the link to the white papers. Working with TempDBThis white paper describes...
Author: Sunil Agarwal Date: 06/20/2006
Sounds kinda funny, doesn't it? I mean, who here doesn't have someone breathing down your neck every...
Author: Kevin Farlee [MSFT] Date: 06/20/2006
Hmmm - I sat for 5 minutes thinking of something amusing to say to start this one off and nothing...
Author: Paul Randal - MSFT Date: 06/18/2006
I just saw this on one of the forums - it's another wonderful piece of advice to studiously...
Author: Paul Randal - MSFT Date: 06/18/2006
I was asked this several times at TechEd so I'd like to answer it publicly. It's kind of complicated...
Author: Paul Randal - MSFT Date: 06/18/2006
TechEd's done and dusted for another year, and what a blast we had!It's incredible to think of the...
Author: Paul Randal - MSFT Date: 06/16/2006
In my chalk/talk at TechEd yesterday, I asked the crowd "what's the purpose of repair?" One person...
Author: Paul Randal - MSFT Date: 06/15/2006
10 points if you answered "don't be daft, never!" and minus several million is you answered anything...
Author: Paul Randal - MSFT Date: 06/15/2006
So, I'd like to make a couple of assertions about backup and disaster recovery that will hopefully...
Author: Kevin Farlee [MSFT] Date: 06/15/2006
This is a question that's come up several times at TechEd already and is a nice second part to the...
Author: Paul Randal - MSFT Date: 06/13/2006
.. this is an old one, but its poorly understood and it just surfaced again today so I thought I'd...
Author: Paul Randal - MSFT Date: 06/12/2006
Luckily the 8.40am Alaska Airlines direct flight from Seattle>Boston was on time as I'm guessing...
Author: Paul Randal - MSFT Date: 06/12/2006
Yes, finally I come clean and tell all. It's an open secret that there's an undocumented DBCC...
Author: Paul Randal - MSFT Date: 06/10/2006
Collection Manager Starter Kit Overview The Collection Manager is a rich client application that...
Author: Paul Randal - MSFT Date: 06/10/2006
As you can guess from the title, I'm planning a long series over the summer to go into the guts of...
Author: Paul Randal - MSFT Date: 06/08/2006
When bulk importing data, the data can come from any source including the files created in other...
Author: Sunil Agarwal Date: 06/08/2006
I've just been itching to post this one.I'm doing a chalk-talk (AKA cabana session, this year AKA...
Author: Paul Randal - MSFT Date: 06/07/2006