Writing in my sleep
When I first got into IT full time 10 years ago, I noticed that my mind was constantly solving programming...
2007-09-25
1,272 reads
Blog Posts
Building a Local User Group
I've had a couple people ask me about ideas for growing (as opposed to starting) a SQL user group. While...
2007-09-24
1,340 reads
More & Better News about the PASS Summit from Edgewood
I try not to just post links to other content, but the guys at Edgewood did a pretty good job...
2007-09-23
1,319 reads
PASS and new SSC design
I'm rarely a "needy" guy, but I have to admit that I'm feeling a little left out. Due to project...
2007-09-23
1,447 reads
PASS Report
Somehow between the sessions, networking and socializing I never found time to post anything last week. So, I'm going to...
2007-09-23
1,329 reads
PASS Report Part 2
This was my 5th year at PASS and every year I enjoy catching up with old friends and meeting many...
2007-09-23
1,356 reads
SSC Site Upgrade
I see they finally rolled out the new site. Lots of annoying quirks so far, the biggest for me is...
2007-09-23
1,351 reads
Wayne Synder Elected President of PASS
Congratulations to Wayne on becoming President! I've known him for years and you couldn't ask for a guy with more...
2007-09-23
1,422 reads
SQLServerCentral.com - V3!
It's done, it's out, and check it out!!!
I guess if you got here, you've probably noticed 🙂
This was a fairly...
2007-09-22
1,402 reads
Notes from PASS - Part 3
Today was interesting. I headed for breakfast and after a few stops to chat with friends, wound up sitting with...
2007-09-21
1,468 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers