Reblog: Star Schema The Complete Reference – Review
SQLKover update:1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on...
2015-07-30 (first published: 2015-07-23)
2,203 reads
Koen Verbeeck
Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy
Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the...
2015-07-16
1,095 reads
Speaking at SQL Server Days 2015
I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The...
2015-07-15
658 reads
Power BI Confusion
Just a quick post on some Power BI material that I believe should reach as many people as possible. I get...
2015-07-14
1,630 reads
T-SQL Tuesday #68: Just say No to Defaults
It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2015-07-17 (first published: 2015-07-13)
2,418 reads
Thoughts on Power Query and SSIS
Recently I received a very interesting question on Twitter from Jeremy (blog | twitter):
@jmarx definitely yes
— Koen Verbeeck (@Ko_Ver) July 10,...
2015-07-13
2,542 reads
Reblog: What’s the deal with Excel and SSIS?
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to...
2015-07-10
1,301 reads
100th post
This is my 100th blog post here at LessthanDot!
(I’m not lying, check for yourself)
I started blogging at the end of...
2015-07-10
520 reads
Overview of Published Articles – 2015Q2
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
529 reads
Hello world!
Hi there!
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog,...
2015-07-08
371 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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