In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that are not supported, such as some data types, and Darko Martinovic describes the issues and provides workarounds. He also has provided a tool to assist in migrating disk-based tables to In-Memory optimized tables.
Is there a best way to comment code? Or maybe just different styles. Steve Jones asks what you think today.
My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?
Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.
Learn how containers can help with database development.
In this tip Aaron Bertrand looks at how to generate scripts for triggers using simple T-SQL statements. This tip shows how to easily build scripts for disabling, enabling, dropping and creating.
Power BI has been available for a number of years, but new functionality is added regularly. In this new series from Robert Sheldon, you will learn about the latest developments or get started with Power BI if you are new to it. Robert provides an overview of Power BI, the services and tools available in this article.
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
Comments posted to this topic are about the item How Do the Experts Become...
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers