Optimizing workflows with In-Memory and Natively Compiled Objects – or how it does not work

During the course of optimizing data-access-code with the In-Memory-functionalities in Microsoft SQL Server (memory optimized tables + indexes, memory optimized table valued parameters and natively compiled stored procedures), you may often realize that sometimes you go one step forward and then another one backwards.

Where is that Preemptive Wait coming from?

In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.

SQL Server 2016 SP1 removes the editions’ programming feature limits!

These are just sublime news, there is no other way to put it: With the Service Pack 1 for SQL Server 2016 released today, Microsoft puts an end to the programming-technical differences between the editions (LocalDB, Express, Standard, Web, Enterprise)! As of today, EVERYONE who is already working on SQL Server 2016 can create In-Memory […]

Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server

With the total of 4 new index types we have gained since SQL Server 2012 now we also have a total of 4 basic formats (Heap, Clustered Index, Clustered Columnstore Index, memory-optimized “varheap”) for data storage in SQL Server. And what’s more, with SQL Server 2016, these can be combined in various ways.

The SQL Server 2016 In-Memory Evolution – from row-store to columnstore to in-memory operational analytics

SQL Server 2016 is finally available and, by extension, the “version 2” of the In-Memory OLTP Engine, if you will. At various international conferences and already at the IX in 2014 I have presented what is behind the In-Memory Engine of SQL Server introduced in SQL Server 2014. Only I had not yet found the […]

SQL Server 2016 general availability and Feature-Support

Finally: The new SQL Server 2016, in my eyes the best release since many, if not ever, is generally available. (See Blog article by Joseph Sirosh, Corporate Vice President, Data Group, Microsoft) The Built-Number is 12.0.1601.5.

Conferences in SQL Server summer 2016

It feels like I have just been back from the SQLBits XV in Liverpool, where I introduced the Security Features of the SQL Server 2016 (SQL Server 2016 – Security Obscurity and Encryption), and next thing I know, I am already in the middle of planning the next SQL Server Master-Class on High Availability with […]

Sarpedon Quality Lab presenting SQL Server 2016 In-Memory and Security Features in Arabia at SQL Gulf 3

مرحبا (“MARR-hah-bah”, Arabic: Hello) This year takes me to yet another part of the world: I have been invited to speak at THE SQL Server Conference in the Middle East: at SQL Gulf 3 taking place in Riyadh, Saudi Arabia on April 23rd.

Reporting Services 2016 – Back in the game: the new capabilities & features

It has been years since my last publications and presentations on Reporting Services. This is no surprise, because since the 2008 R2-release nothing has happened there. With SQL Server 2016, the Reporting Services finally get attention again, as I had preannounced in passing already last May („SQL Server 2016 – the Security & Performance Release“). […]

Sessions submitted for major conferences 2016. Topics: Security – Performance – In-Memory

After the great success of the German SQLKonferenz in February, where I had the honor of presenting the new security features of SQL Server 2016 together with Joachim Hammer, the Program Manager of the security teams of the relational SQL Engines at Microsoft in Redmond (more info), I finally found time to go about the […]