In celebration of their 25th anniversary in 2024, Redgate, as the host of PASS Summit, is thrilled to introduce the PASS Summit Futures Scholarship. This initiative aims to empower the next generation of data professionals from diverse backgrounds.
Applications are open internationally to students and early-career professionals. Each of the 10 lucky winners will be awarded:
Steve has a quick turnaround between trips that was a bit unexpected. Is there compensation for this?
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy.
In the first level of the Stairway to Database Containers, we learn how to get started with Docker for Windows, downloading an image, and starting a container.
The second level of the Stairway to Database Containers looks at the basics of persisting storage in your containers.
In this next level of the Stairway to Database Containers learn how to customer a container and save the changes to a new image.
You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]
Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
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