Stranger Danger… The need for trust with constraints

I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....

Red Gate SQL Source Control v4 offers schema locks

Red Gate Documentation Update
Looks like the rapid release channel now has a great feature for locking database objects that you...

Running very large scripts is not a strong area for SSMS

out of memory, argggh!
Am I the only one that has experienced the various out of memory issues with SSMS? Not...

Using Qure Profiler To Benchmark Tuning Progress

the problem of monster views

I’ve been working with tuning an application that performs a lot of Entity framework calls,...

SET NOEXEC is my new friend

Have never really played around with the option: SET NOEXEC ON
Turns out this can be a helpful way to validate...

Database Stuck in Single-User Mode Due to Botched Restore

Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the...

What was I thinking? Deleting myself from localdb?

Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...

What was I thinking? Deleting myself from localdb?

Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...

Download SSMS 2015 as a standalone download.... finally!

I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek
Two...

Download SSMS 2015 as a standalone download…. finally!

I’m excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek...