Category Archives: TSQL

Excel formatting SQL results

Posted on February 25, 2016 by

Sometimes its the little things that get annoying like requesting some information from a DBA or a system admin at a remote site where you can’t run scripts but need someone to do it for you. Quick example you want … Continue reading →

Posted in Productivity, TSQL | Leave a comment

Sysadmin Shenanigans & Lying Error messages

Posted on February 24, 2016 by

One of the databases that is for DBA use was in restricted user mode , this allows only certain users access to the database, basically its sysadmin users , db_owner or db_creater access to the database. I wanted to create … Continue reading →

Posted in TSQL | Tagged , , | Leave a comment

Using Output

Posted on May 4, 2014 by

The OUTPUT command can be a very useful tool to use at times. The following scripts show a couple of ways it can be used. The code from these scripts can be found here on my shared dropbox. First off … Continue reading →

Posted in Tips & Tricks, TSQL | Tagged , | Leave a comment