how to embed a PowerBI report into HTML code

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the focus of this tool is to be able to...

SQL Server Data Collection and Management Data Warehouse

We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...

Azure SQL Database Managed Instance

As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...

Generate a random number of children for each parent

I was asked an interesting question the other day.
Is it possible to get a different random number of rows...

Query to determine XE Session status

On a previous post, we discussed what is an extended event (XE) and how to create one.

With the following T-SQL...

how to embed a PowerBI report into HTML code

PowerBI is a powerful reporting solution for Business Intelligence for analytical reports, it is not meant to replace SSRS, the...

Data Factory V2 Activity Dependencies are a Logical AND

Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as...

Why Wont SQL Server Use My Filtered Index?

As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...

Why Wont SQL Server Use My Filtered Index?

As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...

Checking for Membership of a Specific Active Directory Group

As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...