Transformations by the Oracle Optimizer
To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several possible optimizations for one query.
PostgreSQL in Azure using the Azure Data Studio Extension
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
Speedy Break Fix
Is DevOps and Agile better than waterfall? Steve has a few thoughts after a recent experience.
Enterprise SQL Server Performance Tuning and Management with dbWatch
We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an efficient and automated manner with a small team?
Help shape the future of Flyway
We’ve got some big plans for this year, and are looking to talk to people who use Flyway in a professional capacity. If you are willing to talk to us about how you first started using Flyway, then get in touch. Of course we’ll also look to say thank you for your time in our usual fashion.
Please include your DDL
I haven’t done it much the past few years, but I would answer some programming questions posted in forums back in the day. In the late 90s, I answered Visual Basic questions and eventually switched to SQL Server questions here on SQL Server Central as my career progressed. Answering questions not only assisted someone else, […]
The Great Developer Resignation
In 2021, many companies had employees leave positions. The number of people resigning from their jobs was so high that the term "The Great Resignation" began appearing in many publications. A number of industries were affected, and there are no shortage of pundits and experts analyzing why. This happened primarily in the US, but the […]
Using Logging with the Delete Activity in Azure Data Factory
This short piece shows how to add logging for the Delete activity and track which files or folders are deleted.
Data lakes take on big data
A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it available on-demand. Robert Sheldon explains the benefits and challenges of data lakes.
Google Cloud DB DevOps Report: Read Now
The 2021 report from the DevOps Research and Assessment (DORA) team at Google Cloud has now been published and provides highlights from seven years of research and data from more than 32,000 professionals worldwide.
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers