http://www.sqlservercentral.com/Articles tagged Administering, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load. http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/2006/06/30http://www.sqlservercentral.com/articles/Administering/sizingadatabase/383/Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running. http://www.sqlservercentral.com/articles/Administering/2963/2008/04/14http://www.sqlservercentral.com/articles/Administering/2963/This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files. http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/2008/03/07http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/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 by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline. http://www.sqlservercentral.com/articles/Administering/deattachandreattachdatabases/646/2008/02/08http://www.sqlservercentral.com/articles/Administering/deattachandreattachdatabases/646/In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/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/The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server. http://www.sqlservercentral.com/articles/Administering/sqlserverjobscheduling/2288/2007/11/16http://www.sqlservercentral.com/articles/Administering/sqlserverjobscheduling/2288/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/Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring! http://www.sqlservercentral.com/articles/Administering/monitoringdiskspaceandsendingalertswithtsql/1114/2007/09/14http://www.sqlservercentral.com/articles/Administering/monitoringdiskspaceandsendingalertswithtsql/1114/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/Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security. http://www.sqlservercentral.com/articles/Administering/beginningsqlserverloginsandusers/1460/2007/08/03http://www.sqlservercentral.com/articles/Administering/beginningsqlserverloginsandusers/1460/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/SQL Server 2000 trace flags can dramatically alter the behavior and functionality of the server. There are a number of ways that they can be enabled and Chris Hedgate brings us a tutorial on their use and benefits. http://www.sqlservercentral.com/articles/Administering/howtousetraceflagsinsqlserver2000/1860/2007/06/21http://www.sqlservercentral.com/articles/Administering/howtousetraceflagsinsqlserver2000/1860/Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running. http://www.sqlservercentral.com/articles/Administering/2963/2008/04/14http://www.sqlservercentral.com/articles/Administering/2963/SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins. http://www.sqlservercentral.com/articles/Administering/auditingwithsqlprofiler/1461/2007/04/20http://www.sqlservercentral.com/articles/Administering/auditingwithsqlprofiler/1461/What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.http://www.sqlservercentral.com/redirect/articles/2948/2007/04/06http://www.sqlservercentral.com/redirect/articles/2948/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/In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm. http://www.sqlservercentral.com/articles/Administering/citrix_metaframe/683/2007/03/02http://www.sqlservercentral.com/articles/Administering/citrix_metaframe/683/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/EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment. http://www.sqlservercentral.com/articles/Administering/implementing_efs/870/2006/12/01http://www.sqlservercentral.com/articles/Administering/implementing_efs/870/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/Monitoring the file sizes and free space on your SQL Server can be done in a number of ways, but it needs to be done or you will get a phone call when you least expect it. In an interesting read, Roy Carlson brings us a great way with code and reporting to setup your own monitoring system. http://www.sqlservercentral.com/articles/Administering/2678/2006/11/06http://www.sqlservercentral.com/articles/Administering/2678/It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. Raj Vasant brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns. http://www.sqlservercentral.com/articles/Administering/queryingsystemtables/1906/2006/10/20http://www.sqlservercentral.com/articles/Administering/queryingsystemtables/1906/