Creating Subtotals and Totals in Aggregated Queries
Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.
2020-09-25 (first published: 2018-09-06)
11,459 reads
Articles
Database Development with GitHub
How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration testing, and using Redgate tools to automate tasks such as provisioning, database scripting, and testing.
2020-09-25
Searching and Finding a String Value in all Columns in a SQL Server Table
Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.
2020-09-25
Incremental Data Loading using Azure Data Factory
Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article. In this article I will go through the process for the incremental […]
2020-09-24
46,443 reads
Hands-On with Columnstore Indexes: Part 4 Query Patterns
All queries run fast against columnstore indexes, right? In this article, Edward Pollack demonstrates some query patterns that don’t perform well and how to get around the issues.
2020-09-24
Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle
With insights from a recent Gartner report, Redgate’s Jamie Wallis looks at the benefits of tracking, and acting on, key metrics early in the DevOps process and how they can apply equally to database monitoring. Read more.
2020-09-24
Managing Azure Blueprints with PowerShell
Learn about the Azure PowerShell cmdlet for Azure Blueprints in Azure Resource Manager framework and how to export, import, publish, and assign Azure Blueprints with PowerShell cmdlets.
2020-09-23
Dear Past Me on My First Day as a DBA
A letter to a past self from Pamela Mooney that might help a more junior DBA get up to speed quicker.
2020-09-22
3,085 reads
Data Masker with SQL Data Catalog Integration Automates Data Protection Process
Data Masker for SQL Server now integrates with SQL Data Catalog (seamlessly with our new GUI) to let you fully automate your data privacy and protection process, from data classification through to masking.
2020-09-22
Explaining SQL Server Statistics with Playing Cards
When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio.
2020-09-22
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers