SQLServerCentral.com Articles

SQLServerCentral.com Articleshttp://www.sqlservercentral.com/Articles posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Undocumented Extended and Stored Procedureshttp://www.sqlservercentral.com/articles/Stored+Procedures/62868/2009/11/20http://www.sqlservercentral.com/articles/Stored+Procedures/62868/Interview with the Scary DBA - Grant Fritchey http://www.sqlservercentral.com/redirect/articles/68784/2009/11/20http://www.sqlservercentral.com/redirect/articles/68784/SQL Server Security Audit Report

Free “SQL Server Tacklebox” eBook
Download the eBook for expert advice on tackling
SQL Server issues and try out SQL Response
to be alerted to problems on your SQL Servers.

]]>http://www.sqlservercentral.com/redirect/articles/68795/2009/11/20http://www.sqlservercentral.com/redirect/articles/68795/Let's Talk Ownership (and SQL Jobs)

New product just released!
Recover individual database objects from native SQL Server
backups and restore them to any database. Download a free trial
of Red Gate’s new SQL Object Level Recovery Native™.

]]>http://www.sqlservercentral.com/articles/SQL+Jobs/68764/2009/11/19http://www.sqlservercentral.com/articles/SQL+Jobs/68764/The WorkTamer Conference http://www.sqlservercentral.com/articles/Conferences+and+Events/68799/2009/11/19http://www.sqlservercentral.com/articles/Conferences+and+Events/68799/Installing SQL Server 2005 Reporting Services 32-bit on a 64-bit Windows Server systemhttp://www.sqlservercentral.com/redirect/articles/68794/2009/11/19http://www.sqlservercentral.com/redirect/articles/68794/Full Text Index Implementation in SQL Server 2005 Express Edition

NEW! Object recovery for SQL Server
Recover individual database objects from native SQL Server
backups and restore them to any database. Download a free trial
of Red Gate’s new SQL Object Level Recovery Native™.

]]>http://www.sqlservercentral.com/redirect/articles/68797/2009/11/19http://www.sqlservercentral.com/redirect/articles/68797/Introduction to Indexes: Part 3 – The nonclustered indexhttp://www.sqlservercentral.com/articles/Indexing/68636/2009/11/18http://www.sqlservercentral.com/articles/Indexing/68636/Mediocrity Defendedhttp://www.sqlservercentral.com/articles/Raw+Materials/68762/2009/11/18http://www.sqlservercentral.com/articles/Raw+Materials/68762/SQL Server 2008 Build Listhttp://www.sqlservercentral.com/articles/SQL+Server+2008/63491/2009/11/18http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/Pivoting, Unpivoting and Aggregating

Free “How to Become an Exceptional DBA (2nd ed.)” eBook
Download your copy and a free trial of Red Gate SQL Backup for
robust SQL Server database backups.

]]>http://www.sqlservercentral.com/redirect/articles/68782/2009/11/18http://www.sqlservercentral.com/redirect/articles/68782/SQL Server 2008 Upgrade Gotchas & Fixeshttp://www.sqlservercentral.com/articles/SQL+Server+2008/67066/2009/11/17http://www.sqlservercentral.com/articles/SQL+Server+2008/67066/Exceptional DBA Josef Richberg: fighting cancer, but still sharinghttp://www.sqlservercentral.com/articles/Exceptional+DBA/68737/2009/11/17http://www.sqlservercentral.com/articles/Exceptional+DBA/68737/How to Detach and Attach a SQL Server FILESTREAM Enabled Databasehttp://www.sqlservercentral.com/redirect/articles/68721/2009/11/17http://www.sqlservercentral.com/redirect/articles/68721/REPLACE Multiple Spaces with Onehttp://www.sqlservercentral.com/articles/T-SQL/68378/2009/11/16http://www.sqlservercentral.com/articles/T-SQL/68378/TSQL Challenge 17 - Creating cross rows references with inline hyperlinkshttp://www.sqlservercentral.com/redirect/articles/68726/2009/11/16http://www.sqlservercentral.com/redirect/articles/68726/Full Text Catalog Configuration in SQL Server 2005 Express Editionhttp://www.sqlservercentral.com/redirect/articles/68720/2009/11/16http://www.sqlservercentral.com/redirect/articles/68720/Real World Foreach Loop Container examplehttp://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61987/2009/11/13http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61987/Grant Execute Permissions to Stored Procedures using DDL Triggershttp://www.sqlservercentral.com/redirect/articles/68718/2009/11/13http://www.sqlservercentral.com/redirect/articles/68718/Database defintion from an Excel Spec?http://www.sqlservercentral.com/articles/Excel/66806/2009/11/12http://www.sqlservercentral.com/articles/Excel/66806/SQL Azure TSQLhttp://www.sqlservercentral.com/redirect/articles/68719/2009/11/12http://www.sqlservercentral.com/redirect/articles/68719/Introduction to Indexes: Part 2 – The clustered indexhttp://www.sqlservercentral.com/articles/Indexing/68563/2009/11/11http://www.sqlservercentral.com/articles/Indexing/68563/Best Practices – When Using FILESTREAM Feature of SQL Server 2008http://www.sqlservercentral.com/redirect/articles/68715/2009/11/11http://www.sqlservercentral.com/redirect/articles/68715/Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

]]>http://www.sqlservercentral.com/articles/T-SQL/68467/2009/11/10http://www.sqlservercentral.com/articles/T-SQL/68467/Writing Custom Rules for FxCophttp://www.sqlservercentral.com/redirect/articles/68645/2009/11/10http://www.sqlservercentral.com/redirect/articles/68645/An Un-indexed Foreign Key Gotchahttp://www.sqlservercentral.com/articles/T-SQL/68337/2009/11/09http://www.sqlservercentral.com/articles/T-SQL/68337/What a Data Warehouse is Not http://www.sqlservercentral.com/redirect/articles/68641/2009/11/09http://www.sqlservercentral.com/redirect/articles/68641/Introduction to the Transaction Loghttp://www.sqlservercentral.com/articles/Design+and+Theory/63350/2009/11/06http://www.sqlservercentral.com/articles/Design+and+Theory/63350/Using T-SQL CROSS APPLY and OUTER APPLYhttp://www.sqlservercentral.com/redirect/articles/68647/2009/11/06http://www.sqlservercentral.com/redirect/articles/68647/Troubleshooting Reporting Services Performance Issueshttp://www.sqlservercentral.com/redirect/articles/68643/2009/11/06http://www.sqlservercentral.com/redirect/articles/68643/