Data Debt
The idea of data debt seems both silly and obvious to Steve. We all have too much data and it's out of control.
2025-01-31
143 reads
Editorials
Creating vs. Maintaining
When you create something, do you think about the future? Steve asks the question today.
2025-01-29
137 reads
The Era of Cloned Humans
AI has tremendous possibilities but also a number of security issues. Steve highlights one scary security issue today.
2025-01-27
107 reads
Technical Pain Behaviors
In my family’s history of the past 10+ years, we have become well versed in nagging, ongoing, non-debilitating pain. In some ways, the lessons we have learned about physical pain correlate all too well to the types of pain that we technical people are involved with daily. But there is a huge difference, even if […]
2025-01-25
76 reads
Can You Become a More Productive Engineer?
Steve has a few thoughts on becoming more effective. This involves more than just becoming a better coder.
2025-01-24
152 reads
The AI Budget Assistant
Most of us don't work on budgets, but we are affected by them. Is it a good idea for IT management to use AI to help plan their budgets? Steve has a few thoughts today.
2025-01-22
95 reads
Why Tools Can Help You Do Your Job
This editorial was originally published on May 18, 2019. It is being re-run as Steve is on holiday. Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was […]
2025-01-20 (first published: 2019-05-18)
366 reads
2025-01-17
134 reads
The Managed Cloud Database Options
You have a number of options for moving your database to the cloud, but Steve has a few things you might want to consider before you do so.
2025-01-15
133 reads
Simple(r) Coffee
Choice is good, but too much choice can cause problems in both coffee shops and software teams, as Steve notes today.
2025-01-13
121 reads
Blogs
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
“SQL Server Is Slow” Part 4 of 4
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
Forums
visual studio seems to lose "provider" on pkg imports
hi, just to get this part out of the way, if my intended target...
ERD Tools recommendation
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Vector Datatype Dimensions
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers