Lost in Translation – Deprecated System Tables – syspermissions
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,106 reads
StrateSQL
Lost in Translation – Deprecated System Tables – systypes
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-20
947 reads
Lost in Translation – Deprecated System Tables – sysopentapes
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-20
866 reads
Lost in Translation – Deprecated System Tables – sysoledbusers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-19
967 reads
Lost in Translation – Deprecated System Tables – sysmessages
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-19
698 reads
Last Weeks Top 10 “Reading” Links #7
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-19
565 reads
Lost in Translation – Deprecated System Tables – sysmembers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-16
742 reads
Lost in Translation – Deprecated System Tables – syslogins
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-16
1,193 reads
November 2012 – Monthly SQL Server Checklist
Last week was the PASS Summit and there were a few cool announcements made. One in particular was the release...
2012-11-12
573 reads
Last Weeks Top 10 “Reading” Links #6
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-12
640 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