A New Word: Rivener
rivener – n. a chilling hint of distance that creeps slowly into a relationship – beginning to notice them laugh a little less, look away a little more, explain...
2025-08-22
18 reads
rivener – n. a chilling hint of distance that creeps slowly into a relationship – beginning to notice them laugh a little less, look away a little more, explain...
2025-08-22
18 reads
Let's build a real data dashboard. This guide will walk you through the entire process using free tools like BigQuery and Looker Studio, even if you’re just getting your...
2025-08-22 (first published: 2025-08-04)
1,170 reads
The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit external rest endpoints…which opens up quite a few interesting options. I was thinking about this...
2025-08-20 (first published: 2025-07-31)
523 reads
Migrating databases to the cloud can be complex, but Azure Database Migration Service (DMS) simplifies the process with a robust, fully managed solution. Whether you’re transitioning from SQL Server, MySQL, PostgreSQL,...
2025-08-20 (first published: 2025-07-31)
470 reads
If you’re responsible for a SQL Server instance, you need working, consistent backups. Not just a .bak file here and there, but a plan that runs automatically and covers...
2025-08-20
34 reads
This weekend was one of my favorite Data Saturday events, Data Saturday Columbus! If you’re in the area, I highly recommend it. Always some great speakers, amazing lunch, and...
2025-08-19
19 reads
Let’s be honest; technical teams don’t thrive under a microscope. They thrive under a mission. In a world where innovation moves at the speed of thought, the difference between...
2025-08-18 (first published: 2025-07-31)
471 reads
A customer was asking about how to track all the stored procedures that execute on their system. We have a section in Redgate Monitor that’s set to look at...
2025-08-18
21 reads
If you are responsible for securing databases, SQL Servers and others, I would strongly urge you to read the following post by Andreas Wolter, former data security PM for...
2025-08-18 (first published: 2025-07-30)
525 reads
Learn how to take a 20-minute power nap without embarassment. – from Excellent Advice for Living I don’t like naps. In fact, I try to avoid them and keep...
2025-08-15
24 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers