http://www.sqlservercentral.com/Articles tagged SQL Server 2005, Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Build List Updated with Cumulative Update 9 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/08/22http://www.sqlservercentral.com/articles/Administration/2960/James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.http://www.sqlservercentral.com/articles/T-SQL/63471/2008/07/28http://www.sqlservercentral.com/articles/T-SQL/63471/Build List Updated with Cumulative Update 9 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/08/22http://www.sqlservercentral.com/articles/Administration/2960/Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005. http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/2008/07/11http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/This article describes how to generate the sp_who2 results including the query text for the spid.http://www.sqlservercentral.com/articles/Administration/63144/2008/06/26http://www.sqlservercentral.com/articles/Administration/63144/Build List Updated with Cumulative Update 9 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/08/22http://www.sqlservercentral.com/articles/Administration/2960/What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences. http://www.sqlservercentral.com/articles/Administration/2988/2008/05/08http://www.sqlservercentral.com/articles/Administration/2988/Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade. http://www.sqlservercentral.com/articles/Administration/2987/2008/05/07http://www.sqlservercentral.com/articles/Administration/2987/Build List Updated with Cumulative Update 9 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/08/22http://www.sqlservercentral.com/articles/Administration/2960/Build List Updated with Cumulative Update 9 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/08/22http://www.sqlservercentral.com/articles/Administration/2960/Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This can create a daisy-chain of processes waiting to complete their work.http://www.sqlservercentral.com/redirect/articles/62558/2008/04/03http://www.sqlservercentral.com/redirect/articles/62558/The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions.http://www.sqlservercentral.com/redirect/articles/62557/2008/03/31http://www.sqlservercentral.com/redirect/articles/62557/Build List Updated with Cumulative Update 9 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/08/22http://www.sqlservercentral.com/articles/Administration/2960/DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use. http://www.sqlservercentral.com/articles/Administration/2928/2008/03/18http://www.sqlservercentral.com/articles/Administration/2928/With SQL Server 2005 recently released, one of the things that many people are looking for are some guidelines for working with the new product. New author Nanda Kishore brings us a list of best practices that should give you a start. http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/2008/03/14http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers http://www.sqlservercentral.com/articles/Administration/2898/2008/03/04http://www.sqlservercentral.com/articles/Administration/2898/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/One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced.http://www.sqlservercentral.com/redirect/articles/2886/2008/02/27http://www.sqlservercentral.com/redirect/articles/2886/If you have not had the chance to work with SQL Server 2005, or even if you have, Robert Pearl brings us some important information about what your upgrade or installation of the next version of SQL Server will bring. This is information every administrator needs to know to get prepared. http://www.sqlservercentral.com/articles/Administration/installingandupgradingtosqlserver2005/1943/2008/01/11http://www.sqlservercentral.com/articles/Administration/installingandupgradingtosqlserver2005/1943/Service Pack 2 for SQL Server 2005 is not quite here, but Wayne Fillis brings us a look at what you can expect if you install the CTP version that is available now. http://www.sqlservercentral.com/articles/Administration/2793/2008/01/08http://www.sqlservercentral.com/articles/Administration/2793/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/New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature. http://www.sqlservercentral.com/articles/Administration/2786/2008/01/04http://www.sqlservercentral.com/articles/Administration/2786/Keeping track of the amount of space in a database is something every DBA needs to do or face the dreaded "out of space" errors appearing on every client's desktop. SQL Server guru David Poole brings us an automated way of doing just that. http://www.sqlservercentral.com/articles/Administration/2771/2007/12/25http://www.sqlservercentral.com/articles/Administration/2771/How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs. http://www.sqlservercentral.com/articles/Performance+Tuning/2770/2007/12/24http://www.sqlservercentral.com/articles/Performance+Tuning/2770/Build List Updated with Cumulative Update 9 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/08/22http://www.sqlservercentral.com/articles/Administration/2960/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 of the brand new features in SQL Server 2005 is the database snapshot. New authors Arvinder Singh Khosla and S.Srivathsani Murthy bring us a look at how these static view databases can be setup and used in your environment. http://www.sqlservercentral.com/articles/Administration/2733/2007/11/26http://www.sqlservercentral.com/articles/Administration/2733/What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.http://www.sqlservercentral.com/redirect/articles/61532/2007/11/21http://www.sqlservercentral.com/redirect/articles/61532/Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.http://www.sqlservercentral.com/redirect/articles/61416/2007/11/13http://www.sqlservercentral.com/redirect/articles/61416/