This article explains the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems.
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
This article looks at what an average day of a SQL Server Data Architect looks like and some of the things you would need to as a Data Architect.
Want an insight into how your fellow DBAs work? This episode features Kevin Davis, Manager of Database Administration at Tower Loan, a consumer finance company with 250 branches across the US.
This article explores how to create and use views in SQL Server 2019 using SSMS.
This article will get you up and running quickly with Flyway migrations on MariaDB or MySQL databases, from PowerShell.
Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Gedung, Wisma Slipi, Jl. Letjen S. Parman No.Kav. 12 Lantai 1, Slipi, Kec. Palmerah,...
KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8 blok P5, Medan Satria, Kecamatan...
CSTelpon : 0853-73737551 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers