Combinations, permutations, and derangements
Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.
Managing Database Code Quality in a Flyway Development
In this article, I'll discuss the most important quality metrics for a database development, and then practical ways to ensure that a Flyway-managed database is designed and implemented to a high enough standard that it is reliable to use.
Audit systems: a good idea or a mess to maintain?
Audit systems can be a good idea, but they can also be a mess to maintain.
Using tsqlt Tests to Practice Queries
In this short article, see how a unit test can be easily written in tsqlt, and how this can help us refactor or build better code.
Getting Started with Flyway and any RDBMS
How to get started with Flyway, as simply as possible, using PowerShell. This article provides a practice set of Flyway migration scripts that will build the original pubs database on either SQL Server, PostgreSQL, MySQL, MariaDB or SQLite and then migrate it from version to version, making a series of improvements to its schema design.
Search all String Columns in all SQL Server Tables or Views
In this article we look at T-SQL script you can use to search for a string in every table and view in every database or in a specific database.
Loading Data using R and PowerBI
I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.
Memory profiling in Python with tracemalloc
You can find memory leaks in Python code with tracemalloc. In this article, Priyanka Nawalramka demonstrates how to use tracemalloc to find the leaks.
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers