SQL Server Magazine

		Options
Securing Your SQL Server Environment A secure database environment is the necessary foundation from which a DBA builds everything on. Learn how to secure your database, adapt to network security considerations, and discover best practices for data encryption.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Securing Your SQL Server Environment

Locking down your database environment can be a difficult task, but it doesn’t have to be. Learn how to protect your databases by using service accounts and encryption to secure your database files and network.
By William Sheldon 

Enforce Multitable Constraints Using Indexed Views

If you need to enforce business rules on multiple tables, try indexed views, which let you join tables and enforce uniqueness on the result set.
By Aviv Zucker 

Pivoting the Dynamic Way

The PIVOT statement is a great tool for presenting data in an easy-to-read format, but it has one key limitation: You must know about and include all the column names in the PIVOT query. You can work around this limitation with dynamic pivoting.
By Mitchel Sellers 

SQL Server Reporting Services Questions Answered

Use these techniques and sample reports to get answers to your most frequently asked reporting questions.
By Tyler Chessman 

The Inevitable Virtualization of SQL Server

Improvements in performance and scalability in ESX Server and Hyper-V are making SQL Server a viable candidate for virtualization.
By Michael Otey 

Simple String Encryption and Decryption

In SQL Server 2008 and SQL Server 2005, one of the easiest ways to encrypt and decrypt strings is to use T-SQL's ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE functions.
By Eli Leiba 

T-SQL Statement Tracks Transaction-Less Dates

A DBA was asked to produce a list of dates in which there were no transactions from a database that included only the dates in which there were transactions. Here's how he pulled it off.
By Saravanan Radhakrishnan 

Calculating Concurrent Sessions, Part 1

Itzik discusses a set-based and a cursor-based solution to a T-SQL concurrent sessions querying problem, as well as the performance and scaling ramifications of both solutions.
By Itzik Ben-Gan 

7 Facts About SQL Azure

Get the basics on SQL Azure, formerly SQL Data Services, Microsoft’s SQL Server-based database cloud offering.
By Michael Otey 

Database Growth Tracker

Track database growth across multiple SQL Server instances using this CLR stored procedure.
By Kevin Kline 

Time to Defrag Your Indexes?

When is the right time to defrag? Ultimately, the answer is up to you, but keep these considerations in mind.
By Andrew J. Kelly