http://www.sqlservercentral.com/Articles tagged Administering, Strategies, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/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/The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding. http://www.sqlservercentral.com/redirect/articles/2618/2006/10/18http://www.sqlservercentral.com/redirect/articles/2618/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/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/Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit. http://www.sqlservercentral.com/articles/Administering/conductingasqlserveroperationalaudit/2079/2005/10/24http://www.sqlservercentral.com/articles/Administering/conductingasqlserveroperationalaudit/2079/How many times have you run out of space in a database? What about on a file system? Andy Warren has had this happen a few times, especially when large imports take place. He brings us an article that describes some of the precautions he has taken to prevent this from happening. http://www.sqlservercentral.com/articles/Administering/runningoutofspace/1971/2005/07/14http://www.sqlservercentral.com/articles/Administering/runningoutofspace/1971/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/Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering. http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/2004/11/25http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, usually something bad that they need to fix. However alerts can also be used to drive business logic processes and enable some types of actions to be safely performed without requiring extraordinary rights by a user. Author Leo Peysakhovich brings us some ideas on how we can use alerts to implement business logic processing. http://www.sqlservercentral.com/articles/Administering/sqlserveralerts/1435/2004/08/10http://www.sqlservercentral.com/articles/Administering/sqlserveralerts/1435/Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do. http://www.sqlservercentral.com/articles/Administering/usingdifferenttechniquesforsqlserverautomation/1429/2004/08/02http://www.sqlservercentral.com/articles/Administering/usingdifferenttechniquesforsqlserverautomation/1429/When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server. http://www.sqlservercentral.com/articles/Administering/fixingbrokenlogins/193/2004/07/05http://www.sqlservercentral.com/articles/Administering/fixingbrokenlogins/193/Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more. http://www.sqlservercentral.com/articles/Administering/makinggooduseofsysforeignkeystablepart1displaytabl/1364/2004/06/01http://www.sqlservercentral.com/articles/Administering/makinggooduseofsysforeignkeystablepart1displaytabl/1364/One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works. http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/2003/11/26http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs. http://www.sqlservercentral.com/articles/Administering/managingjobspart4/1037/2003/06/25http://www.sqlservercentral.com/articles/Administering/managingjobspart4/1037/This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration. http://www.sqlservercentral.com/articles/Administering/integratingsqllitespeedinyourexistingbackupinfrast/986/2003/05/12http://www.sqlservercentral.com/articles/Administering/integratingsqllitespeedinyourexistingbackupinfrast/986/Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into. http://www.sqlservercentral.com/redirect/articles/983/2003/05/08http://www.sqlservercentral.com/redirect/articles/983/This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.http://www.sqlservercentral.com/redirect/articles/982/2003/05/06http://www.sqlservercentral.com/redirect/articles/982/Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea! http://www.sqlservercentral.com/articles/Administering/usingqueryanalyzertemplates/974/2003/04/28http://www.sqlservercentral.com/articles/Administering/usingqueryanalyzertemplates/974/This week we have another article from Andy that discusses some changes he made at work in conjunction with clustering all his database servers. Not a how-to, just comments about what was changed and why. Worth reading just for the reminder about the potential gotcha that @@ServerName can represent. http://www.sqlservercentral.com/articles/Administering/standardsareagoodthing/951/2003/04/09http://www.sqlservercentral.com/articles/Administering/standardsareagoodthing/951/This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.http://www.sqlservercentral.com/articles/Administering/changemanagement/939/2003/03/18http://www.sqlservercentral.com/articles/Administering/changemanagement/939/This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't. http://www.sqlservercentral.com/articles/Administering/managingjobspart3/936/2003/03/11http://www.sqlservercentral.com/articles/Administering/managingjobspart3/936/Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading! http://www.sqlservercentral.com/articles/Administering/managingjobspart2/919/2003/02/14http://www.sqlservercentral.com/articles/Administering/managingjobspart2/919/How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control. http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/2003/01/31http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/Standards are important in the computer business, both the hardware and software side. After looking at Coding Standards in a previous series, Steve Jones looks at the server side of standards beginning with hardware. http://www.sqlservercentral.com/articles/Administering/serverhardwarestandards/878/2003/01/30http://www.sqlservercentral.com/articles/Administering/serverhardwarestandards/878/Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically. http://www.sqlservercentral.com/articles/Administering/anotherdisasteralmost/881/2003/01/14http://www.sqlservercentral.com/articles/Administering/anotherdisasteralmost/881/This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed. http://www.sqlservercentral.com/articles/Administering/backupandrestorebacktobasicswithsqllitespeed/884/2002/12/23http://www.sqlservercentral.com/articles/Administering/backupandrestorebacktobasicswithsqllitespeed/884/We're curious to see what our readers have to say about this one! How many of us have tables accruing data that won't be used and/or isn't of any value? At what point do we get rid of it to free up resources? http://www.sqlservercentral.com/articles/Administering/worstpracticenothavinganarchiveplanforeachtable/839/2002/11/11http://www.sqlservercentral.com/articles/Administering/worstpracticenothavinganarchiveplanforeachtable/839/In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications. http://www.sqlservercentral.com/articles/Administering/thecaseforsqlloginsparttwo/780/2002/08/19http://www.sqlservercentral.com/articles/Administering/thecaseforsqlloginsparttwo/780/This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL. http://www.sqlservercentral.com/articles/Administering/cache/766/2002/08/15http://www.sqlservercentral.com/articles/Administering/cache/766/