Friday Reading 2016-12-09

One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...

Hide and Group Columns in SSRS Using a Parameter

Ever had users come to you and request another version of a report just to add another field and group...

In Memory OLTP – 2

Good day everyone , In last post

In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...

Interviewed on Channel 9

Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.
https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player

Filed under: Blog Tagged: DevOps,...

NOLOCK

NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...

Validating a Set of Database Scripts using DLM Automation

The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or...

Why won’t my SP work THIS time?

Why won't my SP work? I did this exact thing. You're never too old to do something like this.
The post...

Fixing Data Migration Assistant timeouts

I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the...

Query Store - Part 4 - Find the plans and queries forced by Query Store

As most of you know, one of the most fundamental uses of query store is to force query plans. Unlike...

SSIS Data Flow "Sequence Containers" are Here!

Wooo!
OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline.  However, I just...