Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Organization? Expand / Collapse
Author
Message
Posted Thursday, May 12, 2011 8:45 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:36 PM
Points: 228, Visits: 218
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?


  Post Attachments 
TemplateXplorer.png (16 views, 17.35 KB)
Post #1107768
Posted Thursday, May 12, 2011 10:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:19 AM
Points: 2,162, Visits: 1,918
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
Post #1107859
Posted Thursday, May 12, 2011 10:04 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 8:03 AM
Points: 4,052, Visits: 4,192
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/

Post #1107861
Posted Thursday, May 12, 2011 5:20 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:22 PM
Points: 1,192, Visits: 2,174
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

Post #1108126
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse