I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS: 515: A database error has occurred. Please contact your system administrator Too bad I am the system administrator on that machine… Anyway, after some searching it came out the MDS stored procedure udpEntityStagingAllBatchesByModelGet throws […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Browsing "Data Management"
I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I used in a blog post. First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package took to finish. This […]
It’s T-SQL Tuesday! This month, Michael Swart has challenged us to argue against a popularly-held opinion about SQL Server. “Arguing Against Popular Opinion” sounds like the title of my autobiography. You’ve been told time and again to back up your SQL Server system databases – master, msdb, and model. I’m here to tell you it’s not […]
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box, one of the tables looked like this: For readability purposes, a 1000 separator is added to the numeric value. However, the comma was used, as is common in the United States. In Belgium (and other […]
DISCLAIMER I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for free per month so I can review it on my blog. This works in both ways of course: I get free eBooks while they’re still hot from the press (figuratively speaking of course) and […]
If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes along with service pack 1 of Office 2013, which you can download here. There are two ways of getting this update: Downloading and installing service pack 1, aka the old-school method. Simply having the Click-To-Run […]
Recently I ran into the following error when compiling BIML into SSIS packages: The message itself is not very revealing: The data type for input buffer column ‘True’ on the ScriptComponent input buffer ‘Input0’ does not match the mapped output column from the previous transformation. You might have guessed it already; there is no column […]
Some time ago I added a script component to a few SSIS packages to compare rows with each other using a hash to check if they had actually changed or not. In the output of the script component, I had chosen a string data type for the calculated hash with a length of 66 characters. […]
For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day (hosted by my company element61), I read the book Master Data Services 2nd edition by Tyler Graham. I had almost no prior experience with MDS up to this point (I very quickly glanced over it […]
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit, a senior colleague of mine recommended the book Star Schema The Complete Reference by Christopher Adamson. To be honest, I had never heard about it. But was I wrong: this book […]