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

Archives: January 2017

Compare column names for case sensitivity

I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in column names. For example, if Table1 has a column named Col1, and Table2 has COL1, well that’s no good. But, how do we easily find those mismatches on a… Read more

3 comments, 725 reads

Posted in SQL Awesomesauce on 25 January 2017

Webinar: Introducing Minion CheckDB!

Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two different days: Wednesday, February 1 – Done! We will post the video next week. Meanwhile, here is the WebinarDemo script, and the webinar survey. Friday, February 3 at 12pm… Read more

0 comments, 820 reads

Posted in SQL Awesomesauce on 19 January 2017

Database snapshots for everyone!

If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots in any version! Oh what's that? You don't use snapshots? Well let's see a couple of good use cases for them.

The post Database snapshots for everyone! appeared first on… Read more

0 comments, 604 reads

Posted in SQL Awesomesauce on 5 January 2017