SQL Server Admin
T-SQL Articles

December 27, 2009

10 Must Read SQL Server Administration articles on SQLServerCurry - 2009




This post contains 10 Must Read articles that were published in the year 2009 on SQLServerCurry and contains SQL Server Administration scripts to perform some common administration tasks on your SQL Server database

Generic SQL Server Stored Procedure to display Table Names of any Database passed to it

Set a database to read only mode using SQL Server 2005/2008

Delete BackUp and Restore History for databases in SQL Server 2005/2008

How to do a Full and Differential Database Backup in SQL Server

SQL Server 2005 and 2008 Diagnostics Queries and Configuration Checklist

Find Out Tables in a Database Having Identity Columns

Enable and Disable All the Triggers in a SQL Server Database

Recompiling Stored Procedures in SQL Server – All, Few or One at a time

How to Create a SQL Server Agent Proxy Account

Programmatically Change the default path for SQL Server Database creation

To read some more articles on SQL Server Administration, check here


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter



 
  Feedback:

comments

0 Responses to "10 Must Read SQL Server Administration articles on SQLServerCurry - 2009"
 

Copyright © 2009-2011 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions