SQL Server Error 9002 – Full Transaction Log
A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else...
2025-01-15
43 reads
Blog Posts
Using Flyway Prepare for State-Based Deployments
One of the neat enhancements made to Flyway was the addition of state-based workflows and tooling. A lot of people have loved SQL Compare or SQL Source Control for...
2025-01-15 (first published: 2025-01-08)
1,715 reads
SQL Saturday Oregon & SW Washington 2024
Wow I am so late in posting these notes! But this conference was amazing, so figured still good to post my notes from the incredible sessions I attended! Hope...
2025-01-14
26 reads
T-SQL Tuesday #182: Personal Integrity
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from the first non-founder to host a party, Rob Farley. I reached out to Rob and...
2025-01-14
37 reads
Grinding Away: Mary Spender
A few years ago I stumbled on this video and loved it. That led me to Mary’s page and this cover of John Mayer’s Stop This Train: Since then...
2025-01-13
17 reads
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because...
2025-01-13 (first published: 2025-01-07)
1,938 reads
How to clear the SSMS cache?
How to clear the SSMS cache?
If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for...
2025-01-13 (first published: 2025-01-10)
2,614 reads
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-01-13 (first published: 2025-01-12)
131 reads
A New Word: Querinous
querinous – adj. longing for a sense of certainty in a relationship; wishing there were some way to know ahead of time whether this is the person you’re going...
2025-01-10
123 reads
BK’s Bookshelf: Never Split the Difference
I picked up Never Split the Difference: Negotiating As If Your Life Depended On It by Chris Voss, a former FBI negotiator. Given what I do, I realized that...
2025-01-10 (first published: 2025-01-01)
442 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