A Welcome Delay
I get a bit of a delay in working on the set down in the basement thanks to the weather....
2008-02-19
1,402 reads
Blog Posts
Dry Erase Board v2
When we first set up shop for End To End Training we knew we wanted both a flip chart and...
2008-02-19
1,604 reads
Errata for SQL Server Certification Books
Back in this blog post, I indicated which books I was using to complete the MCITP certifications for SQL Server....
2008-02-19
1,734 reads
How Stable is SQL Server 2005?
I've been calling for Service Pack 3 and I've been debating the need, the criticality, and even the problems with...
2008-02-19
1,530 reads
SQLSaturday #3 - Jacksonville 2008 - Registration and Call for Speakers is Open
My business partnerBrian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University...
2008-02-19
1,218 reads
Ideas for Managing Cables
I had to run all the cables for all the machines in our classroom recently and you know how messy...
2008-02-18
1,459 reads
Management Article Posted on SSC
I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for...
2008-02-18
651 reads
SQLSaturday #2 (Tampa 2008) Notes
Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very...
2008-02-18
1,414 reads
Turning off a server causes a flood of memories
I just shut down a SQL Server that has been in production since 2003. Next week I'll let the server...
2008-02-17
401 reads
Software Engineering
Some see this as a misnomer, or even an oxymoron. Many countries don't allow "engineer" to be a title for...
2008-02-16
1,086 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