Dealing with the mysterious “True” column in BIML
Recently I ran into the following error when compiling BIML into SSIS packages:
The message itself is not very revealing:
The data...
2014-02-18
1,005 reads
Koen Verbeeck
Calculating the length of a hash in SQL Server
Some time ago I added a script component to a few SSIS packages to compare rows with each other using...
2014-02-11
2,405 reads
Master Data Services (Second Edition) – Review
For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day...
2014-01-31
1,917 reads
Star Schema The Complete Reference – Review
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph...
2014-01-23
1,174 reads
T-SQL Tuesday #50: Automation, how much of it is the same?
It’s the second Tuesday of the New Year, so here comes the first T-SQL Tuesday of 2014! SQLChow (blog | twitter)...
2014-01-14
665 reads
Happy 2014
I am a bit late with the almost obligatory “How was my past year and how do I think next...
2014-01-07
578 reads
Nominated for the Tribal Awards
I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...
2013-12-19
1,045 reads
Nominated for the Tribal Awards
I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...
2013-12-19
912 reads
SQL Server 2012 Reporting Services Blueprints – Review
Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe...
2013-12-12
769 reads
Master Data Services stops working after an upgrade
Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service...
2013-11-27
2,652 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...