2020-06-20
93 reads
Editorials
Evaluating Life at Work
It can be hard to evaluate your career and job situation, but Steve has some ideas today.
2020-06-19
204 reads
Why Billing Will Be Part of Our Job
I am old enough to remember when many large corporations implemented chargebacks. Essentially, each internal department was charged for their usage of IT systems, similar to how we are charged in the cloud. It was a mess, and individual departments had to answer for excessive charges. I don't know that any department ever lost service, […]
2020-06-18
239 reads
Other IDEs
Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us database options with Visual Studio, VS Code, and Azure Data Studio. It does seem as though Microsoft would prefer more of us move to ADS, but I'm not sure I'm […]
2020-06-17
302 reads
Making a Donation to PASS
With the PASS Summit moving to a virtual format, Steve is going to support the event.
2020-06-16
86 reads
I Read Quite a Bit
Today Grant talks about the challenges of sometimes finding good, current information.
2020-06-15
127 reads
What is Azure SQL Database Serverless?
I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]
2020-06-13
644 reads
Are You a Gatekeeper?
One of the problems that I've seen in many parts of life is the belief that things must proceed a certain way. I caught an article on ways teachers have made school less fun for kids because they adhered to some rule or belief too tightly. I think many of those stories are true because […]
2020-06-12
188 reads
The Benefits and Detractions of Remote
Working from home during the pandemic is likely to change many things, and Steve discusses a few today.
2020-06-11
125 reads
2020-06-10
143 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