SQL Saturday Jacksonville
I just wrapped up a high-octane day of SQL Server community education at SQL Saturday in Jacksonville, Florida. This event,...
2008-05-04
868 reads
Blog Posts
Are Backup Devices Obsolete?
I thought they were, but I've had a bit of a debate in the forums with someone. There was a...
2008-05-02
696 reads
Displaying Multi-select Parameters in SSRS
Including the parameter values to the physical report so they get printed with the business data is a best practice...
2008-05-02
501 reads
Off-topic: The Citadel Honors Class That Did Not Graduate
The purpose of The Citadel, the Military College of South Carolina, is to prepare South Carolina's citizen soldiers. It is...
2008-05-02
873 reads
Podcast Upgrades
A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a bit...
2008-05-02
1,918 reads
Looking for Incremental Improvements
If you've read my blog much you'll know that I'm deeply involved in trying to figure out how to build...
2008-05-01
530 reads
Technorati
I've never really been a big fan of many of the aggregation sites. As such I have never really used...
2008-05-01
713 reads
The Post Count
One of the things that I made a conscious effort to do last summer was make a regular effort to...
2008-05-01
727 reads
Review of Pro SQL Server 2005 High Availability
I grabbed Pro SQL Server 2005 High Availability by Allan Hirt recently to add to the library and I've been...
2008-04-30
1,365 reads
Building Raffle Tickets for SQLSaturday
Raffle tickets have become a mainstay of our events, making it easy to handle the large volume of items donated...
2008-04-29
1,611 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