Blog Posts

Blog Post

Top 10 Careers in Data

Would you re-order these? Machine Learning Engineer $$$$$ Develop and deploy AI models Optimize machine learning algorithms for efficiency Work with big data frameworks to process large datasets Data...

2025-02-28 (first published: )

333 reads

Blog Post

T-SQL Tuesday #183 Roundup

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions. I didn’t get my own post completed in time, but I’ll add it in the...

2025-02-28 (first published: )

242 reads

Blog Post

The Mysterious Empty Table

It seems like no matter how long you work with a system beyond a trivial size, you’ll find something new every so often. A little while ago, I found...

2025-02-26 (first published: )

388 reads

Blogs

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

By

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Did You Really Name That Default?

By

Ten years (and a couple jobs) ago, I wrote about naming default constraints to...

Monday Monitor Tips: A New Analysis Page

By

We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

By Terry Jago

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

By dbruton95

Comments posted to this topic are about the item The Problem Isn't Always Your...

Identity Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identity Defaults

Visit the forum

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