SQL Server Magazine

		Options
100: Still Crazy After All These Issues Thank you for your loyalty, as we celebrate 100 issues! We're still insanely devoted to providing technically accurate information to help you do your job. In this issue: Tap into repository data, and master ReportViewer controls.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

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.
By 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.
By 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.
By Asif Sayed 

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.
By Karen Forster 

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.
By Umachandar Jayachandran 

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.
By 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.
By Eli Leiba 

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.
By 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.
By Kalen Delaney 

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.
By Itzik Ben-Gan 

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.
By Michael Otey 

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.
By Kevin Kline 

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.
By Dawn Cyr 

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.
By Rodney Landrum