Migrations are Worth the Effort
Steve prefers database migrations as a way of making changes to a database, though he knows they are hard. He gives a few reasons to choose them.
2023-12-18
197 reads
Editorials
A Thriving Community Lifts All Boats
I'm writing this on the last day of PGConf.EU, sitting here in Prague. I'm looking forward to sitting in several more sessions today, as well as having a few more conversations with the people at the conference. It's been a great event and I'm so happy I've been able to take part. Following the PASS […]
2023-12-16
66 reads
Try, Try Again, Until It's Right
A cloud migration for DoorDash interested Steve, primarily because it didn't work, but they were able to back out and try again.
2023-12-15
162 reads
2023-12-13
257 reads
Breaking Biometrics
Fingerprint readers on laptops are shown not to be as secure as they could be, and primarily because the manufacturers haven't done a good job implementing the secure protocols.
2023-12-11
162 reads
Love
Love is many a splendored thing. It is also a much-abused word with many different (and twisted) meanings. The type of love I wish to speak about today is not friendship, nor the kind of thing that makes your heart go pitter patter in the springtime, but rather the type of love known as storge, […]
2023-12-09
71 reads
Focus on Growth in Your Career
Steve has some advice on how to grow your career by growing your skills and developing deeper knowledge.
2023-12-08
191 reads
The Stagnant Career
A stagnant career can be stifling, and it can make you unhappy at work, where you spend a lot of time. Steve has a few thoughts on how to avoid that.
2023-12-06
193 reads
Be Careful with Missing Index Requests
Steve reminds people today that the recommendations from execution plans aren't always what you want to use when tuning your database.
2023-12-04
682 reads
The Fake Speakers
Someone generated a fake speaker profile for their conference, which Steve finds disturbing.
2023-12-02
536 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers