Best of SQL Server Central Vol 5 pulls together some of the best, most popular, and the most read article of 2007, in dead tree format, covering database administration, BI, ETL, design, security, T-SQL, XML and more besides.
Contents
- Administration
- SQL 2000 to SQL 2005: Where have all the old features gone?
- Stress Testing Your SQL Server Databases – A Systematic Approach
- Intro to Database Mail in SQL 2005
- The OUPUT Command
- Running a Query Using a Text File for Input
- Starting SQL Server in Minimal Configuration
- How SQL Server Chooses the Type of Join
- Indexes and Fragmentation in SQL Server 2000
- Indexing in SQL Server 2005
- Database Snapshots
- Database Snapshots in SQL Server 2000
- Customizable Error Log Scanning
- A Guide to Application Memory Tuning
- Eliminating Tape
- Full Text Search Follies
- SQL Stored Procedure to Log Updates, Independent of Database Structure
- Identifying Unused Objects in a Database
- Upgrading a Database SQL 2000 to SQL 2005
- Maximum Row Size in SQL Server 2005
- Dynamic Management Views and Functions in SQL Server 2005
- Backing Up a Database with SMO
- Document Your Database
- A Transactional Replication Primer
- T-SQL
- Keyword Searching in SQL Server
- Recursive Queries in SQL: 1999 and SQL Server 2005
- Serializing Procedure Calls Without Unnecessary Blocking
- The Truth Table
- Introduction to Bitmasking in SQL Server 2005
- Self Eliminated Parameters
- Finding Primes
- CTE Performance
- The Effect of NOLOCK on Performance
- Converting Hexadecimal String Values to Alpha (ASCII) Strings
- A Refresher on Joins
- Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005
- When To Use Cursors
- Everybody Reports to Somebody
- Not In v Not Equal
- Full Control Over a Randomly Generated Password
- Performance Effects of NOCOUNT
- Passing a Table to A Stored Procedure
- New Column Updates
- The T-SQL Quiz
- Practical Methods: Naming Conventions
- Large Object Data
- Row-By-Row Processing Without Cursor
- Security
- SQL 2005 Symmetric Encryption
- Ownership Chaining
- Preventing Identity Theft Using SQL Server
- ETL and BI
- A Common Architecture for Loading Data
- Overview of SSIS
- SSIS – Transfer SQL Server Objects Debugged
- SSIS Is Not Just for SQL Server
- SSIS Programming
- Loading a 24×7 Data Warehouse
- More Problems with Data Warehousing
- Storage Modes in SSAS 2005
- Dynamic Connection Strings in Reporting Services 2005
- Populating Fact Tables
- Reporting Services 2005 101 with a Smart Client
- Data Driven Subscriptions for Reporting Services (2000 and 2005)
- Service Broker
- Adventures With Service Broker
- Building a Distributed Service Broker Application
- XML
- The SQL Server 2005 XML Temptress
- I’ve Got the XML – Now What?
- XML Argument Protocols for SQL 2005 Stored Procedures
- Windows Utilities for the SQL Server DBA
- From DBA to DBAA
- What’s a Good Manager
Posted in 
