Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,414 reads
Blog Posts
Heading to N'Awlins
I'm leaving today for SQLSaturday #17, actually in Baton Rouge. I'll be at the speaker party tonight and hope to...
2009-07-31
1,553 reads
No really. When did this statement start?
I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific...
2009-07-31
1,321 reads
PASS & SQL Bloggers
PASS is trying to find better ways to reach out to SQL Bloggers. They’re going to experiment with taking advantage...
2009-07-31
1,318 reads
Things You Need To Know If You Use DFS Replication
In addition to being a SQL DBA I'm also a network administrator, or at least I pretend to be. This...
2009-07-31
2,848 reads
24 Hours of PASS - Building a Better Blog
I got asked to do an hour during the 24 hours of PASS that is happening on Sept 2. It's...
2009-07-30
1,374 reads
Book Review: The Connect Effect: Building Strong Personal, Professional, and Virtual Networks
I read The Connect Effect: Building Strong Personal, Professional, and Virtual Networks by Michael Dulworth ($16 @ Amazon) months ago, forgot...
2009-07-30
1,903 reads
70-433 Or Bust: Working toward MCTS Microsoft SQL Server 2008 Database Development
The 70-433 will be my first Microsoft certification test. There are two main reasons why I've decided to take on...
2009-07-29
4,234 reads
Embedding Bing Maps in a Web Page
I was doing some maintenance on the SQLSaturday web site recently and one request kinda low on the list was...
2009-07-29
3,584 reads
Netbook Experiences
I’ve had an HP Mini netbook for about a month now and have been using it on and off. Actually...
2009-07-29
1,405 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