Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.

Monitoring SQL Server: An Interview with David Bick

by Additional Articles

SimpleTalk

Interview

Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.

SQL Saturday #305: Dallas, BA Edition

by Press Release

SQL Saturday

Events

Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available

Unexpected View Performance

by Thom Bolin

SQLServerCentral.com

Views

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.

SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide

by Additional Articles

SimpleTalk

wait statistics

This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.

One Database to Rule Them All

by Steve Jones

SQLServerCentral.com

Editorial

Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?

XML Schema validation in SQL Server

by Eirikur Eiriksson

SQLServerCentral.com

An introduction to the XML Schema Collection and XML validation.

Call for participants in deployment process research

by Press Release

SimpleTalk

research

The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.

Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS

by Additional Articles

MSSQLTips.com

Analysis Services (SSAS)

The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.