In this tip, Dallas Snider explains how to interpret the Lift Chart found on the Mining Accuracy tab of a SQL Server 2014 Analysis Services Data Mining structure.

Byte Me: Denormalized

by Bob Lang

SQLServerCentral.com

Byte Me

A case of SQL infection.

SSIS 2012 Projects: Deployment Configurations and Monitoring

by Additional Articles

SimpleTalk

Integration Services (SSIS)

The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.

Consolidating Again and Again and Again

by Steve Jones

SQLServerCentral.com

Editorial

This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday. Virtualization is touted as a great way to save money, but it's a one time event. Once you've consolidated a server, you can't do it again. However consolidation isn't necessarily the same and Steve Jones tells us why.

Using SQL Server Stored Procedures in SSIS Data Flow Sources

by Adán Bucio

SQLServerCentral.com

Data Flow Task (SSIS)

A technique to deal with lack of metadata for stored procedures when used with SSIS.

Building an Automated Database Deployment Pipeline

by Additional Articles

SQL Server Magazine

Database Deployment

Data and databases are historically ignored or given a low priority within the processes of ALM and DevOps. This situation needs to change and the primary point of the changes is within the database professional part of the team.