Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

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 "syndicated"

0

MDS: A Database Error Has Occurred

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 […]

Read More...
2

SSIS Performance Testing

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 […]

Read More...
0

Changing the 1000 separator in Power View

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 […]

Read More...
0

Dude, where’s my Power Map?

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 […]

Read More...
2

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 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. […]

Read More...
0

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 (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 […]

Read More...
3

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 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 […]

Read More...
0

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) has the honour to host this jubilee edition of the world famous blog party. The theme of this month is the utterly DBA-related topic of Automation. However, it is pretty easy to give it […]

Read More...
0

Happy 2014

I am a bit late with the almost obligatory “How was my past year and how do I think next year is going to rock” blog post – we’re already a good week into the new year – but without further ado I present you: How was my past year and how do I think…

Read More...
2

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 not for some tattoos on your lower back or on your biceps, but rather a collaboration of Simple-Talk and SQLServerCentral to give outstanding commu…

Read More...
Next Page »