Getting Started with Power BI: Setup (Part 1 of 3)
This is part 1 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-02
196 reads
Blog Posts
Microsoft Data Platform MVP Award
I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is...
2017-02-02
508 reads
My SQL logins don’t work. Again.
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one...
2017-02-02 (first published: 2017-01-25)
2,389 reads
Using a DMK in TDE
When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t...
2017-02-02
785 reads
Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark
(EN)In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.
(DE) In...
2017-02-02
23 reads
Availability Group on SQL Server 2016
The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...
2017-02-01
2,281 reads
Changing what SSMS opens on startup
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...
2017-02-01
778 reads
Columnstore Indexes – part 97 (“Working with Strings”)
Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...
2017-02-01
655 reads
Improve performance by replacing temp tables with memory optimized tables - Part 1
There are many cases where you will be using temp tables, and many of us are trying to seek for...
2017-02-01
6,887 reads
My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
816 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers