In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.

Storage 101: Understanding the NAND Flash Solid State Drive

by Additional Articles

SimpleTalk

Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this article, Robert Sheldon explains how NAND flash solid-state drives work.

Using SQL Monitor Groups in PowerShell

by Additional Articles

SQLServerCentral.com

Not only are SQL Monitor Groups probably the neatest and most maintainable way of ensuring that all your SQL Servers have the best possible configuration of alerts, but they represent a powerful way of categorizing your SQL Server estate. In this article, I'll show how to use the SQL Monitor PowerShell API to export these groups, save their settings onto a configuration management system, or compare groups of settings to see the differences between them.

Creating SQL containers on Azure Data Studio Notebooks with Python

by Carlos Robles

SQLServerCentral

Carlos Robles explains how to use Azure Data Studio Notebooks to create SQL containers with Python.

Going Virtual

by Steve Jones

SQLServerCentral

Conferences, Classes, Events, and Webinars

Most likely we are in for many virtual events this year.

Avoid using constants in an ORDER BY clause

by Additional Articles

SimpleTalk

Phil Factor explains why an ORDER BY clause should always specify the sort columns using their names, or aliases, rather than using an integer to specify the position of a column in the SELECT list.

Power BI Dashboard vs Report vs Workbook

by Additional Articles

MSSQLTips.com

There are many different ways to present data using Power BI and this tip looks at these different methods such as Power BI Dashboards, Power BI Workbooks and Power BI Reports.