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.
Book Description
Here’s a selection of articles to help you manage your instances a bit better and perhaps learn about some parts of SQL Server that you don’t get to deal with in your own systems. We tackle upgrades, stress testing, mail, and more. As we compile this 5th edition, Microsoft SQL Server is a very mature product that is mostly being limited by its architecture as hardware continues to grow in power, loads increase, and many different stresses occur. Nothing earth-shattering here, just some good information that might help you save the day.
Table of 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