So you think you need Enterprise Edition, huh?

Lately I have been struggling on a specific server in an environment I have been working on. Due to the need for partitioning in the cube, the project demanded an Enterprise Edition of SQL Server 2008R2. The only installation available, with Ent. Ed., had some 80+ databases, and several cubes, installed and running.

As I browsed through the databases, I noticed that quite a few of them could be run on a Standard Edition. I then turned to create a T-SQL statement, that would show which Ent. Ed. features was in use, in each database.

EXEC sp_MSforeachdb N'SELECT * FROM sys.dm_db_persisted_sku_features' 

Turns out, none, zero, zip, nada of the databases uses any Ent. Ed. features. Imagine that.

Speaking at Campus Days Denmark 2013

Three days, more than 100 sessions, on 10 different tracks, Campus Days Denmark has become quite the act in town. I submitted three session abstracts. I was lucky and very delighted, that one of those got chosen. I will be presenting, in cooperation with my colleague Rasmus Reinholdt Nielsen (LinkedIn|Twitter), on the topic Optimizing BI with SQL Server 2014 in-memory database.

We will be showing how to optimize you BI solution through the use of the new SQL Server 2014 In-Memory database technology, called Hekaton. The first of two scenarios, will demonstrate how to performance optimize your ETL by using Hekaton as reference database. The second demo, will be building a ROLAP cube on top of Hekaton, to see what benefits can be achieved here.
See you there?

SQL Server 2014 CTP1 Released

The Community Technology Preview (CTP) version 1 of SQL Server 2014 was realeased yesterday, by Microsoft. You can find and download an evaluation version at

Although I must say that I am excited about a good part of the new features, I can’t help but feel, that the release is a bit thin. Almost no new stuff to play with in T-SQL and when will Data Mining be given the focus it deserves? As far as I can tell, there has been added no features or updates to Data Mining according to MSDN, or is it just me?
UPDATE: Denis Gobo (blog|twitter) is on to it as well…

Here are some blog posts that list new stuff:
SQL Blog –
Kenneth Michael Nielsen (blog|twitter) –
James Serra (blog|twitter) –

Nuff rambling, just finished downloading – it’s time to unleash the beast 🙂

UPDATE: (Fastest update on this blog ~ 5 min.)
When trying to install, I just ran it on my desktop, not realising that a side by side is not possible:

SQL Server Quick Tip 21-25


History repeats itself…

This week, I will be attending my second SQLBits. I had my rookie year last year, where I learned the most important fact about SQLBits: Every session is a winner you don’t wanna miss. I had a hard time deciding which sessions to attend last year, but finally boiled it down. This year, I made a plan up front, mostly going with my instincts, but also coordinated sessions with two other co-workers who is attending.

My final schedule is looking like this:

Thursday (pre-con):
Real World SSIS: A Survivial Guide, by Tim Mitchell (blog|twitter)

KeyNote by Conor Cunningham (blog), Seeking SQL Server Secrets by Kalen Delaney (blog|twitter), Moves Like Jagger :  Upgrading to SQL Server 2012 by Mark Broadbent (blog|twitter), Quantifying the Cost of Compression by Fuision-IO, The Developer Side of Master Data Services by Sascha Lorenz (blog|twitter), Why APPLY? by Christina E. Leo (blog|twitter) and rounding the day of with insights into Advanced Micrtosoft Certifications for the SQL Server Professional by Gavin Payne (blog|twitter).

War Stories from Implementing SQL Server 2012 AlwaysOn by Dan Stillwell (blog|twitter), SQL Server 2012 Memory Management by Neil Hambly (blog|twitter), An Introduction to the wonderful world of OData by Wesley Backelant (blog|twitter), Advanced SQL Server 2012 HA and DR Architectures by Christian Bolton (blog|twitter), Incremental Processing of SSAS Multidimensional Databases by Dr. John Tunnicliffe (blog|twitter) and finally Estimation, Statistics and Oh My! by Dave Ballantyne (blog|twitter)

Again this year, the team behind SQLBits have done a terrific job on getting great speakers and the speakers have submitted some really great sessions.
I am really looking forward to learn a bunch of new stuff about SQL Server, and of course to flash the medieval costume I’ve borrowed from a friend who’s into reenactment, so it should be somewhat authentic 🙂