Dynamic Threshold for Statistic Update - SQL Server 2016

By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...

Four PASS Questions–My Take #PASSElections

As part of the campaign material for this years election for Board of Directors; the candidates were asked to answer...

How to change Integration Services Catalog (SSISDB) database Master Key encryption password?

To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement: In the above Transact-SQL fragment, we first open the Integration Services Catalog...

How to change Integration Services Catalog (SSISDB) database Master Key encryption password?

To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement:

USE [SSISDB];
GO

OPEN MASTER KEY...

How To Make Your Queries Perform Like They Used To

Photo by Chad Kirchoff on Unsplash

Watch this week's video on YouTube
In the ideal world, you fully test how your SQL Server will handle upgrading to the latest version.  You're able to catch...

How To Make Your Queries Perform Like They Used To

Photo by Chad Kirchoff on Unsplash
Prefer watching on YouTube? 
In the ideal world, you fully test how your SQL Server will handle upgrading to...

Join me at VS Live – Anaheim

We’re just a month away from Visual Studio Live in Anaheim where I’ll be speaking along with many others. Join...

Power BI Custom Visuals Class (Module 67 – Impact Bubble Chart)

In this module you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is...

PowerShell Modules Central - Share with community - What PowerShell modules are you using?

Like the blog post title states this is all about sharing with others! My idea is to share with the community which PowerShell modules you are using.
PowerShellModulesCentral is a...

SQL Server DB Migration – Cloning a database to another collation

Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts...