SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
2022-01-19
Additional Articles
Power BI Zoom and Focus
In this article we look at how to add the zoom feature to your charts and graphs in Power BI reports for a better user experience.
2022-01-17
Where's the best place to live as a DBA?
Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here!
2022-01-17
A Database DevOps Workflow Using Redgate Deploy
Tony Davis describes a typical database development cycle and deployment pipeline supported by Redgate Deploy. It allows branch-based database development, using disposable databases (clones) and version control tools, promotes continuous integration and testing of changes and automates the build and deployment processes so that they are repeatable, fast and reliable.
2022-01-14
Quantifier predicates
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
Automating Flyway Undos
How to auto-generate first-cut undo scripts for every Flyway migration. For every new version of a database created by a Flyway versioned migration, we compare it to a 'source' directory containing object-level build scripts for the previous version. The SQL Compare engine does the rest, producing the associated undo script that will revert the database to the previous version, if required.
2022-01-12
Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment
In this article we walk through how you can run Python scripts using SQL Server Agent, so you can setup scheduled jobs to run your Python code.
2022-01-12
Getting Started with Cloud-hosted Databases using Spawn
This article will get you started with Spawn, a hosted database cloning service running entirely on Amazons AWS.
2022-01-10
How to filter DAX for paginated reports
DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.
2022-01-10
Azure Policies and Management Groups
You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood explains Azure Policies and Management Groups.
2022-01-07
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
Alamat Telp BCA KCP Batu +62 838-4945-0961
Wa:083849450961 Jl. Panglima Sudirman No.1, Ngaglik, Kec. Batu, Kota Batu, Jawa Timur 65311
Alamat Telp BCA KCU METRO +62 838-4945-0961
Wa:083849450961 Jl. Jendral Sudirman No.106, Imopuro, Metro, Kota Metro, Lampung 34111
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
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