http://www.sqlservercentral.com/Content tagged SQL Server 2005, Administering posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code. http://www.sqlservercentral.com/articles/Administering/2896/2008/03/03http://www.sqlservercentral.com/articles/Administering/2896/As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005. http://www.sqlservercentral.com/articles/Administering/2792/2008/01/07http://www.sqlservercentral.com/articles/Administering/2792/Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems. http://www.sqlservercentral.com/articles/Administering/2757/2007/12/12http://www.sqlservercentral.com/articles/Administering/2757/One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution. http://www.sqlservercentral.com/redirect/articles/3248/2007/09/21http://www.sqlservercentral.com/redirect/articles/3248/Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process. http://www.sqlservercentral.com/articles/Administering/3123/2007/08/06http://www.sqlservercentral.com/articles/Administering/3123/Greg Larsen examines setting up SQL Server to listen on a different port number than 1433. http://www.sqlservercentral.com/redirect/articles/3130/2007/08/03http://www.sqlservercentral.com/redirect/articles/3130/When your database transaction log is out of control, there is only one man who can tame it. http://www.sqlservercentral.com/redirect/articles/3065/2007/07/06http://www.sqlservercentral.com/redirect/articles/3065/Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code. http://www.sqlservercentral.com/articles/Administering/2896/2008/03/03http://www.sqlservercentral.com/articles/Administering/2896/This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models. http://www.sqlservercentral.com/redirect/articles/2881/2007/02/27http://www.sqlservercentral.com/redirect/articles/2881/Pop Rivett tackles a torn page in a suspect database.http://www.sqlservercentral.com/redirect/articles/2841/2007/02/13http://www.sqlservercentral.com/redirect/articles/2841/As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005. http://www.sqlservercentral.com/articles/Administering/2792/2008/01/07http://www.sqlservercentral.com/articles/Administering/2792/Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems. http://www.sqlservercentral.com/articles/Administering/2757/2007/12/12http://www.sqlservercentral.com/articles/Administering/2757/As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so. http://www.sqlservercentral.com/articles/Administering/2688/2006/11/16http://www.sqlservercentral.com/articles/Administering/2688/Monitoring in the real world. Roy Carlson concludes his series on space monitoring for your SQL Servers with a real world example of how he found a problem and fixed it. http://www.sqlservercentral.com/articles/Administering/2681/2006/11/09http://www.sqlservercentral.com/articles/Administering/2681/It's small and neat but it might just save your data...Robyn Page's crib sheet tells you everything you wanted to know about SQL Server backup but were afraid to ask.http://www.sqlservercentral.com/redirect/articles/2654/2006/10/20http://www.sqlservercentral.com/redirect/articles/2654/Most DBAs manage multiple SQL servers, each handling different needs for your business. Even with the diverse uses for different servers, there is often the need to deploy the same scripts to all servers for various purposes. Author Joe Doherty brings us his scripts and technique for executing a script across multiple servers. http://www.sqlservercentral.com/articles/Administering/2629/2006/09/27http://www.sqlservercentral.com/articles/Administering/2629/Longtime author Leo Peysakhovich answers one of the most common questions seen in discussion areas around the world: how do you identify unused objects? http://www.sqlservercentral.com/articles/Administering/2582/2006/09/11http://www.sqlservercentral.com/articles/Administering/2582/Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.http://www.sqlservercentral.com/redirect/articles/2587/2006/09/08http://www.sqlservercentral.com/redirect/articles/2587/Have you ever needed to build a job that could run within a certain period of time? Those long maintenance operations, like index rebuilds, need to fit within certain windows of time. New author Joe Doherty brings us a great technique for ensuring those jobs do not run over into your business day and impact normal operations. http://www.sqlservercentral.com/articles/Administering/2577/2006/09/06http://www.sqlservercentral.com/articles/Administering/2577/Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning. http://www.sqlservercentral.com/articles/Administering/analyzingdiskcapacityforsqlserver/2467/2006/07/04http://www.sqlservercentral.com/articles/Administering/analyzingdiskcapacityforsqlserver/2467/It is something you do rarely, but with SQL Server 2005 and ten services, there are more decisions to make. Steve Jones gives some advice on which service accounts to choose and some common problems with others. http://www.sqlservercentral.com/articles/Administering/pickingserviceaccounts/2351/2006/03/30http://www.sqlservercentral.com/articles/Administering/pickingserviceaccounts/2351/Ongoing now, the SQL Server 2005 Roadshows in conjunction with PASS. Read Robert Pearl's notes from the show and if you are in Dallas or Houston or Europe, there is still time to attend on of these events. http://www.sqlservercentral.com/articles/Administering/sqlserver2005roadshows/1888/2005/05/10http://www.sqlservercentral.com/articles/Administering/sqlserver2005roadshows/1888/