T-SQL Archives - Sion IT

Simple script to backup all databases at once

Script to backup all non system databases To backup all your MS SQL databases quickly on a SQL instance use the following script in a new query window. You must change the “SET @path” string to a suitable location.

Posted on March 21, 2013 at 20:00 by simon · Permalink · Leave a comment
In: SQL · Tagged with: , , ,

SQL Cheat Sheet

ThisSQL Cheat Sheet has examples of various SQL commands that work on most major flavours of SQL.  Though they all work on T-SQL.

Posted on July 12, 2012 at 18:54 by simon · Permalink · Leave a comment
In: SQL · Tagged with: , , , , , , ,