Executing Optional Code in Flyway Callbacks
This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.
2022-12-28
Articles
Change the Instance Collation by Rebuilding Databases in SQL Server 2017
As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
2022-12-26 (first published: 2020-08-03)
23,571 reads
Building a SQL Computational Framework for MACD Indicators
This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.
2022-12-26
The Lock Escalation Threshold – Part 3
The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use.
2022-12-26
Calling Procs from PowerShell with Parameters
Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.
2022-12-23 (first published: 2020-08-20)
29,469 reads
Flyway Desktop in Database Development Work: An Overview
For those new to Flyway Desktop, this article takes a strategic overview of the components of a Flyway Desktop project, how to set up a project for team-based development work, and how we can use the tool in conjunction with a version control system and CI servers to manage a database development and release process.
2022-12-23
Heapq Module in Python: Using Heaps and Priority Queues
In this tutorial, learn about Python priority queues and heaps, how do they relate, and how to use the heapq module in Python.
2022-12-23
Maintaining a Utilities Schema in a Flyway Project
This article demonstrates how to manage these utilities from Flyway so that we can maintain and migrate them separately from the database objects.
2022-12-21
The Basics of Deleting Data from a SQL Server Table
n my last article “Updating SQL Server Data” I discussed using the UPDATE statement to change data in existing rows of a SQL Server table. In this article I will be demonstrating how to use the DELETE statement to remove rows from a SQL Server Table.
2022-12-21
Artificial Intelligence with Power BI
Get a brief introduction to using the AI features in Power BI.
2022-12-19
18,771 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers