---

[Features]

---

Managing ReportViewer Parameters
How do you filter a Reporting Services report at runtime? Stumped? SQL Server guru William Vaughn explains how you can use the ReportViewer control in server mode to collect, validate, and pass parameters to Reporting Services.
 — William Vaughn


Secure Access to Report Data
Restrict and secure access to SQL Server Reporting Services report data by linking SSRS roles to report folders, then mapping roles to AD users and groups.
 — Jan De Clercq


Store RTF Data in a SQL Server Database
By using Windows Forms and a C# script, you can easily store and retrieve Rich Text Format data in a SQL Server 2005 database table.
 — Asif Sayed

---

[Editorial]

---

Insane Devotion to SQL Server Pros
Karen Forster reflects on SQL Server Magazine's 100th issue, how the magazine originated, and the promises we still strive to keep for our readers.
 — Karen Forster

---

[Reader Challenge]

---

Optimizing Queries for Fact Tables
Help a DBA devise a scheme that lets him easily optimize two queries. The indexing scheme or optimization technique that you come up with should be flexible enough to help with the queries use a table.
 — Umachandar Jayachandran

---

[Reader to Reader]

---

BINARY_CHECKSUM Query Better for Big Table Samplings
Selecting a random sampling of rows from a large table in SQL Server 2000 used to take a long time and use a lot of disk I/O. The BINARY_CHECKSUM query changes all that.
 — Readers

Protect Your T-SQL Objects from Deletion
The sp_markAllMasterDBasSystem stored procedure can help protect the T-SQL objects you've created by marking them as system objects.
 — Eli Leiba

---

[Inside SQL Server]

---

Help with Examining Parallel-Query Plans
Here's how to simulate multiple processors by changing a setting in SQL Server Configuration Manager, so that you can examine plans for parallel queries.
 — Kalen Delaney


The XML Query-Plan Treasure Trove
Viewing SQL Server 2005 query plans in XML format gives you more-detailed insights into query performance, and Microsoft's free XML Notepad 2007 tool makes such plans easier to read.
 — Kalen Delaney

---

[T-SQL Black Belt]

---

DATETIME Calculations, Part 5
This fifth part of a series about datetime challenges and calculations focuses on techniques for calculating working days, age, and next birthday date.
 — Itzik Ben-Gan

---

[SELECT TOP(X)]

---

SQL Server 2005 Feature Pack
These 5 SQL Server tools in the February 2007 Feature Pack for Microsoft SQL Server 2005 might save you time and frustration.
 — Michael Otey

---

[Tool Time with Kevin Kline]

---

Best Practices Analyzer
This free tool gathers data from the Windows OS and SQL Server configuration settings and points out potential problems. Here are some of the upgrades in the latest release.
 — Kevin Kline

---

[Buyer's Guide]

---

Continuous Data Protection
CDP isn't just for the enterprise anymore—vendors are stepping up to provide continuous data protection that even SMBs might consider, thanks to lower cost solutions and creative licensing levels.
 — Dawn Cyr

---

[Cover Story]

---

SQL Server Reporting Services
SQL Server Reporting Services (SSRS) lets you use repository data to create customized reports about job status, database backup status, and server details.
 — Rodney Landrum