(Grant Fritchey) I was recently asked if we could tell why a plan was removed from cache. If you read this blog, you know what I’m going to say next.

(Betty Gabriela Ramirez Bejarano) When dynamic data masking is applied, the main objective is to limit the exposure of confidential information to users who do not have the necessary privileges to observe confidential information.

(Jack Vamvas) Question: I want to identify virtual machines which are powered off. What query can I run which will return the full list of virtual machines within a VMWare vCenter database where the power state = OFF.

(Chris Webb) Playing around with Microsoft Flow recently, I was reminded of the following blog post from a few months ago by Konstantinos Ioannou about using Flow to call the Power BI REST API to refresh a dataset:

(Pinal Dave) As soon as a new version of SQL Server is announced, I always try to find new things and update my old post with new information or write a new post.

(Jason Brimhall) I recently had a client call me out of the blue because he happened to be getting an error while trying to add a user to a database role. The error he was getting was “Cannot use the special principal ‘dbo’.”

(Melissa Coates) This is a question I get fairly regularly these days: Should we extract relational data and load it to a data lake?

(Josh Villareal) I recently had a client approach me on an error that they persistently encountered when attempting to start an extended event session in the Azure SQL Database service. The SqlException error message consisted of the following:

(John Martin) Collating information from many different Azure SQL Server Databases can be done in several different ways. However, many of these require rearchitecting or building external services to connect to and then extract data from the databases and then trying to store it in a central reposi

(blobeater) If you have been reading my blog for a while now you would know that a common technique to move to Azure SQL DB is to use BACPAC files.