2026-03-30
49 reads
Editorials
Dancing Robot Goes Rogue
The headline says it all and Steve thinks this could be a problem in the digital world as well.
2026-03-28
50 reads
Is Your Time "Free"?
Too many people don't value their time appropriately, especially at work. If you don't, likely your boss doesn't either.
2026-03-27
66 reads
2026-03-25 (first published: 2018-05-21)
271 reads
Doing the Little Things
There are a lot of tasks that DBAs and developers struggle to get done. These little things can be important, and perhaps AI can help us keep on top of them.
2026-03-25
84 reads
A Double Failure
A company has both a server without a password and live data in test environments. Not a good situation.
2026-03-24 (first published: 2019-05-07)
401 reads
Everything is the right question away
When working with an AI LLM, you have so much knowledge at your fingertips.
2026-03-23
120 reads
2026-03-20
106 reads
Changing Data Types
Steve had to deal with a customer that changed data types in columns often. Is that something you experience?
2026-03-18
101 reads
Breaking Down Your Work
Self-assessment and self-examination can be important in many fields, especially technology in the age of AI.
2026-03-16
106 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