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-05-07
494 reads
Stairway Series
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-05-01 (first published: 2024-11-20)
1,348 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-01-15
2,267 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-04-02 (first published: 2024-12-18)
1,618 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.
2024-11-12 (first published: 2024-10-23)
1,334 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
975 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-04-02 (first published: 2024-08-14)
862 reads
Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
2024-07-17
630 reads
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.
2025-04-02 (first published: 2024-07-03)
1,098 reads
Level 27: Time Intelligence – Dates Functions: The DAX “Parallel Period” and “Same Period Last Year” Functions
Business Intelligence Architect, “Analysis Services Maestro, and author Bill Pearson introduces two somewhat similar DAX Time Intelligence functions related to “parallel” Date periods: PARALLELPERIOD() and SAMEPERIODLASTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-24
1,623 reads
Blogs
A New Word: Lookaback
By Steve Jones
lookaback– n. the chock of meeting back up with someone and learning that your...
Azure Vulnerability Assessments
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
Speaking at the NYC Lunch and Learn–May 23
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Forums
How Do You Know You Are Right?
Comments posted to this topic are about the item How Do You Know You...
continuous membership
Hi, I am trying to find everyone who had membership for a continuous year...
Migrating data from using ManagerId to HierarchyId
I have a table called Person with the following schema: CREATE TABLE [People].[Person]( [Id]...
Question of the Day
Decoding the Collation II
In a collation setting, like Latin1_General_100_CI_AS_KS_WS_SC_UTF8, what does the WS mean?
See possible answers