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
Koen Verbeeck
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
569 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,836 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,868 reads
SQLSaturday Belgium: slidedeck
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially...
2016-03-24
498 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers