Significant Achievements
As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...
2012-11-28
737 reads
StrateSQL
Lost in Translation – Deprecated System Tables – sysreferences
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-28
1,337 reads
Querying Performance Counters in SQL Server
In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query. ...
2012-12-06 (first published: 2012-11-27)
6,800 reads
Help Bring #SQLFamily to Fargo, North Dakota
Did you know that a SQL Saturday in Fargo is in the works? If not them, hey… there’s a SQL...
2012-11-30 (first published: 2012-11-26)
1,178 reads
Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
810 reads
Last Weeks Top 10 “Reading” Links #8
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-26
634 reads
Reblog: November 16 to November 22
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-23
648 reads
Lost in Translation – Deprecated System Tables – sysperfinfo
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,331 reads
Lost in Translation – Deprecated System Tables – sysobjects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,559 reads
Lost in Translation – Deprecated System Tables – sysusers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,770 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