When to Use Zero
Charts and graphs need a scale to be meaningful. When to include zero in your scale is a question that is more complicated than Steve expected.
2022-04-13
127 reads
Editorials
Moving Away From MySQL
A developer has some harsh things to see as he leaves the MySQL team. Is he right?
2022-04-11
271 reads
Document yourself out of a job
Some organizations have policies in place to make sure that everything in their IT infrastructure is documented. There are runbooks, procedures, wikis, diagrams, charts, code comments, and more to make sure that knowledge is available if an employee leaves or when disaster strikes. Not only does the documentation exist, but it’s also organized and easy […]
2022-04-09
215 reads
The Backlog
A backlog is important for software development, and Steve has a few thoughts on how to add things to the backlog.
2022-04-08
264 reads
Advanced Incident Response
Having a known and documented incident response plan is important these days, as more and more companies are having security incidents.
2022-04-06
128 reads
Virtual Events Are Here To Stay
This week was the MVP Summit. As was the case for the last couple of years, the event was entirely virtual. We were shown a bunch of new and interesting things by Microsoft. We were able to talk to each other and to the engineers at Microsoft. I'm honored that I've been an MVP and […]
2022-04-02
43 reads
Executing Notebooks in a Stored Procedure
Writing notebooks in Azure Data Studio is a great way to keep a number of queries in one place and execute them together. Steve has a way to do this inside a stored procedure.
2022-04-01
619 reads
2022-03-30
116 reads
Easily Repeating Work
There are many ways to work more efficiently, but tracking and saving your work might be one of the best.
2022-03-28
133 reads
2022-03-26
105 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers