SQL Server 2005 Scripts on TechNet
I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...
2006-09-01
1,458 reads
Blog Posts
Dallas Code Camp 2006
Generally I don't look forward to giving up an entire Saturday at work. However, today's Dallas Code Camp was an...
2006-08-29
1,583 reads
Removing SQL Server Express from VS Team System for Database Professionals CTP 5
As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...
2006-08-24
1,385 reads
Downtime
Under the category of working too fast, today's downtime was brought to you by me.
I've been working an issue with...
2006-08-23
1,442 reads
Visual Studio Team System for Database Professionals CTP 5 Out
If you aren't aware, the Visual Studio Team System for Database
Professionals CTP 5 is available for download. It's a significantly
larger...
2006-08-23
1,429 reads
The Importance of Database Coding Standards
I was working with a developer the other day and the question came up
of how to return status from a...
2006-08-17
1,825 reads
Long Time No See
OK, it's been a long time since I made an entry here, mostly because I've been busy and keep forgetting...
2006-08-15
1,413 reads
2006-08-09
2006-08-09
1,408 reads
2006-08-09
1,325 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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