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 […]
2024-12-18
1,425 reads
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.
2024-11-20
1,187 reads
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,248 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
916 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.
2024-10-24 (first published: 2024-08-14)
758 reads
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
2024-07-17
467 reads
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
2024-10-24 (first published: 2024-07-03)
803 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,525 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,398 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,603 reads
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
hi i have 6 statistical populations in my overall data set. They run across...
Hi Suppose someone gained unauthorized access to the physical SS data stored on my...
Comments posted to this topic are about the item The Weather Outside Is Frightful
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers