The Wild Developers of SQL Server like Wildcards
Phil Factor explains the enduring attachment of database developers to wildcards, despite their current deficiencies.
2025-03-17 (first published: 2018-12-17)
328 reads
Editorials
Widespread New Technology Adoption
It can be hard to change peoples' habits and get them to adopt new technology.
2025-03-15
33 reads
2025-03-14 (first published: 2018-11-02)
234 reads
2025-03-12 (first published: 2018-10-19)
988 reads
Understanding a Database
The ways in which you might try and reverse engineer a database design are on Steve's mind today.
2025-03-10 (first published: 2018-11-30)
249 reads
Shadow AI Data Leak Risk or “From the Desk of I saw that Coming”
CSO recently published an article based on a report from Harmonic about generative AI data leaks, and the findings were eye-opening. According to the report, over 8% of employee prompts to public large language models (LLMs) contained sensitive data, ranging from security and compliance issues to privacy and legal vulnerabilities. This wasn’t just a handful […]
2025-03-08
96 reads
Tracking Table Sizes
Today Steve asks if you track the details of your table growth inside a database.
2025-03-07
126 reads
The Job Outlook for Database Professionals
The job outlook for database professionals is good, but it's not that easy to get a great job. Steve has some advice for you today.
2025-03-05
190 reads
A Poor Data Model
Steve has a few thoughts on natural keys, which often turn out not to be as unique as we expect.
2025-03-03
129 reads
What is time?
There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]
2025-03-01
71 reads
Blogs
Securing Kubernetes With External Secrets Operator on AWS
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
Save Azure PostgreSQL Backup to Storage
This may or may not be helpful in the long term, but since I’m...
The Book of Redgate: What’s Great about Redgate?
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Pitfalls to avoid while feeding events into CrowdStrike
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Column Adds and Drops
Comments posted to this topic are about the item Column Adds and Drops
Question of the Day
Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers