Backup and Recovery (RSS)

Data Data everywhere even when you think its gone

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Data Data everywhere even when you think its gone
The new RSS feed is here

The biggest problem I have faced in IT over the last decade has been loss of data.

I have had the problem at work where servers have crashed and lost data, more often than not due to failure of disks. I have also personally felt the pain in a hard disk losing its partition information, and frequently my wife's laptop dying and windows not being able to boot.

Whilst many businesses have been aware of the criticality of data for a while, data is becoming more critical to everyone. Many people don’t have address books anymore, and if they do, do they contain mobiles, IM addresses, email address etc. If you lose data the inconvenience and the pain is often great.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Data Data everywhere even when you think its gone

SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes
The new RSS feed is here

It used to be fact that the leaf page of a non-clustered index pointed to the row for the page, because it pointed to the file, page and row if the file or page of the row changed the nonclustered index had to be updated.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Rebuilding a clustered index does not rebuild the non clustered indexes

SQL Server The Truth - Instant file initialisation

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Instant file initialisation
The new RSS feed is here

This is the first in a series of posts that are aimed at dispelling myths and beliefs as to how SQL Server operates. I have interviewed too many people and have been in too many sessions where statements are made as though they are fact when in reality they are not. Often the reason is due to a change in behaviour between versions or a mis-interpretation of some information.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server The Truth - Instant file initialisation

Service Broker - Asynchronous/Multi threaded File Upload

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Asynchronous/Multi threaded File Upload
The new RSS feed is here

The code and slides from my presentation from today (Service Broker - Asynchronous processing in SQL )are now online.

The code is on codplex http://www.codeplex.com/MultiThreadedSQL,

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Asynchronous/Multi threaded File Upload

Service Broker - Reliable processing

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Reliable processing
The new RSS feed is here

I have just finished my presentation on asynchronous process/parallel processing using Service Broker at the Microsoft Technology Conference in Ireland. I was a bit tentative after deciding last night, after a few guinesses and whisky (thanks Barry), to add a new feature to my presentation, failure.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Reliable processing

Restoring and Attaching is a one way street

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Restoring and Attaching is a one way street
The new RSS feed is here

Many people often ask how they can us a database in SQL 2000 that they have attached or restored to SQL2005.

Unfortunately this is a one way street, once upgraded the only way of using a database in a previous version is to copy the schema and data manually. You can't restore or attach a database even if the compatibility has been kept at the previous version.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Restoring and Attaching is a one way street

Earthquake in Seattle

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Earthquake in Seattle
The new RSS feed is here

I was in the lift today and was amused when I saw one of the lights along side the normal lift lights.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Earthquake in Seattle

Native Command Substitution is not supported

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Native Command Substitution is not supported
The new RSS feed is here

In response to a recent support incident we raised we got a response about use of detours in SQL Server.

A detour is a means by which you can change what SQL Server does. This is used by Litespeed to change native backup commands into Litespeed backup commands. Whilst I always thought this a neat idea I always felt it a bit risky. If I want to do a litespeed backup I can easily write the code or use the UI to do so.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Native Command Substitution is not supported

Restoring your SQL Server - Chicken and the Egg

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Restoring your SQL Server - Chicken and the Egg
The new RSS feed is here

Have you tested your DR plan? Do you have one?

Well if you do have one then unless you test it its worthless. There are many nuances that occur in a recovery process. The Storage Engine Team have posted about one suhc nuance.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Restoring your SQL Server - Chicken and the Egg