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)
512 reads
Editorials
Widespread New Technology Adoption
It can be hard to change peoples' habits and get them to adopt new technology.
2025-03-15
100 reads
2025-03-14 (first published: 2018-11-02)
280 reads
2025-03-12 (first published: 2018-10-19)
1,038 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)
314 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
153 reads
Tracking Table Sizes
Today Steve asks if you track the details of your table growth inside a database.
2025-03-07
190 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
245 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
167 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
87 reads
Blogs
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
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