How to filter DAX for paginated reports
DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.
2022-01-10
Additional Articles
Azure Policies and Management Groups
You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood explains Azure Policies and Management Groups.
2022-01-07
Using Flyway Teams with SQL Change Automation PowerShell Cmdlets
Use Flyway to run your database migrations, each time automatically creating a SQL Change Automation release object to provide object-level scripts and a build script for the new version, along with change reports and code analysis reports.
2022-01-07
Exploring Auto-fix in SQL Code Analysis
Phil Factor presents a useful but slightly flawed 'table report' script as an adventure playground for exploring SQL Code analysis issues. He demonstrates use of the auto-fix feature, to arrive at a pristine script free from wavy green underlines.
2022-01-05
How to return multiple sequence numbers with sp_sequence_get_range
Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.
2022-01-05
Adding Users to Azure SQL Databases
Learn about the options to add users to Azure SQL Databases including SQL authentication logins, contained SQL users, contained Azure Active Directory users, mapped logins to users - including code examples you can copy and use immediately.
2022-01-03
Dealing with Failed SQL Migrations in MariaDB or MySQL
This article explains the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
2021-12-31
How to Create a FOR Loop in SQL Server
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
2021-12-31
A Day in the Life of a SQL Server Data Architect
This article looks at what an average day of a SQL Server Data Architect looks like and some of the things you would need to as a Data Architect.
2021-12-29
DBAs at work #3: The finance company Manager DBA
Want an insight into how your fellow DBAs work? This episode features Kevin Davis, Manager of Database Administration at Tower Loan, a consumer finance company with 250 branches across the US.
2021-12-29
Blogs
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers