Keep a Spare
I wanted to get working on Katmai a little, but not being brave and seeing the release notes that it...
2007-06-20
1,357 reads
Blog Posts
A Motivational Quote
Normally I don't post this sort of thing to my blog, trying to focus on more technical matters, but this...
2007-06-19
1,682 reads
GO More than Once?
SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and...
2007-06-18
1,371 reads
Gartner Developer Conference
It's been quite a week at the Gartner Application Development and Integration converence here in Nashville. I've never been to...
2007-06-13
2,003 reads
Mirrored Backups Posted on SSC
This was fun to run through, nice to see MS adding features even if in my view they didn't quite...
2007-06-12
1,327 reads
Tampa Code Camp 2007
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go...
2007-06-12
1,344 reads
June Midlands PASS Meeting Canceled
We are canceling the June Midlands PASS meeting because the speaker (me) is still under the weather. I'll post in...
2007-06-07
1,302 reads
Katmai Manageability
The database manages itself. Not totally, but close to it. It was an
analogy made by Dan Jones with cars. Auto...
2007-06-06
1,351 reads
Southern BBQ
Last night I went out with Tony Davis of Simple Talk and Alan White, a
longtime author for both here and...
2007-06-06
1,392 reads
SQL Server 2005 Security
It's a similar theme, off by default if it makes sense, minimize surface area.
Recommendations: for new installs, leave stuff off...
2007-06-06
1,471 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