#SQL
3 posts from Apr 29, 2010 to Jul 29, 2012, newest first.
Using Redgates Sql Compare for Complex Migrations with EF’s CodeFirst
Introduction As many of you know, I’ve been quite the fan of Entity Framework CodeFirst for quite some time.& 160; It does a great job of reducing the number of places I have to change thngs each…
When Using EF CodeFirst With Visual Studio, How to Live With Cannot drop database because it is in use error.
Problem So, if you have been doing development with Visual Studio 2010 , Entity Framework CodeFirst , SqlServer or SqlServerCE for any amount of time, you’ll quickly run into the problem that the…
Writing A Transact SQL (TSQL) Procedure For SQL Server 2008 To Delete Rows From Table Safely
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date.& 160; That is, say the table has 10,000,000…