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...

What Port Should I Use?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp

In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a...

SQL in the City is coming next week

Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free...