Analyzing Formula 1 results in R

Using R to scrape data from the web, prepare and visualize it

Making SQL Server Function Changes Backwards Compatible

Tagging SQL Server Changes in SQL Monitor

How to use RAISERROR() in T-SQL to send annotations to SQL Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics.

DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz

In this first article, get an introduction to DAX, it's uses, and the basics of a DAX query as compared to a T-SQL query.

Evaluating SQL Data Catalog using Docker Containers

Richard Macaskill shows how to use Docker Compose to get SQL Data Catalog up and running in a container, in your SQL Server test lab, and then use it to evaluate its data discovery and categorization capabilities on a containerized SQL Server instance.

Virtual Reality

While we are centuries away from the Holodeck experience, we can take advantage of today’s technology for fun or education.

Free eBook: SQL Server Internals: In-Memory OLTP

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

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

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

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