Skip to main content


Showing posts from November, 2016

Parallax effect

SQLCMD for Multiple Databases Using a .BAT (batch) File

I utilized SQLCMD so that we could parameterize the databases and not use dynamic SQL.  If you're not familiar with SQLCMD mode, please read here .  In SSMS, you can turn on SQLCMD mode by going to Query > SQLCMD Mode

Sharing Template Explorer in SSMS

I love SSMS Templates , and before Snippets , I used for both reasons.  To access SMSS Templates, go here:  View>Template Explorer  or  Ctrl+Alt+T .  I use them as a place to store those infrequently used SQL Queries.  Those queries that a DBA doesn't want rewrite and reinvent or spending a lot of time remembering where they were last saved.