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 "Microsoft SQL Server"

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...
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...
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...
1

2013 – Review of Writing

In 2013 I took on a slightly different approach to writing by putting more into each article with content, length and defining either what the topic was on or how the troubleshooting methods are taken. This, of course, meant my average blog count per mo…

Read More...
0

Can I recover from a secondary replica COPY_ONLY full backup?

I’m asked this question quite often while setting up availability groups and setting a preferred secondary for transaction log backups – can you recover from the full backup taken on the secondary with COPY_ONLY and also rely on a full backup taken on t…

Read More...
0

Async replica loss causes transactional replication to fail

Availability Groups have come on strong as a true Enterprise high availability feature in SQL Server.  While the setup and maintenance of availability groups is fairly straight forward, adding other features into the mix can make operations quite comple…

Read More...
5

Create ETL solutions faster with metadata driven development – Session Materials

Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great audience, fantastic speakers and nice booths by the sponsors (especially the bar with Belgian beer was pretty awesome). It was great meeting up with the #s…

Read More...
Next Page »