By William Vaughn, 05/23/2007
What you need to understand the distinction between query and report parameters.
By Kalen Delaney, 05/23/2007
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, 05/23/2007
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 Eli Leiba, 05/23/2007
The sp_markAllMasterDBasSystem stored procedure can help protect the T-SQL objects you've created by marking them as system objects.
By Itzik Ben-Gan, 05/23/2007
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.
By Dawn Cyr, 05/23/2007
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 ...
By Asif Sayed, 05/23/2007
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 Umachandar Jayachandran, 05/23/2007
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 ...
By William Vaughn, 05/23/2007
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, ...
By Michael Otey, 05/23/2007
These 5 SQL Server tools in the February 2007 Feature Pack for Microsoft SQL Server 2005 might save you time and frustration.
By Karen Forster, 05/23/2007
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 Rodney Landrum, 05/23/2007
SQL Server Reporting Services (SSRS) lets you use repository data to create customized reports about job status, database backup status, and server details.
By Kalen Delaney, 05/23/2007
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 ...
By Jan De Clercq, 05/23/2007
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 Readers, 05/23/2007
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 Kevin Kline, 05/23/2007
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 Itzik Ben-Gan, 05/23/2007
This fifth part of a series about datetime challenges and calculations focuses on techniques for calculating working days, age, and next birthday date.