Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking

For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...

Exam Prep 70-463: Installing Master Data Services

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Follow the yellow brick what? My road to public speaking.

Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...

How to Configure E-mail in SQL Server Step by Step–TIP #96

 
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL ...

In Memory Optimized Table in SQL Server 2014

To increase performance of highly accessible tables, a new feature incorporated in Sql Server 2014 “In-Memory OLTP”.You can define a...

Moving SQL Server data between filegroups – Part 1 – Database Structures

Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...

Outlier Detection with SQL Server, part 6.1: Visual Outlier Detection with Reporting Services

 By Steve Bolton
…………Most of the previous articles in this self-tutorials on using SQL Server to find outliers required us to...

Query Hash Formula Changes Between Versions

The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...

Speaking at IT/Dev Connections

I am very happy to announce that I will be presenting two sessions at this year’s IT/Dev Connections conference in Las Vegas!...

SQL 2014 CU5

By David Postlethwaite

If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited...