http://www.sqlservercentral.com/Articles tagged SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article describes how to enable Instant File Initialization in SQL Server 2005http://www.sqlservercentral.com/redirect/articles/63701/2008/07/14http://www.sqlservercentral.com/redirect/articles/63701/Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index.http://www.sqlservercentral.com/articles/Indexing/63533/2008/07/22http://www.sqlservercentral.com/articles/Indexing/63533/Build List Updated with Cumulative Update 8 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/07/17http://www.sqlservercentral.com/articles/Administration/2960/Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005. http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/2008/07/11http://www.sqlservercentral.com/articles/Administration/sqlserver2005serviceaccounts/2341/SQL Server 2005 will truly introduce a new paradigm in how developers and DBAs work with SQL Server. One area in which dramatic changes have taken place is DTS, which is now renamed to SQL Server Integration Services or SSIS. Expert author Jamie Thomson brings us a look at how the fundamentals of workflow change from DTS to SSIS. http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/thenewetlparadigm/1719/2008/07/04http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/thenewetlparadigm/1719/This article provides a step by step guide on how to export data to Microsoft Office Excel 2007http://www.sqlservercentral.com/redirect/articles/63451/2008/07/04http://www.sqlservercentral.com/redirect/articles/63451/This article is Part 2 in the series which explores the options available in SQL Server 2005 for Slowly Changing Dimensionshttp://www.sqlservercentral.com/redirect/articles/63450/2008/07/02http://www.sqlservercentral.com/redirect/articles/63450/This article describes how to generate the sp_who2 results including the query text for the spid.http://www.sqlservercentral.com/articles/Administration/63144/2008/06/26http://www.sqlservercentral.com/articles/Administration/63144/The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.http://www.sqlservercentral.com/articles/SQL+Server+2005/63300/2008/06/24http://www.sqlservercentral.com/articles/SQL+Server+2005/63300/Build List Updated with Cumulative Update 8 for SP2. http://www.sqlservercentral.com/articles/Administration/2960/2008/07/17http://www.sqlservercentral.com/articles/Administration/2960/One of the more interesting new technologies in SQL Server 2005 is database mirroring, allowing you to implement high availability on a database with commodity hardware. Jay Dave brings us a nice description of this technology. http://www.sqlservercentral.com/articles/SS2K5+-+High+Availability/3046/2008/06/18http://www.sqlservercentral.com/articles/SS2K5+-+High+Availability/3046/This article describes how to use variables in SSIS to dynamically generate folders and file placement.http://www.sqlservercentral.com/articles/SSIS/63152/2008/06/17http://www.sqlservercentral.com/articles/SSIS/63152/Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.http://www.sqlservercentral.com/articles/SQL+Server+2005/63184/2008/06/13http://www.sqlservercentral.com/articles/SQL+Server+2005/63184/SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command. http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/3041/2008/06/06http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/3041/In a followup to his article on SQL Server Everywhere, Jacob Sebastian takes a more in-depth look at the smallest platform for SQL Server, Compact Edtion. http://www.sqlservercentral.com/articles/2005+Compact+Edition/3040/2008/06/05http://www.sqlservercentral.com/articles/2005+Compact+Edition/3040/Steve Jones continues with his look at how SQL Server 2005 differs from SQL Server 2000, this time tackling the differences from a developer perspective. http://www.sqlservercentral.com/articles/News/3036/2008/05/29http://www.sqlservercentral.com/articles/News/3036/Encryption Keys validation for Reporting Services always being in force whether service is running or not.http://www.sqlservercentral.com/articles/Reporting+Services/62813/2008/05/27http://www.sqlservercentral.com/articles/Reporting+Services/62813/If you're like Brian Knight, you probably have dozens if not hundreds of DTS packages running around that you're terrified to touch. SQL Server 2005 has some interesting methods to upgrade your packages to SSIS with minimal effort. This article shows you a few ways that you can use to upgrade and some of the drawbacks. http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/upgradingsqlserver2000dtspackagestossis/2201/2008/05/23http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/upgradingsqlserver2000dtspackagestossis/2201/Pit your wits against the SQLServerCentral.com Friday crossword...http://www.sqlservercentral.com/articles/crossword/63127/2008/05/23http://www.sqlservercentral.com/articles/crossword/63127/Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities. http://www.sqlservercentral.com/articles/SS2K5+-+XML/3022/2008/05/22http://www.sqlservercentral.com/articles/SS2K5+-+XML/3022/SQL Server Integration Services is an incredibly rich and complex development environment that can handle almost any data movement task. Even those that do not involve SQL Server. Longtime author Tim Mitchell brings us a use that has nothing to do with SQL Server, but can be very handy for many of us. http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/3021/2008/05/21http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/3021/I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.http://www.sqlservercentral.com/redirect/articles/63130/2008/05/21http://www.sqlservercentral.com/redirect/articles/63130/The SQL Server 2005 Performance Dashboard is a new add-on to SQL Server 2005 that became available shortly after the release of Service Pack 2 for SQL Server 2005.http://www.sqlservercentral.com/redirect/articles/3018/2008/05/20http://www.sqlservercentral.com/redirect/articles/3018/How many of you have written resursive queries in SQL? Or any language since school for that matter? Not many people write recusrive queries because of the complexity, the difficulty to understand how they work, and the chance for heap overflows. However, SQL Server 2005 implements Common Table Expressions and recursion in a way that is much easier to code and incorporates some safeguards. New author SQL Server MVP Frederic Brouard has written a fantastic article looking at resursive queries. http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/recursivequeriesinsql1999andsqlserver2005/1846/2008/05/16http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/recursivequeriesinsql1999andsqlserver2005/1846/Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.http://www.sqlservercentral.com/redirect/articles/63024/2008/05/15http://www.sqlservercentral.com/redirect/articles/63024/SQL Server Integration Services, the ETL subsystem for SQL Server 2005, is a new paradigm of development for the SQL Server DBA. It is one of the most popular, and also complex, environments that many people work with in SQL Server 2005. Amit Lohia brings us an introduction to this environment along with the basics of building and deploying a package. http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2999/2008/05/14http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2999/In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access. As is the case with all systems, how does Access manage the changes? What happens when you modify the structure of the underlying SQL Server table? What happens to the SQL Server table if you delete the linked table in Access? We will look at each of these situations in this tip.http://www.sqlservercentral.com/redirect/articles/63022/2008/05/14http://www.sqlservercentral.com/redirect/articles/63022/One very interesting new feature in SQL Server 2005 is the ability to run backups to multiple locations, ensuring you have a second copy of the backup file if your first one were to be corrupted. SQL Server expert Andy Warren takes a look at how this feature works and the implications of using it. http://www.sqlservercentral.com/articles/SS2K5+-+High+Availability/2990/2008/05/12http://www.sqlservercentral.com/articles/SS2K5+-+High+Availability/2990/Some useful undocumented extended and stored procedures in SQL Server 2005http://www.sqlservercentral.com/articles/Stored+Procedures/62868/2008/05/09http://www.sqlservercentral.com/articles/Stored+Procedures/62868/What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences. http://www.sqlservercentral.com/articles/Administration/2988/2008/05/08http://www.sqlservercentral.com/articles/Administration/2988/