I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly […]
2022-03-05
103 reads
The DBA role might be changing, but Steve thinks this creates opportunities.
2022-03-04
421 reads
Many developers have made mistakes that in test and development environments that customers notice. Using DevOps should help reduce these issues.
2022-03-02
213 reads
In some ways the world changes a lot; in others, it's very much the same. Steve notes that often change brings opportunities, if you can adapt.
2022-02-28
163 reads
Becoming overly enthusiastic about a new SQL Server feature can backfire if you don’t do some testing. One example is the table variable introduced with SQL Server 2000. At the time, there was a myth that table variables would always perform better than temp tables with the reasoning that, by definition, variables are stored in […]
2022-02-26
409 reads
The features we want and get in a database platform can make our job easier or harder. Steve has a few thoughts on how they should work.
2022-02-25
175 reads
A reminder today that security in the physical world can affect the digital world.
2022-02-23
208 reads
Continuous backup in Cosmos DB doesn't quite work as Steve would expect. He has a few comments on why it is important you know how your backup and restore system works.
2022-02-21
444 reads
Years ago I worked at a large company, and we purchased a SAN appliance to consolidate our storage. This was at a time when the majority of our servers used locally attached storage. This was a big purchase, and we knew that we had to plan for issues. So, we actually purchased two appliances and […]
2022-02-19
60 reads
Steve wants you to manage your career and actively find the job that is best for you.
2022-02-18
178 reads
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item 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