What Immediate_sync means in Transactional Replication – Part1

In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication...

Columnstore Indexes – part 108 (“Computed Columns”)

Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/
As we are approaching the RTM (release...

Dynamics 365 AX – Creating Data Entities for BYOD Azure Database including those without a natural key

We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially...

That thing you want to do? Do the thing.

You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...

Friday Reading 2017-07-28

Hope you all had a good week. Been pretty chilled out here so I’ve been reading…
Announcing Azure Container Instances

Microsoft blog...

How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016

One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to...

How to display more text in SSMS

Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL...

Information Measurement with SQL Server, Part 1: A Quick Review of the Hartley Function

By Steve Bolton
…………This long-delayed series of amateur self-tutorials has been in the works ever since I began writing my A...

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...

PowerShell $env Variables

I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code...