Viewing Deployed XEvent Metadata

Today will be the first of a few introductory level posts about Extended Events.
When dealing with Extended Events, there are...

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven’t really used it before but found it to be a really...

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven't really used it before but found it to be a really...

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven’t really used it before but found it to be a really...

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool:
https://medium.com/@edelliott.the.agilesql.club/let-s-start-doing-profes…

Better Test Data Domains with SQL Data Generator

I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with...

CISL – Columnstore Indexes Scripts Library, Release 1 (“Ortus”)

I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”.

Go on...

CONTEXT_INFO and efficient mass update on a large table with a trigger

Let`s assume we have following task – make changes to the data in a large table that has consistency checker in...

Getting Started With Power BI Desktop: Getting Data

Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get...

How to Create Pareto Chart in Power BI

About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking...