-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Gavin Draper's SQL Server Blog

Software Dev/DBA living the dream in sunny Brighton, UK. I've been playing with SQL Server about nearly 20 years now and still feel just as clueless as I did back then. I love writing about things I find as I go along.

Archives: February 2012

SQL Server Isolation Levels By Example

Isolation levels in SQL Server control the way locking works between transactions.

SQL Server 2008 supports the following isolation levels

  • Read Uncommitted
  • Read Committed (The default)
  • Repeatable Read
  • Serializable
  • Snapshot

Before I run through each of these in detail you may want to create a new database to run the… Read more

0 comments, 27 reads

Posted in Gavin Draper's SQL Server Blog on 18 February 2012

Building Visual Studio Deployment Projects With MSBuild

I recently hit what I would call a fairly serious limitation of MSBuild and that is that it cant build Visual Studio Deployment Projects. This is a bit of a show stopper when your trying to build a one click release script.

After some Googling it turns out that there… Read more

0 comments, 25 reads

Posted in Gavin Draper's SQL Server Blog on 17 February 2012

Debugging WP7s Isolated Storage

As part of the Windows Phone SDK you get the IsolatedStorageExplorerTool, this tool allows you to explore and update what is in the current applications Isolated Storage.

The IsolatedStorageExplorerTool is installed in a path something like…

“Program Files\Microsoft SDKs\Windows Phone\v7.1\Tools\IsolatedStorageExplorerTool”

The first thing you need to do is get the… Read more

0 comments, 29 reads

Posted in Gavin Draper's SQL Server Blog on 12 February 2012

Thread Synchronization/Locking In .Net

When you are creating multiple threads that need to access a shared resource then you need to implement some form of locking on that resource to prevent race conditions. A race condition can occur when two threads try to access the shared resource at the same time, for example if… Read more

0 comments, 25 reads

Posted in Gavin Draper's SQL Server Blog on 5 February 2012