http://www.sqlservercentral.com/Articles tagged SQL Server 7, 2000, Strategies posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability. http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/2008/06/27http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/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/SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys. http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/2007/06/22http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/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/Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.http://www.sqlservercentral.com/redirect/articles/2620/2006/10/12http://www.sqlservercentral.com/redirect/articles/2620/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/SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability. http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/2008/06/27http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/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/SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys. http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/2007/06/22http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role. http://www.sqlservercentral.com/articles/DTS/datamigrationoverview/639/2005/11/25http://www.sqlservercentral.com/articles/DTS/datamigrationoverview/639/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/Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data. http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/2005/05/27http://www.sqlservercentral.com/articles/Security/10securingyoursqlserver/701/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/Hurricane Charlie had a pretty substantial impact on residents and businesses in Central Florida. Andy lives in the Orlando area and wrote up some notes on the various challenges he ran into it. Out of it you might find a couple things worth thinking about adding into your DR plan. http://www.sqlservercentral.com/articles/Miscellaneous/disasterintherealworldhurricane/1472/2004/08/24http://www.sqlservercentral.com/articles/Miscellaneous/disasterintherealworldhurricane/1472/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/SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan. http://www.sqlservercentral.com/articles/Disaster+Recovery/backupscenariosforsuccessfulsqlserverrestoresandre/1421/2004/06/29http://www.sqlservercentral.com/articles/Disaster+Recovery/backupscenariosforsuccessfulsqlserverrestoresandre/1421/SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability. http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/2008/06/27http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others. http://www.sqlservercentral.com/articles/Disaster+Recovery/minidisasteracfailure/1370/2004/06/07http://www.sqlservercentral.com/articles/Disaster+Recovery/minidisasteracfailure/1370/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/This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role. http://www.sqlservercentral.com/articles/DTS/datamigrationoverview/639/2005/11/25http://www.sqlservercentral.com/articles/DTS/datamigrationoverview/639/As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dealingwithchangingdata/1233/2003/12/19http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dealingwithchangingdata/1233/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/This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading. http://www.sqlservercentral.com/articles/Security/sqlpermissionsdatareaderwriter/110/2003/10/10http://www.sqlservercentral.com/articles/Security/sqlpermissionsdatareaderwriter/110/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/