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.
Learn a few ways to improve performance in your Azure SQL Databases through better indexing, partitioning, and columnstore index consideration.
Steve talks about the process of decision making with idea for shortening the time taken.
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
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
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.
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 […]
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 […]
This next article in the Stairway to Synapse looks at Delta tables and processing streaming data.
This next level of the Stairway to Synapse Analysis Services looks at the Dedicated SQL Pool.
Steve looks back at the Mythical Man Month, a book every software engineer and manager should read.
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure...
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
Comments posted to this topic are about the item Shorten the Debate
Comments posted to this topic are about the item Azure SQL Performance Tuning: Mastering...
Comments posted to this topic are about the item 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