SQL RNNR

Blog Post

Events By Feature

Within the world of SQL Server there are a few things one can be certain of - things will change. This is true of the features in SQL Server....

2016-08-30

3 reads

Blog Post

Finding the Right Path

What is this gaping hole in the coverage of Extended Events? To be honest, it is not a very complicated topic or very difficult gap to fill. It's just...

2016-08-24

5 reads

Blog Post

T-SQL Tuesday #081: Recap

August 2016 TSQL Tuesday Recap
Related Posts:

T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018

Passion, Challenges, and SQL February 12, 2019

T-SQL Tuesday #102: Giving Back May 8, 2018...

2016-08-18

4 reads

Blog Post

T-SQL Tuesday #081: Getting Sharper

Getting sharper at JSON through a little experimentation.
Related Posts:

Passion, Challenges, and SQL February 12, 2019

T-SQL Tuesday #097: Learning Plans December 18, 2017

T-SQL Tuesday 109: Influence Somebody Invite...

2016-08-16

4 reads

Blogs

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...

Case Studies: Real-World Success Stories of FinOps Implementation

By

Learning any kind of theory is easy, but adapting FinOps and watching it rescue...

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