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.
Author Archive for: Andreas Wolter
About Andreas Wolter
Andreas Wolter has been specialized in SQL Server for more than 20 years. He is not only a Microsoft Certified Master (MCM) but also one of two Microsoft Certified Solutions Masters Data Platform (MCSM) in Europe and has been awarded MVP several times.
His company Sarpedon Quality Lab, which offers its services mainly in Europe, the Middle East and Southeast Asia, is focusing on high performing OLTP Systems and big Data Warehouse Architectures with an emphasis on secure deployments.
Entries by Andreas Wolter
It is no secret that I have been very active in the Asian region the last years – mainly in Singapore, Malaysia and India. So, it may not be a surprise that this summer I will be giving a full day PreCon at the now called “Data Platform Summit” in India’s hub for information technology: […]
First off, the most important information in a nutshell: From 26-28 June, I am conducting a new SQL Server Master-Class: The Performance Troubleshooting Bootcamp with SQLSentry (shorthand: PSS*). For those in a hurry, the link for registration right below: http://sql-server-master-class.com/#PSS
It is with a certain nostalgia that I announce my resignation from my post as (Co-) Chapter Leader of the PASS regional chapter “Rheinland” in Germany (comprising Cologne and Dusseldorf). I had been Chapter Leader since January 2011 – quite exactly for 6 years.
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.
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 […]
After my Asia-tour this summer I feel it is about time for this article. At the time of this article (09-2016) I have presented at more than 50 technical conferences around the world (Europe, Middle East, Asia, North America), from small with about 150 attendees to huge with around 5000 attendees. With that came a […]
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.
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 […]
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.