Opinion SQL Server – AD Groups vs AD Logins benjf.com.blog@benjf.com, 2020-09-01 Let me state my position from the outset: Favoring AD Groups for security in SQL… Continue Reading
C# Script Storage Update benjf.com.blog@benjf.com, 2019-10-17 This is an update to a previous post. In another post on this site, it… Continue Reading
Script Storage benjf.com.blog@benjf.com, 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) benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 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 benjf.com.blog@benjf.com, 2013-05-20 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 benjf.com.blog@benjf.com, 2013-02-01 (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 benjf.com.blog@benjf.com, 2013-01-10 Sometimes, as a DBA, you will have to copy a database role to another instance,… Continue Reading
SQL Server Profiler New Templates Failing benjf.com.blog@benjf.com, 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