PASS is our community. It may sound a little cliche, especially with the current political climate in the US and other...  Read more...

I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...  Read more...

http://andreas-wolter.com/blog/ Liebe Leser dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt. Seit August 2017 finden sich...  Read more...

Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...  Read more...

Continuation from the previous 111 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blogpost is focusing on the Server...  Read more...

To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement: USE [SSISDB]; GO OPEN MASTER KEY...  Read more...

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

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

We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...  Read more...

Hello friends, Please find my new post at this link – https://social.technet.microsoft.com/wiki/contents/articles/40141.delete-all-the-resources-from-a-resource-group-using-windows-powershell.aspx Advertisements Tagged: Microsoft Azure, Powershell, resource group, Virtual Machine,...  Read more...

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

I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...  Read more...

In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...  Read more...

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

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

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...  Read more...

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or I...  Read more...

Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...  Read more...

A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...  Read more...

This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH It had a massive...  Read more...