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
4,282 reads
Stairway Series
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
658 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,639 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)
686 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,946 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,442 reads
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 […]
2025-06-06 (first published: 2024-12-18)
1,915 reads
Stairway to Snowflake Level 4 - Introducing Snowsight, Snowflake’s Web UI
This next level of the Stairway to Snowflake looks at the Snowsight UI and what you can accomplish with it.
2025-06-13 (first published: 2024-10-23)
1,868 reads
Stairway to Database Containers Level 4: Using a Docker Compose File
In the next level of the Stairway to Database Containers, let's learn to use a compose file to specify a number of options for our container.
2024-08-28
1,127 reads
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.
2025-06-06 (first published: 2024-08-14)
1,048 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Demak | Tlp/Wa:0818751777
Tlp/Wa_Cs:0818-751-777 Jl. Sunan Kalijaga No.03 & 04, RT.04/RW.10, Tanubayan, Bintoro, Kec. Demak, Kabupaten Demak,...
BCA KCP Dinoyo | Tlp/Wa:0818751777
Tlp/Wa_Cs:0818-751-777 Jl. Mayjen Haryono No.160, Dinoyo, Kec. Lowokwaru, Kota Malang, Jawa Timur 65114
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers