The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Umachandar Jayachandran
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 Kalen Delaney
Kalen Delaney, whose Inside SQL Server column has been an integral part of SQL Server Magazine since the first issue, reminisces about the magazine’s origins.
By
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 Eli Leiba
The sp_markAllMasterDBasSystem stored procedure can help protect the T-SQL objects you've created by marking them as system objects.
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 Kevin Kline
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 William Vaughn
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.
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 Karen Forster
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 Jan De Clercq
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 Itzik Ben-Gan
Get the solution to May's puzzle "Missing Element in a Series," and prepare your mind for June's puzzle, which involves the chances that people share the same birthday.
This fifth part of a series about datetime challenges and calculations focuses on techniques for calculating working days, age, and next birthday date.
By Rodney Landrum
SQL Server Reporting Services (SSRS) lets you use repository data to create customized reports about job status, database backup status, and server details.
By Asif Sayed
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 Dawn Cyr
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.
What you need to understand the distinction between query and report parameters.
By Michael Otey
These 5 SQL Server tools in the February 2007 Feature Pack for Microsoft SQL Server 2005 might save you time and frustration.
advertisement