SQL Server Magazine

		Options
Protect SQL Server 2005 in 10 Steps Simply deploying SQL Server 2005 without using its security features puts you at risk. Follow these defense-in-depth steps to secure the database server before, during, and after installation.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Don't Be Afraid of BLOBs and CLOBs

With SQL Server 2005's three new LOB data types and CLR functionality, you can easily compress and decompress large amounts of data.
By Yoel Martinez 

Excel 2007's Powerful PivotTables

Microsoft Excel 2007 PivotTables give you more ways than ever to analyze and present data from SQL Server Analysis Services 2005 OLAP cubes.
By Tyler Chessman 

Moving Cubes from Analysis Services 2000 to 2005

Deciding to upgrade from Analysis Services 2000 to 2005 might be a no-brainer, but figuring out how to move your cubes can be a more complicated process. Here are some key concepts to help you decide whether to migrate or rebuild your cubes.
By Erin Welker 

BI: Pass the Status Quo

BI is definitely not just Microsoft hype. The value in BI technologies is how they help businesses obtain more information from their data.
By Michael Otey 

Change the Status of Table Items

By Umachandar Jayachandran 

A Quick and Easy Way to View Errorlog Files

Using sp_ShowErrors to view SQL Server errorlog files is time-saving alternative to manually reviewing them in Enterprise Manager.
By Bill McEvoy 

Procedure Helps Pinpoint Problematic Processes

Here's a stored procedure that displays all the T-SQL statements currently being executed along with the IDs of the processes running those statements.
By Eli Leiba 

UDF Eliminates Concatenation Woes

If you often need to provide multiple values in a variable but find the 8,000-character limit too restrictive, give dbo.fn_AddToBuffer a try.
By Readers 

Use Missing-Index Groups for Query Tuning

Identify and implement missing-index groups to tune your queries, and use SQL Server 2005's XML Showplan output feature to examine detailed missing-index information.
By Kalen Delaney 

DATETIME Calculations, Part 3

This third part of a series about datetime challenges and calculations focuses on techniques for calculating the date of the last/next occurrences of a weekday that correspond to a given event date.
By Itzik Ben-Gan 

Letters to the Editor

By Readers  , et al.

New Products

By Blake Eno 

Size Up Team Data

Before you buy Visual Studio Team Edition for Database Professionals, get more information about it with these 5 resources, including blogs, a forum, and a trial version for downloading.
By Michael Otey 

Analysis Services Samples

The SQL Server 2005 Analysis Services samples perform functions that aren’t otherwise available in SQL Server Management Studio (SSMS) or the SQL Server Business Intelligence Development Studio (BIDS). Here are several that you should add to your toolkit.
By Kevin Kline 

SQL Server Performance Monitoring and Management Tools

Both Idera's SQL diagnostic manager and Quest Software's Spolight on SQL Server Enterprise can help you quickly detect and diagnose problems with your SQL servers.
By John Green 

10 Steps to SQL Server 2005 Security

Apply protection at the perimeter, network, host, application, data, and physical environment layers of your database installation.
By John Howie