Doing Good at SQL Server Central
Steve talks about some of the charitable work at SQL Server Central.
2026-02-20
68 reads
Editorials
Engineer Lessons
Steve thinks a few lessons on being a software engineer at Google are good items for anyone to think about.
2026-02-18
147 reads
2026-02-16 (first published: 2006-10-06)
390 reads
Microsoft Security Changes and SQL Server
Windows is changing its security, which will affect SQL Server.
2026-02-14
392 reads
Expanding into Print
This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were […]
2026-02-13
64 reads
The Power of Data and Privacy
Steve discusses privacy and data that is publicly available on the Internet.
2026-02-11
87 reads
The DBA is Dead; Long Live the DBA
There have many many times when a company or individual has thought that DBAs aren't needed. Steve doesn't think that has ever been true, nor will it be anytime soon.
2026-02-09
232 reads
Optimism Without Illusion or Why AI Needs Blunt Technologists
There is a temptation, especially in technology, to mistake momentum for maturity.
2026-02-07
123 reads
2026-02-06
114 reads
Expensive CPUs
Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.
2026-02-04
90 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