Monthly Archives: March 2011

Recursive Directory Scripting

Inside source control, I have scripts arranged as follows: Drive:/Base/Database/ Drive:/Base/Database/Functions Drive:/Base/Database/Proc Drive:/Base/Database/Tables Etc.. Each script stored can be run multiple times with no ill effect. For example, a table generation script first checks to see that it exists before … Continue reading

Posted in SQL Server Development, SQL Toolbox | Tagged , , | Leave a comment

Primary, Secondary, Tertiary, umm…?

I recently found myself asking the question posed in the title – what comes after primary, secondary, tertiary…? I had a rough idea, based on my drum line days, and the various types of Tenor drums. However, this article lays … Continue reading

Posted in SQL Toolbox | Tagged , | Leave a comment

Moving Database Logins

Recently we had a database issue, that necessitated us moving logins. Here’s an article I used from Microsoft to help script the logins. The KB is specifically for 2005 -> 2008, but it will also get you login’s out of … Continue reading

Posted in SQL Toolbox | Tagged , , , | Leave a comment