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.
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.
Artist or Scientist?
In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?
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.
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.
Bronze Age Development
The slow pace of Visual Studio development had a number of problems over the years, but Microsoft has dramatically changed the way they build their software for the better.
How to Restore an Agent Job that was Dropped
Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]
How to Restore an Agent Job that was Dropped
Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]
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.
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.
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers