Skip to main content

Posts

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.