Share via


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

<Previous Next>