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 […]
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.
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works.
Overview PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language and Python is a high level, interpreted general purpose language. This article covers basic integration of Python with PostgreSQL apparently how we can establish connection with PostgreSQL database using Python program and perform CRUD operations on […]
Let's Encrypt upgrades their database servers and publishes the details.
In this tip we look at how to parse the SQL Server error log to only extract the errors and corresponding error messages.
Many of us grew up with one version of Cinderella or another. The step child that's horribly mistreated by the new parent is a scary story. In the Disney version, everything works out fine. However, if you read some of the original Grimm versions of the story (and there is more than one version), not […]
Cutting edge technology might vary for many people, and Steve wonders what you think.
It's probably not your fault, but relying on the defaults of a SQL Server installation might be impacting the performance of your instance.
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.
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
Comments posted to this topic are about the item Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers