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...

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...

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...

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...