http://www.sqlservercentral.com/Content tagged Administration, SQL Server 2005, SQL Server 7, 2000 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/Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database. http://www.sqlservercentral.com/articles/Indexing/2760/2007/12/13http://www.sqlservercentral.com/articles/Indexing/2760/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/Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database. http://www.sqlservercentral.com/articles/Indexing/2760/2007/12/13http://www.sqlservercentral.com/articles/Indexing/2760/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/Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data. http://www.sqlservercentral.com/articles/Monitoring/2680/2006/11/08http://www.sqlservercentral.com/articles/Monitoring/2680/Continuing with his series on monitoring space, Roy Carlson looks at checking the space in a folder to be sure your SQL Server databases never run out of storage. http://www.sqlservercentral.com/articles/Monitoring/2679/2006/11/07http://www.sqlservercentral.com/articles/Monitoring/2679/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/A week ago, we solicited readers to let Microsoft know which of the SQL Server 2005 announced features mattered most to them. We had a great response, with 890 of you answering the survey in three days. The answers were pretty interesting. The full results can be seen at the bottom of this article. http://www.sqlservercentral.com/articles/News/sqlserver2005surveyresults/1317/2004/03/22http://www.sqlservercentral.com/articles/News/sqlserver2005surveyresults/1317/Microsoft confirmed today that it has delayed Yukon yet again. It also announced that Yukon has an official name and will have another beta added to the development cycle. Get all the info here and share with Microsoft your thoughts about what features are important to you. http://www.sqlservercentral.com/articles/News/yukon/1311/2004/03/11http://www.sqlservercentral.com/articles/News/yukon/1311/