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
123 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
265 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
207 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
248 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
127 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
39 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
616 reads
2022-03-30
114 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
129 reads
2022-03-26
103 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers