Clustering data for insights
Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick demo.
2022-05-02
Additional Articles
Creating Flyway Migration Files using Redgate Schema Comparison Tools
How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files.
2022-05-02
Finding deeper insights with Topic Modeling
Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.
2022-04-29
Webinar | Gain the competitive edge with a monitoring tool
Robust database monitoring is at the heart of ensuring business continuity, customer satisfaction and protected revenue, and this webinar with Chris Yates, Senior Vice President, Managing Director of Data and Architecture at Republic Bank, will clearly demonstrate why.
2022-04-29
Continuous Data Protection with SQL Data Catalog 2.0 and Data Masking
SQL Data Catalog 2.0 provides a simple, policy-driven approach to data protection, through data masking. It can now automatically generate the static masking sets that Data Masker will use to protect your entire database, directly from the data classification metadata held within the catalog.
2022-04-27
Why your PL/SQL needs to be testable – and how to do it: Part 1
Part 1: What is testable code, why is it important, and first glimpses on practices that can help
2022-04-27
The 10 Benefits of Monitoring for Leaders
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
2022-04-25
Understanding SQL Server Linked Servers
In this tip we look at how to setup a Linked Server in SQL Server using SQL Server Management Studio.
2022-04-25
Getting an Overview of Changes to a PostgreSQL Database using Flyway
How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts.
2022-04-22
Site Reliability Engineering vs. DevOps
What’s the difference between Site Reliability Engineering and DevOps? In this article, Grant Fritchey defines each one and compares them.
2022-04-22
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers