Tracking Table Sizes
Today Steve asks if you track the details of your table growth inside a database.
2025-03-07
Editorials
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
140 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
107 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
70 reads
Your Biggest Data Model Complaints
Today Steve asks which data model issues are most annoying to you.
2025-02-28
102 reads
Why Not Use AI?
Steve re-posts a question from someone else, asking why you wouldn't want to use an AI.
2025-02-26
168 reads
2025-02-24 (first published: 2018-10-19)
925 reads
2025-02-24 (first published: 2018-11-02)
158 reads
The Wild Developers of SQL Server like Wildcards
Phil Factor explains the enduring attachment of database developers to wildcards, despite their current deficiencies.
2025-02-24 (first published: 2018-12-17)
319 reads
2025-02-24
95 reads
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
How to Download and Restore AdventureWorks 2019 Database
Comments posted to this topic are about the item How to Download and Restore...
Tracking Table Sizes
Comments posted to this topic are about the item Tracking Table Sizes
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers