Book Review – The Biml Book
After years of waiting, a book about Biml has been published! It’s conveniently titled “The Biml Book” (subtitled Business Intelligence and...
2017-12-04
882 reads
Koen Verbeeck
SQL Server Data Tools 2017 and TFS Integration
I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no...
2017-11-30
1,801 reads
Microsoft Professional Program in Data Science – The Finish Line
In October 2017, I completed the capstone project of the Microsoft Professional Program for Data Science. I’ve blogged about this...
2017-12-01 (first published: 2017-11-21)
3,141 reads
Installing the MDS add-in for Excel 2016
For some reason I attract all kinds of misery when working with Master Data Services. Today I was trying to...
2017-11-15
2,709 reads
Can’t Connect to Analysis Services – Invalid Connection Information
I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried...
2017-10-30
1,521 reads
Error Installing SQL Server 2017
A quick blog post on an error I got when installing SQL Server 2017 RTM. I ran the set-up for...
2017-10-20
5,595 reads
dataMinds Connect 2017 – And The Winner Is?
Last week I had the privilege to host a little contest to give away one free ticket to dataMinds Connect...
2017-09-25
406 reads
dataMinds Connect 2017 (win a ticket!)
Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...
2017-09-18
328 reads
Error Processing Tabular – Method Not Found
Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...
2017-09-15
377 reads
CALCULATE and FILTER: A Love Story?
There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going...
2017-09-13 (first published: 2017-09-06)
2,008 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