2023-06-03
SQL
2020-09-01
SQL Server – AD Groups vs AD Logins
Let me state my position from the outset: Favoring AD Groups for security in SQL Server...
2019-10-17
Script Storage Update
This is an update to a previous post. In another post on this site, it was...
2018-05-02
Script Storage
Update here: Script Storage Update Throughout my career, my scripts have been a vital piece of...
2018-02-15
MySQL – Move Data Files To New Location (Windows)
After setting up MySQL, I realized that I put my data files on the C drive. ...
2013-06-18
SQL Server – Rolling Back Dynamic SQL
Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof, run...
2013-05-20
TSQL – Loop Through Result Set WITHOUT Cursors
There is some controversy about using cursors in TSQL. Overall, I believe they tend to tie...
2013-02-01
TSQL – Simple Loop Through Result Set Using Cursor
(If you want to AVOID cursors, see: TSQL – Loop Through Result Set WITHOUT Cursors) This is...
2013-01-10
SQL Server – Script Out a Database Role and Securables
Sometimes, as a DBA, you will have to copy a database role to another instance, such...
2012-12-19
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 was...