Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Common tasks script repository

Author  Topic 

PingTheServer
Starting Member

28 Posts

Posted - 2009-01-08 : 16:35:23
Does anyone have links to a good script collection of how to accomplish random but useful tasks? I have built up some useful ones for our organization here, but was wondering if anyone knew where there was a list of administrative/import/export/how to do X SQL queries.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-08 : 16:56:31
Could you give us an example so that we know what you mean by "random but useful tasks"?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-01-08 : 17:53:45
I have a pretty good collection of useful scripts, I call it "Peso"
Seriously, though, search this site for topics that interest you and you'll find what you're looking for.

Jim
Go to Top of Page

PingTheServer
Starting Member

28 Posts

Posted - 2009-01-08 : 17:59:18
quote:
Originally posted by tkizer

Could you give us an example so that we know what you mean by "random but useful tasks"?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog




Something like how to move the temp db, select data from the current month, create mirroring endpoints, copying instance logins from one server to another, examples of using functions like UPPERCASE or MAX...things like that. Dont panic if X happens, try this...

I know most of these things are scattered throughout the web and various books, but I wanted to see if anyone had (or knew of) somewhere that many of these examples were all in one place.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-08 : 18:26:26
Well I like the articles I wrote on my blog.

If you are a DBA, then my blog would be an excellent resource. Subscribe or bookmark...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

PingTheServer
Starting Member

28 Posts

Posted - 2009-01-09 : 09:21:16
Yep, thats what I was looking for
http://weblogs.sqlteam.com/tarad/category/95.aspx

I had read it before, just not looked through it enough. Bookmarked.
Go to Top of Page
   

- Advertisement -