Organization?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Organization?

Organization?

Rate Topic

Display Mode

Topic Options

Author

Message

SQL08Kid

Posted Thursday, May 12, 2011 8:45 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 4:15 PM
Points: 208, Visits: 196

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

fhanlon

Posted Thursday, May 12, 2011 10:02 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:23 AM
Points: 2,100, Visits: 1,790

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

Welsh Corgi

Posted Thursday, May 12, 2011 10:04 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:19 AM
Points: 3,833, Visits: 4,052

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

sqlbuddy123

Posted Thursday, May 12, 2011 5:20 PM

Right there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 3:17 PM
Points: 715, Visits: 1,524

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 »

Permissions