Category SQL

SQL Server 2016 CTP 2.4

I’ve been waiting impatiently for this release and some of the new improvements and functionality that comes with. Some of the In-Memory capabilities as well as a few new features in SSIS. Go ahead, read the announcement and download it from there http://blogs.technet.com/b/dataplatforminsider/archive/2015/09/30/sql-server-2016-community-technology-preview-2-4-is-available.aspx to run it on-prems or power up a Virtual Machine in Azure […]

SQL Saturday Denmark #413 post-event

This is the day after, the day after. We’ve all slept the Sunday out and are ready for our day jobs again! Thanks Thanks you for a great event to: The sponsors, who made everything possible The volunteers for giving a hand when we need it The speakers for using their weekend and money to […]

Using aliases for SharePoint databases

Aliases are good. In fact, aliases are excellent. The purpose of this post is to explain why and how to use aliases when working with SharePoint. This is the second post in the series about building an highly available BI setup. A series that will culminate with Mark Broadbent (B|T) and my preconference at SQL Saturday […]

PASS Summit 2015 – Early registration save 550 $

If you are considering going to Seattle from 27-30 October and attending this year’s edition of PASS Summit, now is the time to register as the price will go up in very few days. Until July 12th you can save 400$ on the registration fee. You can save 150$ more by using the discount code […]

SSMS Tip Of The Day – Show Row Count

Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway. If you want to see the number of rows in a table you can always use Select count(*) from TableName but it has quite a nasty performance. Another way to do it with much […]

The information age is over, the era of intelligence has begun

The line above is the first information that meets the eye when browsing to imshealth.com , my new employer ! As a matter of fact, friday, the company I work at – Rehfeld partners a/s – annouced that it was bought by a huge multinational healthcare company with filials and ramifications in many countries : IMS […]

SQL Server 2016 CTP2 now available

The official Community Technical Preview 2 (CTP2) release build for Microsoft SQL Server 2016 is available for public download here. One week ahead of schedule ! Any feedback is greatly valued and can be submitted here. Enjoy !!

BIG Data HACKATHON Copenhagen

The Microsoft Big Data Hackathon is your opportunity to hack for a good cause. Assemble a team, learn, share, and make new friends as you use big data technologies to solve real-world problems. Who Should Attend? This event is open to anyone interested in Big Data, BI and Data Visualization: · Data Scientists · Developers […]

SQL Saturday 413 news from the front

It is a lot of work to plan a SQL Saturday, and also a lot of  fun. The third edition of SQL Saturday in Denmark will be no exception. The team is already putting a lot of effort in finding and contacting sponsors, which luckily are often more than willing to contribute to the event. […]

Extending SSIS With .NET scripting

Earlier this year I got embarked on a book project together with Joost Van Rossum (B|T) , a dutch fellow MVP. A book about a subject that has always been very dear to me and crucial to the success of my work as an ETL developer. Namely how to extend the capacity of SSIS with […]