Building SQL ConstantCare®: Analyzing Query Plans
Starting to translate sp_BlitzCache into the cloud.
Display Median Values
DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this
Managerial Moneyball
Steve Jones notes that the Moneyball phenomenon has come to managers and perhaps a little training and data can help find us better managers.
Be Careful with Key Order in SQL Server Missing Index Recommendations
In this tip we look at the missing index recommendations that SQL Server automatically provides and why you should pay close attention to what is recommended and how you actually implement the new index.
Introduction to Azure Cosmos DB Emulator for Creating Applications
Azure Cosmos DB is Microsoft’s NoSQL database platform running in the cloud. In this article, Suhas Pande explains many of the core concepts in Cosmos DB. Additionally, he goes over how to set up a local Cosmos DB emulator to create collections and documents. Using a local emulator is free and allows development with Cosmos DB without being connected to Azure.
Stairway to SSAS Tabular Level 2: Installing the Components
In this level of the Stairway to SSAS Tabular you will learn how to install the platform and tools.
How to migrate a SQL Server database to a lower version
A tip looking at a one time procedure which we can follow to downgrade the database from a higher version (SQL Server 2012) of SQL Server to a lower version (SQL Server 2008 R2) of SQL Server.
Always Canary
One way to make deployments smoother is to use a second system, but that's a challenge for databases, as Steve Jones notes.
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers