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
129 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
272 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
216 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
265 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
129 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
44 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
106 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers