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-10-31 (first published: 2024-10-23)
1,076 reads
Stairway Series
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
867 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.
2024-10-24 (first published: 2024-08-14)
647 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
406 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.
2024-10-24 (first published: 2024-07-03)
598 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,454 reads
Stairway to Server Management Objects (SMO) Level 5: Moving to the SQLServer Module
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,339 reads
Stairway to Server Management Objects (SMO) Level 4: Scripting and Copying Small Databases
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,543 reads
Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)
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
1,955 reads
Stairway to Database DevOps Level 3: Managing Code as a Team in Git
In this level of the Stairway to Database DevOps, you'll get an introduction to branching and merging. Learn how to create a branch for making your changes to the codebase, submitting these in a code review, and then merging the changes into those made by other developers.
2023-12-01
1,779 reads
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Forums
Step by step guide to setup PostgreSQL on Docker
Comments posted to this topic are about the item Step by step guide to...
Backing up the Database Encryption Key
Comments posted to this topic are about the item Backing up the Database Encryption...
Technology Fears
Comments posted to this topic are about the item Technology Fears
Question of the Day
Backing up the Database Encryption Key
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers