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-06-06 (first published: 2024-07-03)
1,276 reads
Stairway Series
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,681 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,554 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,797 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
2,268 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,869 reads
Stairway to Database DevOps Level 2: Manage Code with Red Gate SQL Source Control
In this second level of the Stairway to Database DevOps, we learn to use Redgate's SQL Source Control to save and updates changes to objects, as well as tracking data in certain tables.
2023-10-18
1,294 reads
Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: TOTALMTD(), TOTALQTD(), and TOTALMYD(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-16 (first published: 2023-09-27)
918 reads
Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps
In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.
2023-10-16 (first published: 2023-09-13)
2,918 reads
Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: CLOSINGBALANCEMONTH(), CLOSINGBALANCEQUARTER(), and CLOSINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-16 (first published: 2023-08-30)
840 reads
Blogs
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
New article: Automating SQL Server Builds
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
Leading with Accountability: How Extreme Ownership Transforms Leadership
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Forums
Change Tracking Default Retention
Comments posted to this topic are about the item Change Tracking Default Retention
ssrs subscription file share
I am trying to create a subscription that posts to a one drive directory. ...
What is Delayed Durability in SQL Server — And Should You Turn It On?
Comments posted to this topic are about the item What is Delayed Durability in...
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers