2022-05-02
92 reads
Editorials
What will convince you to upgrade?
You’ve probably heard that SQL Server 2022 is on the way, and, assuming the name doesn’t change, it will be later this year. That is great news for folks in the data platform community as features and improvements they’ve been hoping for are added. I’m not currently supporting any production SQL Servers, but I’m still […]
2022-04-30
123 reads
Gathering Data Through Life
Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]
2022-04-29
139 reads
Migrating a Large Database
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
2022-04-27
1,187 reads
The Craziness of Code
Building software can seem like a crazy process, especially to a developer who joins a project.
2022-04-25
265 reads
Scripting Makes Mistakes Easier Than Ever
A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.
2022-04-22
188 reads
Using T-SQL over PoSh
When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.
2022-04-20
179 reads
A Third Space
We used to work in offices, now we work at home. Do we need a third space? Steve does.
2022-04-18
182 reads
Constant Azure Improvement
This week I noticed a number of changes in the Azure platform from their change feed. Actually, every week has a crazy number of changes across the entire platform, but this week a number of these were related to data and databases. That isn't always the case, but I saw some interesting items. We have […]
2022-04-16
91 reads
Your User Manual
Many of us have spent time looking through manuals or the documentation for some software or product. I know I'm on the MS docs site regularly for work, and there is no shortage of times I've used various manuals to help me fix something around the house. We usually use a manual when we want […]
2022-04-15
126 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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