By Saleem Hakani (Microsoft Corporation) on 2/1/2011 9:46 PM
What if you have 100's of SQL Server 2005 in your company and you would like to configure all the servers based on some standards (Example: Surface Area Configuration Properties). Take an example you have just installed a SQL Server and also have configured the surface area configuration (SAC) for that SQL Server based on your standards and now you would like to replicate this configuration to 100's and 1000's of other SQL Servers in your company. How would you do that? |
By Bellevue College Student on 2/1/2011 9:09 PM
Post by: Gary Mitchell (Bellevue College, WA)
I chose Stored Procedures as a topic because, while Database Administration can be done without writing them, they are a key to automating many of the administration tasks. The intent is not to determine what can be automated or to cover the T-SQL language, but to cover some features and possible methodologies for stored procedures. |
By Bellevue College Student on 2/1/2011 8:42 PM
Author: Nyssa Rogers (Bellevue College, WA)
Some developers use them, and some developers think they're the worst thing since the plague. But what are they?
Here's a basic overview of how to declare cursors and perform basic fetches for procedures that need to look at data one line at a time rather than as a set. |
By Saleem Hakani (Microsoft Corporation) on 1/29/2011 12:19 AM
There are times when you may want to create indexes on large tables which may take huge amount of time (sometimes several hours) and yet you want to make the data available during the creation of Index as your database is being used by thousands of users in the production environment. |
By Saleem Hakani (Microsoft Corporation) on 1/29/2011 12:11 AM
One of the best features of SQL Server 2005 & 2008 that I like is that it lets you perform restore on portions of the database which is damaged and yet keep the database ONLINE. This was not possible with earlier versions of SQL Server. In SQL Server 2005/2008, you no longer have to take the database offline to perform a restore on a small portion of a database. Once you have identified the pages that need to be restored you have two options:
1) You can perform a PAGE level restore (My recommendation is to do this when you have small number of pages)
2) You can perform a FILE level restore (My recommendation is to do this when you have large number of pages) |
By Saleem Hakani (Microsoft Corporation) on 12/28/2010 11:10 PM
It becomes very challenging to remember long object names when you are working with linked servers or using a non-standard object naming convention in SQL Server. |