http://www.sqlservercentral.com/Articles tagged 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/Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications. http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/2007/07/20http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/bookmarklookups/1899/2008/07/18http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/bookmarklookups/1899/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/As much as we're SQL Server folks here, sometimes we do need to connect to other data stores. Hai shares some of his experiences doing so. Might come in handy someday. http://www.sqlservercentral.com/articles/Miscellaneous/oracleandsqlserverdatainteroperabilityissuespart1/1332/2008/06/06http://www.sqlservercentral.com/articles/Miscellaneous/oracleandsqlserverdatainteroperabilityissuespart1/1332/In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2008/05/30http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/2008/05/09http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/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 injection has been a hot topic the last couple years and there are some great articles at SQLServerCentral.com on this topic. Michael Coles brings us an updated look at this SQL Server security issue with some new examples you might not have previously thought. http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/2008/03/21http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages. http://www.sqlservercentral.com/articles/DTS/2929/2008/03/19http://www.sqlservercentral.com/articles/DTS/2929/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/SQL Server 2005 includes an amazing ETL environment in Integration Services, but many DBAs will be using DTS and SQL Server 2000 for years to come. Jambu Krishnamurthy brings us a few handy examples of how you can customize your DTS environment. http://www.sqlservercentral.com/articles/DTS/2851/2008/02/08http://www.sqlservercentral.com/articles/DTS/2851/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/When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools. http://www.sqlservercentral.com/articles/Miscellaneous/2801/2008/01/14http://www.sqlservercentral.com/articles/Miscellaneous/2801/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/When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS. http://www.sqlservercentral.com/articles/DTS/2781/2007/12/31http://www.sqlservercentral.com/articles/DTS/2781/While SQL Server 2005 is greatly changing the paradigm of ETL with Integration Services, SQL Server 2000 and DTS will be here for some time to come. New author Rama Nageshwara brings us an overview of this fantastic data movement toolset. http://www.sqlservercentral.com/articles/DTS/overviewofdtspackages/2127/2007/12/21http://www.sqlservercentral.com/articles/DTS/overviewofdtspackages/2127/Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system. http://www.sqlservercentral.com/articles/Performance+Tuning/2764/2007/12/17http://www.sqlservercentral.com/articles/Performance+Tuning/2764/While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer. http://www.sqlservercentral.com/articles/DTS/2762/2007/12/14http://www.sqlservercentral.com/articles/DTS/2762/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/SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns. http://www.sqlservercentral.com/articles/Replication/alteringacolumnonareplicatedtable/1666/2007/11/30http://www.sqlservercentral.com/articles/Replication/alteringacolumnonareplicatedtable/1666/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/Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean. http://www.sqlservercentral.com/articles/Replication/3199/2007/09/24http://www.sqlservercentral.com/articles/Replication/3199/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/While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need. http://www.sqlservercentral.com/articles/Monitoring/3201/2007/09/06http://www.sqlservercentral.com/articles/Monitoring/3201/