http://www.sqlservercentral.com/Content tagged SQL Server 2005, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/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/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/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/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/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/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/Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.http://www.sqlservercentral.com/redirect/articles/3072/2007/07/05http://www.sqlservercentral.com/redirect/articles/3072/Robyn Page delves into all the things you need to know, rather than want to know, about SQL Server replication.http://www.sqlservercentral.com/redirect/articles/3010/2007/05/30http://www.sqlservercentral.com/redirect/articles/3010/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/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 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/A series of tips on optimizing XML in your SQL Server databases. http://www.sqlservercentral.com/redirect/articles/2869/2007/02/21http://www.sqlservercentral.com/redirect/articles/2869/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/In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins! http://www.sqlservercentral.com/redirect/articles/2852/2007/02/12http://www.sqlservercentral.com/redirect/articles/2852/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/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/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/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/Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data. http://www.sqlservercentral.com/articles/Monitoring/2680/2006/11/08http://www.sqlservercentral.com/articles/Monitoring/2680/Continuing with his series on monitoring space, Roy Carlson looks at checking the space in a folder to be sure your SQL Server databases never run out of storage. http://www.sqlservercentral.com/articles/Monitoring/2679/2006/11/07http://www.sqlservercentral.com/articles/Monitoring/2679/Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting. http://www.sqlservercentral.com/articles/Performance+Tuning/2677/2006/10/30http://www.sqlservercentral.com/articles/Performance+Tuning/2677/It's small and neat but it might just save your data...Robyn Page's crib sheet tells you everything you wanted to know about SQL Server backup but were afraid to ask.http://www.sqlservercentral.com/redirect/articles/2654/2006/10/20http://www.sqlservercentral.com/redirect/articles/2654/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/Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting. http://www.sqlservercentral.com/articles/Performance+Tuning/2639/2006/10/04http://www.sqlservercentral.com/articles/Performance+Tuning/2639/