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
Repair vs Restore Dilemma
For some reason The Clash's 'Should I Stay or Should I Go?' has been going round in my head today -...
Author: Paul Randal - MSFT Date: 06/07/2006
How to recreate the msdb database in SQL Server 2005?
I've just spent a bunch time researching an answer to this question on the new disaster recovery...
Author: Paul Randal - MSFT Date: 06/06/2006
Are you coming to TechEd? We'd like to see you there!
Just over half the Storage Engine PM team will be at TechEd June 11-17. Attending will be: Sunil...
Author: Paul Randal - MSFT Date: 06/05/2006
New MSDN forum on Disaster Recovery and Availability
It's quite evident now that there's a growing need for a focused forum around disaster recovery and...
Author: Paul Randal - MSFT Date: 06/05/2006
Troubleshooting deadlocks in SQL2005
Deadlock in the context of SQL Server means two or more transactions or tasks are waiting on each...
Author: Sunil Agarwal Date: 06/05/2006
Bulk Importing data with OPENROWSET in SQL2005
Before SQL2005, you could use Bulk Insert or BCP to import data into SQL Server. While both of these...
Author: Sunil Agarwal Date: 05/30/2006
Range locks
Lately I have seen some quesitons on range locks. Why certain keys are locked? How is this behavior...
Author: Sunil Agarwal Date: 05/26/2006
Lock Escalation in SQL2005
Lock Escalation: If you consider the hierarchy of the objects in a SQL Server instance, at the top...
Author: Sunil Agarwal Date: 05/17/2006