Control Flow Package Parts in SSIS 2016

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server...

Creating a Logon Trigger–#SQLNewBlogger

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

I like you, but I don't like your best practice (power plans)!

I saw this tweet from the always awesome @DBArgenis and @sqldbawithbeard and couldn't help but feel a bead of sweat...

Machine Learning – What is It Good For?

Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...

Making the Most of PASS Summit and Similar Events

Events like the PASS Summit aren’t just about education. They are a chance to meet new people, get some distance from...

PASS Summit 2016: Dinner, Dinner, Game

Part of making a week long trip to a big event like the PASS Summit successful is finding something to...

SQL Saturday Washington DC Preconference Training Session

I am pleased to announce that we are launching our next round of all-day precon training session at the upcoming SQL Saturday in Washington...

Syncing QA data with Production

Applies to: xSQL Data Compare v7.0.0 - v9.0.0
Nowadays, Quality Assurance (QA) is a very important part of the development process for any...

Syncing QA data with Production

Applies to: xSQL Data Compare v7.0.0 and higher

WARNING: this article focuses on the data transfer / synchronization task and does not address operation security issues and sensitive data scrubbing /...

Who owns your availability groups?

Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that...