PostgreSQL Springboot Integration Using JDBC Template
Learn how you can use Springboot to automatically make data changes for a new database in an application.
2022-06-03
7,764 reads
Articles
10 Benefits of Database Monitoring for Business Leaders [Video]
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of your business in ten key ways. Here's how a tool like Redgate SQL Monitor can save you money, time and assist with security and compliance concerns.
2022-06-03
Advanced Databricks Lakehouse Capabilities
Learn about several different aspects of Databricks Lakehouse such as encryption, row level security, visually viewing query plans, SQL merge, change data capture and more.
2022-06-03
Combinations, permutations, and derangements
Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.
2022-06-01
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.
2022-06-01
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.
2022-05-30 (first published: 2019-09-24)
15,999 reads
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.
2022-05-30
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.
2022-05-30
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.
2022-05-27 (first published: 2017-10-16)
6,954 reads
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.
2022-05-27
Blogs
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...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
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