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