Design Concepts For Better Power BI Reports Part 5: Affordances

Affordances are a general design concept that comes from physical product design but can be applied to visual design. I...

Columnstore Indexes – part 116 (“Partitioning Specifics”)

Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/
After delaying for a couple of years...

The case of the missing database backup file

Exploring the wonderful case of a missing database backup.
I was working on a client’s site today, setting up database backup...

Power BI Custom Visuals Class (Module 83 – ChartAccent – LineChart)

In this module you will learn how to use the ChartAccent LineChart Custom Visual. This visual is a custom line...

No moving parts, the story of persistent memory

In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard...

Message in a Bottle of XE

Considering this "feature" for everything that is SQL Server related, does this mean that all Extended Events related messages are accessible in sys.messages?
Related Posts:

Implicit Conversion Fail May 31, 2019...

Message in a Bottle of XE

One of the age old features that most probably take for granted in SQL Server happens to be the error...

Message in a Bottle of XE

One of the age old features that most probably take for granted in SQL Server happens to be the error...

Restoring a Copy Only Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

What is impersonation for?

I was doing some research on impersonation the other day, and among other things, I ran across a forum question...