MS SQL Server Tutorials, Tools & More

SQL Overview

First released for IBM OS/2 in 1989, Microsoft SQL Server has developed over the years into one of the leading relational database management system (RDMS) platforms for the enterprise for the Windows Server platform. The most current version is SQL Server 2012, which is available in Standard, Enterprise, and Business Intelligence editions.

Sponsored | SQL

Recent SQL Articles

SQL Server 2014 Released to Manufacturing

By Jeff James - March 18, 2014

Microsoft SQL Server 2014 has been released to manufacturing, and customers can download the new version on April 1st.

What's New in SQL Server 2014

By Jeff James - June 6, 2013

Curious what new features Microsoft SQL Server 2014 offers? We've updated this guide with the latest info to help you decide if you're due for an upgrade.

How to Connect CentOS Web Server to a SQL Server

By Peter Washburn - October 15, 2012

Learn how to set up an internal CentOS web server to talk to a SQL server in this handy how-to article.

Beginning SSIS: How to Create a Basic Data Load Package in SQL Server Integration Services

By Jennifer McCown, MidnightDBA Guru - February 11, 2011

Step-by-step guide by Jennifer McCown on creating a basic data load package in SQL Server Integration Services. SSIS is used to extract data from sources such

Editor's Picks

How to Connect CentOS Web Server to a SQL Server

By Peter Washburn - October 15, 2012

Learn how to set up an internal CentOS web server to talk to a SQL server in this handy how-to article.

Changing SQL Server Job Owners with PowerShell

By Sean McCown Microsoft SQL MVP - January 26, 2011

Using PowerShell for changing job owners in SQL Server. Sean McCown demonstrates how PowerShell is a more efficient option than SSMS or T-SQL when changing job

How to Plan SQL Server Database Files

By Sean McCown Microsoft SQL MVP - May 24, 2010

It’s a common misconception that you will get a performance gain by using several log files. Although this is something we see quite often, Sean McCown,

SQL Server Recovery Models

By Sean McCown Microsoft SQL MVP - May 25, 2009

In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and full. These recovery models really just define how log management behaves

How to Design a Backup Strategy in SQL Server

By Sean McCown Microsoft SQL MVP - May 18, 2009

Designing a backup strategy in SQL is fairly straightforward, but it can get complicated when you’ve got a lot of moving pieces in your scenario. Sean McCown,

Featured Content for SQL | Sponsored