SQL Server Pro

Connect With Us

High Availability

  1. SQL Server 2012 High Availability  4
  2. Confusing High Availability with Disaster Preparedness 2
  3. The Price of High Availability 3
T-SQL Code
4 Techniques to Improve the Readability of Your Dynamic T-SQL Code
T-SQL Parameters and Variables: Basics and Best Practices 1
Unwanted T-SQL Expression Failures
Latest News
May 21, 2013
blog

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
May 21, 2013
Article

Back Up Your SQL Server Databases with CloudBerry Backup

CloudBerry Backup for SQL Server automates the process of backing up SQL Server databases to more than 15 supported cloud storage platforms, including Amazon S3, Amazon Glacier, Windows Azure, and more....More
May 20, 2013
Article

Attunity Replicate Now Includes New Data Warehousing Enhancements

The latest version of Attunity Replicate now offers more data warehousing capabilities for Microsoft SQL Server 2012....More
May 17, 2013
Article

Get Relevant Data from Panorama Necto Right from Your Mobile Device

Panorama Necto now delivers more corporate business intelligence (BI) and intuitive data discovery capabilities for DBAs in this new release....More
5 padlocks representing SQL Server encryption options
May 17, 2013
Article

SQL Server Encryption Options 3

SQL Server 2012 can encrypt data--and has many different encryption capabilities. Let us guide you through which ones to use....More
May 16, 2013
Article

Using Effective Dating in Type Tables 1

By utilizing effective dating in your type tables, you can track when a record is created, modified, and removed, which can prevent reporting and archiving problems....More
May 16, 2013
Article

Unwanted T-SQL Expression Failures

Itzik discusses expression failures in T-SQL queries and presents a proposal to Microsoft for a new T-SQL feature called TRY_EXPRESSION that would provide a more general solution for preventing expression failures....More
data flow
May 13, 2013
Article

SSIS Deployment Strategy for SQL Server 2012

By taking advantage of the new SSISDB catalog and database in SQL Server 2012, you can streamline your SSIS deployments and prevent many configuration and deployment problems....More
May 13, 2013
Sponsored
SQL Server Pro

Why Data Quality Matters – A DBA and IT Perspective

To applications, data is everything and it drives what a DBA does. Bad data produces bad results for what an application is designed for. Cluster MVP, Allan Hirt, and Data Quality Analyst, Joseph Vertido, join together to present educational information on why data quality matters......More
code
May 9, 2013
Article

PowerShell the SQL Server Way

For SQL Server professionals, Windows PowerShell has been something of a mystery. Here's an introduction to the SQLServer Provider and sqlps cmdlets....More
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
May 7, 2013
video

SQL Server Community Events and Organizations

Learn more about the SQL Server professional community from SQL Server Pro Senior Technical Director, Michael Otey....More
SQL Server 2012 signs at a conference
May 7, 2013
Article

The SQL Server Community

SQL Server community events like SQL Server Connections and PASS Summit give you a chance to network with your peers while also gaining in-depth training from industry experts....More
IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Michael Otey & Tim Ford in Person!

Early Registration Now Open

Upcoming Training

SQL Server Foundations 2013

If you’re new to SQL Server or just looking to brush up on your skills, register now for this eLearning course focusing on the various versions of SQL server, performance tuning, implementing backups as well as crucial SQL Server basics. You’ll learn about the core concepts every DBA should know and how things outside of SQL Server affect and influence your daily tasks.

EARLY BIRD PRICING NOW!

Register Now

Current Issue
Getting the Most out of Microsoft Power View - 6 tips, as well as some recent enhancements to PowerView.

CURRENT ISSUE
ARCHIVE
SUBSCRIBE

From the Blogs
May 21, 2013
blog

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
Featured Products
T-SQL Black Belt
A collection of 21 articles from SQL Server Pro and written by Itzik Ben-Gan that demonstrate practical, ...
Truth Art, and the Zen of SQL Server Performance Tuning
Some say performance tuning SQL Server is an art; others say it’s a science. In this 3 session online training SQLHA’s Ben DeBow will take you on a journey through not only SQL Server-specific factors ...
Project Plan: SQL Server 2008 & 2008 R2 Migration
Congratulations on making the decision to migrate to SQL Server 2008 or 2008 R2! The SQL Server 2008 & 2008 R2 Migration Project Plan will assist you every...
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Readers Contribute

If you would like to submit an article, please ensure you are logged in and then click Contribute.

If you are not a registered user on SQL Server Pro, click Register.

SQLMag.com
Related Sites
Copyright © 2013 Penton Media, Inc