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,871 reads
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,742 reads
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,096 reads
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,031 reads
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
2024-07-17
903 reads
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
2025-06-06 (first published: 2024-07-03)
1,388 reads
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,807 reads
In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
2024-01-20 (first published: 2024-01-17)
1,659 reads
In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
2024-01-20 (first published: 2023-12-13)
1,892 reads
The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]
2023-12-06
2,399 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers