Microsoft

SQL Server 2014: Hekaton memory optimized tables, hash indexes, and bucket counts

For my first blog post at dbi services, I think it could be a good opportunity to begin by discussing around SQL Server 2014, Hekaton memory optimized tables, and hash indexes. When you create a memory optimized table you(…)

Delayed Transaction Durability: A new feature in SQL Server 2014 CTP2

Delayed Transaction Durability is a new SQL Server 2014 feature that was not included in SQl Server 2014 CTP1 but discreetly published in CTP2. It is a very interesting functionality that helps reducing the IO contention for transaction log(…)

SQL Server 2014: Readable Secondary with In-Memory objects

In-Memory OLTP is one of the best new functionalities of SQL Server 2014 as it was the case with AlwaysOn and SQL Server 2012. In-Memory OLTP is fully integrated with AlwaysOn and also with AlwaysOn Availability Group. During my(…)

SQL Server 2014: Rebuilding Clustered Columnstore Indexes

I was surprised that you have to rebuild indexes that are stored In Memory. My previous posting “SQL Server 2014 – New Features: xVelocity memory optimized columnstore index” explains all processes connected with columnstore indexes. In this article, I(…)

With Power Query, converting an internet table to Excel is an easy job!

While exploring SQL Server 2014, I was surprised by the powerful Power Query feature. In the recent past, converting an internet table to Excel was a nasty work leading to format problems, implicit conversions, etc. With Power Query, importing(…)

SQL Server 2014 – New Features: xVelocity memory optimized columnstore index

Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services(…)

IT Pro TechDays 2013 in Lausanne: BYOD, SQL Server & SharePoint

I had the opportunity to attend the IT Pro day at the Microsoft Techdays in Lausanne. Let me give you a few insights on my day there. Being a SharePoint specialist but also ramping up on Microsoft SQL Server(…)

SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures

One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2(…)

SQL Server 2012 SP1: Sixth Cumulative Update (CU6) available

Some days ago, Microsoft published the sixth Cumulative Update (CU6) for Microsoft SQL Server 2012 Service Pack one, two months after the fifth one. As usual, if this Cumulative Update solves an issue you are facing, install it(…)

SQL Server 2012 SP1: Fifth Cumulative Update (CU5) available

On 16 July, Microsoft published the fifth Cumulative Update (CU5) for Microsoft SQL Server 2012 Service Pack One. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which(…)