AI In the Nov 2023 Enterprise
An OReilly Radar report on AI has some interesting data to Steve. Read what he thinks about the state of this technology in 2023.
2023-12-20
159 reads
Editorials
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
172 reads
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
51 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
131 reads
2023-12-13
226 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
150 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
63 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
176 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
178 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
292 reads
Blogs
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers