Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Learn a few ways to improve performance in your Azure SQL Databases through better indexing, partitioning, and columnstore index consideration.
Shorten the Debate
Steve talks about the process of decision making with idea for shortening the time taken.
Techniques to query Azure SQL’s new JSON Datatype
The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation in SQL Databases. These features are slated to be a part of SQL Server 2025 as well. Let’s analyze some practical uses of these features
Level 1 of the Stairway to Synapse Analytics - Create a Synapse Workspace
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
Level 2 of the Stairway to Synapse Analytics: Analyze Data in Storage Account using the Serverless SQL pool
In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.
Level 3 of the Stairway to Synapse Analytics: Analyze Data Using a Spark Pool
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creation of the Synapse Workspace. In Level 2, data analysis was done on Data Lake files using Serverless SQL Pool. In Level 3, I will analyze data from the files uploaded in Data Lake container using a Spark Pool. I will […]
Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creating the Synapse Workspace. In Level 2, we analyzed Data Lake files using the Serverless SQL Pool. In Level 3, we analyzed Data Lake files using the Spark Pool. In Levels 4 and level 5, I will discuss the Delta […]
Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2
This next article in the Stairway to Synapse looks at Delta tables and processing streaming data.
Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
Reflecting on the Mythical Man Month
Steve looks back at the Mythical Man Month, a book every software engineer and manager should read.
Blogs
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A…
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure...
Cyber Scams and Operation Shamrock
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
The Book of Redgate: Ingeniously Simple
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
Forums
Shorten the Debate
Comments posted to this topic are about the item Shorten the Debate
Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Comments posted to this topic are about the item Azure SQL Performance Tuning: Mastering...
Adding Lots of Dates
Comments posted to this topic are about the item Adding Lots of Dates
Question of the Day
Adding Lots of Dates
The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?
DECLARE @d DATE = GETDATE() SELECT EOMONTH(@d, 95695)See possible answers