SSIS 2012 - Build Project

The Database Recovery Advisor in SQL Server 2012

The Database Recovery Advisor in SQL Server 2012 will aid the ability of DBAs to recover their databases to a point in time in a crisis. Read about this new feature and how it can speed the process of recovery.

SSIS 2012 - Versioning

The Sequence Object in SQL Server 2012

The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.

The SSIS service in 2012

New features in SQL 2012, the contained database

This article describe the problems about the migration of the databases and logins and the new feature contained databases

SSIS 2012 - Create Catalog

New Built-in Conversion Functions in SQL Server 2012

SQL Server 2012 introduces three new built-in conversion functions: PARSE, TRY_ PARSE, and TRY_CONVERT. These functions were introduced to be more familiar to users of expression languages. They perform a subset of the functionality of the pre-existing conversion functions. This article will introduce these three new functions and their usage.

Sequences III

Analytic Enhancements in SQL Server 2012 - Part II

The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.