The Self Referencing CTE

The Minimum Upgrade Point

Today Steve wonders to which version you would upgrade your SQL Server instances. There should be a minimum version you would try to reach.

T-SQL Tuesday #164: Code that makes you feel

The invitation this month is from Erik Darling, and it’s a neat one. I like this thought, asking us to find code that impressed us or made us feel...

Which Data Comes First?

A Security Change with SQL Compare 15

Actually, this is a change for many products and software that connects to SQL Server. Updated drivers require us to now decide to trust the server certificate. I opened...

Early Bird Pricing for the Data Community Summit Ends Jul 26

The early bird pricing for the PASS Data Community Summit ends this week, on Jul 26. After that, there is a bump, so let you boss know this is...

The Left Joins

The Choice of SQL Server Version

Brent Ozar has his quarterly report on SQL Server versions and SQL Server 2022 isn't being used as much. Does that make sense to you? What versions are you installing?

A New Word: Ozurie

Ozurie – feeling torn between the life you want and the life you have. I think many people feel ozurie often. I certainly had a lot of this in...

Creative Development

An interesting approach to schema changes is a creative solution to Steve. He asks if you have other creative solutions you've seen.