Script Storage Update


This is an update to a previous post. In another post on this site, it was said that Dropbox Paper is the code storage of choice. This has changed. As of today, I much prefer using Microsoft’s GIT code repository known as: devops.azure.com. The benefits are numerous. Ability to revert back to previous versions Ability […]

Script Storage


Update here: Script Storage Update Throughout my career, my scripts have been a vital piece of my work. Where I store them has changed over the years. The challenge has been in finding a repository that is reliable, searchable, accessible from where I work, and that looks good with color-coding. Additionally, I don’t want to pay […]

MySQL – Move Data Files To New Location (Windows)


After setting up MySQL, I realized that I put my data files on the C drive.  Since I don't want database growth to end up taking down the entire OS, I had to move them.  My struggles consumed a couple of hours, so I wanted to clear up and document the process. Default Database Files MySQL […]

TSQL – Simple Loop Through Result Set Using Cursor


(If you want to AVOID cursors, see: TSQL – Loop Through Result Set WITHOUT Cursors) This is the basic query text to use whenever you need to loop through a result set in SQL Server using TSQL.  In this example we are getting every database name and printing it out.

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 as when you have to move something from development to testing or production.  Recently, I discovered that using the SSMS “script as” option doesn’t help very much at all.  It simply generates a statement to create the role but […]

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 able to name the trace but there were no events to choose from in the “Events Selection” tab, even when the “Show All Events” box was checked.  If I clicked the “Column Filters” button the entire Profiler application would […]

SQL Server – Email Results of Stored Procedure Conditionally


Within a Stored Procedure, you may want the results of a particular query emailed to you, but only if there is a result.  In other words, I don’t want to be notified when the result set size is 0.

SSMS MDI Trick


This trick is for SSMS users who like the MDI (window) environment.  If you’ve noticed that new windows open with the instance connection hidden, then read on.  I have your fix! Just open a query window, minimize it, and leave it there.  After that, new windows will open at the correct level so you can […]