SQL Server Magazine

		Options
SSMA: Migration Made Easy Migrating to SQL Server is an increasingly difficult task to prepare for and accomplish. SQL Server Migration Assistant can help you outline tasks, convert PL/SQL to T-SQL, migrate datas, test migrated objects, and deploy your migrated database.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Kick a User Out of a Database in Just 2 Steps

By gathering information from sysprocesses and running KickUserOut.sql, you can terminate processes that are impeding a server's performance.
By Omri Bahat 

Get Connected with LINQ

Language-Integrated Query (LINQ) is the long-awaited wave of the future, and its benefits definitely outweigh its drawbacks.
By Michael Otey 

Display Dates in the Format You Need

If you often need to display the current date in different formats, you know that it can take a lot of code and effort. The FormatDate function changes that. By providing just two parameters, you can display any date in the format you need.
By Readers 

Keep Track of Your Backups

The procedure cspBackupListing can list your databases’ most current backups, back up databases with previous backups older than 24 hours, or list all the backups for a database.
By Readers 

Combining SQL and TEMPLATE Plan Guides

By using both TEMPLATE plan guides, which enable autoparameterization, and SQL plan guides, which let you specify many query-processing hints, you can optimize query performance.
By Kalen Delaney 

Data Warehousing: Measuring the Facts

With dimensional modeling, you can build a user-friendly data structure that makes data access intuitive. Start by learning the components of the dimensional model and why they're designed as they are.
By Michelle A. Poolet 

Debunking the Myths of Temporary Objects, Part 2

Last month's discussion was pretty theoretical. Now, we dig deeper by offering concrete examples to clarify the topic of temporary objects.
By Itzik Ben-Gan 

Letters to the Editor

By Readers  , et al.

New Products

Check out new and improved SQL Server–related products.
By Blake Eno 

New Features in SQL Server 2008

Here's a preview of SQL Server 2008 features that just might add a smile to your face: enhanced Microsoft Office integration, the ability to hot-add CPUs, and more goodies DBAs are sure to welcome.
By Michael Otey 

SQL Server Automation Scripts

Microsoft makes available a variety of scripts that its own Database Operations team uses for automating maintenance jobs—and they're free.
By Kevin Kline 

ApexSQL Log

Need some help with SQL Server database recovery and log auditing? Our review of ApexSQL Log will help you decide whether this app fits your needs.
By John Green 

Database Auditing and Compliance Products

An emerging selection of software- and appliance-based products augment SQL Server 2005’s basic auditing capabilities, to help you keep data secure and in compliance with government regulations.
By Jeff James 

SQL Server Migration Assistant

Do you want to move to SQL Server from Oracle, but aren't sure how difficult the data conversion and migration will be? Find out how SSMA for Oracle can help you more easily move to SQL Server.
By Andrew Sisson 

Getting to Know Virtual File Stats

This built-in SQL Server 2005 DMV lets you see exactly what type of physical I/O your SQL Server system is experiencing when you're reading from or writing to the files on disk. Learn how to get the most out of it.
By Andrew Kelly 

What's the Best Way to Carve Up a SAN?

Your SAN engineer might not know the finer points of BI database storage. To stave off trouble, you need to be involved in the SAN configuration process.
By Douglas McDowell