Database Development Visibility using Flyway and PowerShell
The payback of DevOps is not simply in automation but in using that automation to increase the visibility of the development processes. This article demonstrates way to make Flyway developments more visible, regardless of your RDBMS, such as by providing a detailed migration history, and change reports that reveal detail of what is going on to all involved.
How to automate table level refresh in Power BI
You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this article.
SSIS Environment Design Patterns
In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments.
Project Zero for Better Security
Project Zero from Google aims to study zero day vulnerabilities. Steve hopes it leads to better security.
The Configured Data Masks for Dynamic Data Masking - Step 3 of the Stairway to Dynamic Data Masking
Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask.
What is the Flyway Teamwork Framework?
My FlywayTeamwork PowerShell framework is designed to help get you started quickly with developing databases, using Flyway versioned migrations. It introduces a PowerShell task library, and automation, to take care of repetitive chores. It will also help you get to grips with the practicalities of using Flyway in team-based development. This article explains the basics of its design and provides a demo how to use Flyway to migrate a PostgreSQL database, while generating a high-level narrative of the changes made between versions.
Working with MySQL Stored Procedures
MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.
Creating Tables in Power BI
This article shows how we can create tables in Power BI using code and DAX functions.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers