Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Learn how backup and restore work in Azure SQL Hyperscale in this next level in the stairway series.
2025-12-17
681 reads
Stairway Series
Stairway to Azure SQL Hyperscale Level 5: Data Growth and Fast Auto-Grow Mechanism
In this level, we learn about the database file size growth in Hyperscale.
2025-12-03
66 reads
Stairway to Azure SQL Hyperscale Level 4: Log Service and Transaction Management
Learn about how the Log Service helps manage transactions in the Hyperscale Tier.
2025-10-29
1,039 reads
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
In Level 2 of the Stairway to Hyperscale, we learn about Page Servers in more detail.
2025-09-17
755 reads
Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1
In Level 1 of the Stairway to Azure SQL Hyperscale, we learn about the architecture and create a hyperscale instance.
2025-09-03
3,604 reads
Stairway to Snowflake Level 8 - Event Tables
In this next level of the Stairway to Snowflake, we delve into Event Tables. These are used to capture telemetry from your Snowflake database.
2025-07-02
589 reads
Stairway to Snowflake Level 7 - Snowflake Tables
In this next level of the Stairway to Snowflake we examine the wide variety of table types that exist in the platform.
2025-06-13 (first published: 2025-05-21)
1,589 reads
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.
2025-06-06 (first published: 2025-05-07)
648 reads
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Snowflake has its own CLI tool: SnowSQL. In this level of the Stairway Series learn how to work with this dialect in Snowflake and Visual Studio Code.
2025-06-13 (first published: 2024-11-20)
1,683 reads
Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases
In this next level of the Stairway to Snowflake, learn about creating and dropping databases, with some options for cloning from different sources.
2025-06-13 (first published: 2025-01-15)
2,388 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers