Category: SQL
SQL Server – AD Groups vs AD Logins
Let me state my position from the outset: Favoring AD Groups for security in SQL…
Script Storage Update
This is an update to a previous post. In another post on this site, it…
Script Storage
Update here: Script Storage Update Throughout my career, my scripts have been a vital piece…
MySQL – Move Data Files To New Location (Windows)
After setting up MySQL, I realized that I put my data files on the C…
SQL Server – Rolling Back Dynamic SQL
Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof,…
TSQL – Loop Through Result Set WITHOUT Cursors
There is some controversy about using cursors in TSQL. Overall, I believe they tend to…
TSQL – Simple Loop Through Result Set Using Cursor
(If you want to AVOID cursors, see: TSQL – Loop Through Result Set WITHOUT Cursors) This…
SQL Server – Script Out a Database Role and Securables
Sometimes, as a DBA, you will have to copy a database role to another instance,…
SQL Server Profiler New Templates Failing
Source of info: http://www.mattbutton.com/2011/06/01/sql-profiler-templates-missing/ Upon trying to create a trace template in SQL Server Profiler, I…