Streaming Reporting: SQL Change Data Capture (CDC) to Power BI

[read this post on Mr. Fox SQL blog]
Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I...

Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge

Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern...

Video Tutorial: Creating a SQL Server Databases

In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll...

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...