My first SQL Server 2016 POC
Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of...
2016-06-14 (first published: 2016-06-09)
4,739 reads
Koen Verbeeck
Conditional Formatting and Quick Calcs in Power BI Desktop
There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official...
2016-06-07 (first published: 2016-05-31)
2,753 reads
Reblog: Unexpected result with the File System Task
SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default...
2016-06-03 (first published: 2016-05-24)
1,178 reads
Speaking about Power BI @ ITPROceed 2016
I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this...
2016-05-19
490 reads
SSRS and MDX: Think about Cell Properties
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you...
2016-05-04
570 reads
Dynamic Security in Power BI
UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.
In...
2016-04-28
2,810 reads
Power BI Service error: “This visual has unrecognized fields”
Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power...
2016-05-03 (first published: 2016-04-22)
2,546 reads
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...
2016-04-21
1,837 reads
Overview of Published Articles – 2016Q1
Here is an overview of the articles I published in the first quarter of 2016.
R Services series:
SQL Server 2016 R Services:...
2016-04-19
431 reads
SSIS Trick: Adding Multiple Packages to a Project
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...
2016-04-06
16,874 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you’ve been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers