SSC Moving
As if it weren't enough that I was moving my home, the SSC site is also moving. I'll drop some...
2006-01-18
1,424 reads
Blog Posts
A Funny Thing Happened at Starbucks
I decided to commit to the book, so I'm waiting on some information and a contact from my co-author and...
2006-01-12
1,458 reads
Awesome Interview on Windows Vista Kernel Architecture
This actually premiered on Channel 9 right before Christmas. It is an
interview with Rob Short, a Microsoft VP in charge...
2006-01-07
1,507 reads
Guidance on .WMF patch from Mike Nash, Microsoft Corporate VP
There is a new posting from Mike Nash on the Microsoft Security Response Center blog:
http://blogs.technet.com/msrc/archive/2006/01/05/416980.aspx
Relevant quote:
So the thing that I...
2006-01-05
1,461 reads
Microsoft .WMF Security Patch Releasing Today (out-of-cycle)
Microsoft has announced they will release a security hotfix at 2 PM PST for the WMF design flaw. More details...
2006-01-05
1,415 reads
Remote DBA
I'm getting ready to look for a new cell phone and I got lots of suggestions from my editorial on...
2006-01-05
1,526 reads
To Write or Not to Write
That's the decision to be made.
Apress contacted me about the update for my book. I wrote 1/2 of the Designing...
2006-01-05
1,496 reads
Sample Chapter from Professional SQL Server 2005 Integration Services
Brian Knight posted a sample chapter for Professional SQL Server 2005 Integration Services
to his blog a few days ago. Last...
2006-01-04
1,477 reads
Simple Script to Report Tables Sizes in a SQL2K Database
Last week we had an issue with a database growing unexpectedly. The
database in question supported an infrastructure type 3rd party
application...
2006-01-04
1,336 reads
Philosophy on Soldiering
This is taken from the book About Face:The Odyssey of an American Warrior.
The author is Col. David "Hack" Hackworth, one...
2006-01-01
1,412 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