http://www.sqlservercentral.com/Content tagged SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/2007/07/13http://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/2006/11/03http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/thenewetlparadigm/1719/Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at nighthttp://www.sqlservercentral.com/scripts/Indexing/63036/2008/05/07http://www.sqlservercentral.com/scripts/Indexing/63036/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/2007/07/17http://www.sqlservercentral.com/articles/SS2K5+-+High+Availability/3046/A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.http://www.sqlservercentral.com/scripts/Miscellaneous/63094/2008/05/13http://www.sqlservercentral.com/scripts/Miscellaneous/63094/A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.http://www.sqlservercentral.com/scripts/T-SQL/62978/2008/04/30http://www.sqlservercentral.com/scripts/T-SQL/62978/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/2007/07/09http://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/2007/07/10http://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/2007/05/31http://www.sqlservercentral.com/articles/News/3036/Index maintenance procedure using rebuild or reorganized based on fragementation level.http://www.sqlservercentral.com/scripts/Maintenance/62695/2008/03/28http://www.sqlservercentral.com/scripts/Maintenance/62695/Pit your wits against the SQLServerCentral.com Friday crossword...http://www.sqlservercentral.com/articles/crossword/63127/2008/05/15http://www.sqlservercentral.com/articles/crossword/63127/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/2006/09/04http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/upgradingsqlserver2000dtspackagestossis/2201/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/2007/06/20http://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/2007/06/25http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/3021/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/2007/06/06http://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/http://www.sqlservercentral.com/questions/SQL+Server+2005/62776/2008/05/08http://www.sqlservercentral.com/questions/SQL+Server+2005/62776/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/Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade. http://www.sqlservercentral.com/articles/Administration/2987/2008/05/07http://www.sqlservercentral.com/articles/Administration/2987/Learn what a Dates table is and how to create one, and then try it out for yourselfhttp://www.sqlservercentral.com/redirect/articles/62914/2008/05/06http://www.sqlservercentral.com/redirect/articles/62914/Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005. http://www.sqlservercentral.com/articles/SS2K5+-+XML/2982/2008/05/05http://www.sqlservercentral.com/articles/SS2K5+-+XML/2982/SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008http://www.sqlservercentral.com/articles/Compression/62746/2008/05/05http://www.sqlservercentral.com/articles/Compression/62746/This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model). http://www.sqlservercentral.com/scripts/Miscellaneous/62468/2008/05/02http://www.sqlservercentral.com/scripts/Miscellaneous/62468/http://www.sqlservercentral.com/questions/SQL+Server+2005/62655/2008/05/01http://www.sqlservercentral.com/questions/SQL+Server+2005/62655/http://www.sqlservercentral.com/questions/SQL+Server+2005/62652/2008/04/30http://www.sqlservercentral.com/questions/SQL+Server+2005/62652/