PASS 2012 Countdown – 3 Weeks To Go
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2012-10-17
1,744 reads
StrateSQL
Indexing Book Winner
Back on October 3, I put up a post about a free indexing book. And specifically about Expert Performance Indexing for...
2012-10-17
572 reads
Lost in Translation – Deprecated System Tables – sysfulltextcatalogs
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-17
628 reads
Lost in Translation – Deprecated System Tables – sysforeignkeys
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-19 (first published: 2012-10-16)
1,760 reads
Last Weeks Top 10 “Reading” Links #2
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-15
718 reads
Ask the Unicorn: How to become a DBA?
Every now and then I get a question in e-mail and I usually just reply and leave it at that. ...
2012-10-12
686 reads
Lost in Translation – Deprecated System Tables – sysfiles
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-12
1,147 reads
Reblog: October 5 to October 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-12
488 reads
24 Hours of PASS Recordings Online
This just in… the 24 Hours of PASS sessions are in and available for streaming. If you missed an hour...
2012-10-11
1,029 reads
Lost in Translation – Deprecated System Tables – sysfilegroups
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-11
771 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