Power BI Reports in SSMS

Get more interactive reports in SSMS.

Constant Integration

Apple buys a company every few weeks. The data integration for this must be a large effort.

Daily Coping 31 Mar 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Datatypes and the Default Mask with Dynamic Data Masking - Step 2 of the Stairway to Dynamic Data Masking

This article digs deeper into the ways that Dynamic Data Masking works with different data types.

More Which in R

Daily Coping 30 Mar 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Filtering SQL Compare to a Schema

One of the things that numerous clients have some to Redgate about is allowing a team of developers to work on a single shared database without creating conflicts. While...

Generating Art

Using metadata to drive software is very useful, which means that having clean data and lots of metadata can help create better software.

The Command Palette in Azure Data Studio

Basic Fetch and Offset Experiments–#SQLNewBlogger

I’ve never used the FETCH or OFFSET commands for pagination, but I have heard of them. I ran across them recently and decided to experiment a bit. One note:...