Gitflow Workflow Hotfix Branching for SQL Database Projects
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
2021-02-05
Additional Articles
Oracle archived redo size – the research
Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.
2021-02-04
SQL Server SET STATISTICS IO ON Deep Dive
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
2021-02-04
CRUD Operations in SQL Server using Python
This article goes through a process to show how you can use Python to perform create, read, update, and delete (CRUD) operations on SQL Server data.
2021-02-03
Managing database changes using Flyway: an Overview
This article describes the principles of using Flyway migrations to build a database from scripts, to a specified version, and to track, manage and apply all database changes.
2021-02-03
Create Azure VM from a VHD image
Learn how to create an Azure VM image that can be used to quickly deploy new Azure VMs that are preconfigured based on your image settings.
2021-02-02
Database version control: Getting started with Flyway
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works.
2021-02-02
Simple way to find errors in SQL Server error log
In this tip we look at how to parse the SQL Server error log to only extract the errors and corresponding error messages.
2021-02-01
SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
2021-01-29
Finding Inactive SQL Server Databases
Phil Factor demonstrates how to use Extended Events to detect acquisition of Intent locks, and so determine which databases are active or apparently 'dormant', and then on which tables data has been modified recently, or which views and stored procedures have been run.
2021-01-28
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers