May 12, 2011 at 8:45 am
Not really a technical question but I was just wanting to get everyone's input on how you save your SQL queries, scripts, etc.
I personally use the template explorer and save all "my" scripts in folders that start with aa so I can seperate them from Microsoft's built-in templates.
How do you store yours?
May 12, 2011 at 10:02 am
Very interesting approach. I never thought of using the templates. However from BOL
"The first time the template explorer is opened, a copy of the templates is
placed in the users Documents and Settings folder under Application
Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates."
i.e. "C:\Users\John\AppData\Roaming\Microsoft\Microsoft SQL
Server\100\Tools\Shell\Templates\Sql"
Since we have several DBAs in my area using templates would make it difficult to share. Instead We just set up a network share and organize all the scripts there under multiple folders. usually when I open a file SSMS returns to the same share.
Francis
May 12, 2011 at 10:04 am
After storing your scripts on a folder that gets backed up I would immediately store them in a Source Control Program.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 5:20 pm
If they are personal, save them onto a windows folder on disk and separate them by categories. Take a backup of those scripts regularly. If they are shared scripts then put them on a network share.
If they need to be modified by a group of developers, then use a source control tool.
Thank You,
Best Regards,
SQLBuddy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply