Editorials

SQLServerCentral Editorial

People Make Odd Choices

One of my favorite things about going to in-person events is just the time when we're sitting around chatting, out in the hallway, over at the vendor booths, maybe in the speaker room. Any of them. Inevitably, you start to get what I would call "sea stories" (Navy & Coasties, "war stories" for the pickles, […]

5 (1)

You rated this post out of 5. Change rating

2025-07-14

146 reads

SQLServerCentral Editorial

Navigating Multi Platform Realities in My Database Life

Working across Oracle, SQL Server, PostgreSQL, and MySQL, I've learned that the real challenge isn’t just knowing each platform, but understanding the subtle differences in terminology, syntax, and mindset, and staying open to learning on the fly every time I jump in.  The “Sacred Six” are rules that I’ve learned to live by and accept. […]

5 (1)

You rated this post out of 5. Change rating

2025-07-12

76 reads

SQLServerCentral Editorial

Formatting Dates and Times: The SQL Dialect Divide

If you’ve ever had to format dates and times in SQL, you’ve probably come across one of the most jarring realities of working across platforms: every major RDBMS does it differently and sometimes confusingly.  What’s a TO_CHAR() in Oracle becomes FORMAT() or CONVERT() in SQL Server, and its sort of the same in PostgreSQL… but […]

4.67 (3)

You rated this post out of 5. Change rating

2025-07-11

164 reads

SQLServerCentral Editorial

In Praise of Simplicity or The Power of Plain Language in a Buzzword World

There’s a moment I experience all too often in tech meetings, presentations, or vendor demos where someone starts talking, and instead of clarity, I get hit with a tidal wave of jargon: “synergizing AI-driven orchestration pipelines for real-time actionable insights using cloud-native microservices and agentic AI to serve as a digital twin.” And somewhere in […]

5 (4)

You rated this post out of 5. Change rating

2025-07-09

125 reads

SQLServerCentral Editorial

The Mindset of a Database Administrator: A Love Letter to Risk Aversion

Sometimes, while working on something as foundational as SQL Server Central, (which is a temporary responsibility for Grant, John and I while Steve is on sabbatical) I catch myself falling into an old, familiar loop double-checking my choices, second-guessing even the most minor decisions, as is the norm for anyone who’s a database administrator (or […]

5 (5)

You rated this post out of 5. Change rating

2025-07-08

158 reads

SQLServerCentral Editorial

The Long Weekend

In the US, this is the Independence Day weekend. I had a few spare vacation days, so I tacked one on, making this a four day weekend. My plans are simple. Prep for my family coming over on the 5th for a celebration of the 4th (Ha!). Work on my query tuning book (gotta make […]

5 (1)

You rated this post out of 5. Change rating

2025-07-05

68 reads

SQLServerCentral Editorial

Own Your Mistakes

Hello, Grant again as Steve is on sabbatical. My evenings and weekends are currently being used to update my SQL Server query performance book for 2025. I really enjoy it because writing the book forces me to structure my learning on SQL Server 2025, not just hit it in some slipshod manner. Plus, I've got […]

5 (3)

You rated this post out of 5. Change rating

2025-07-04

80 reads

SQLServerCentral Editorial

Filling Big Shoes

Hey all! It's me, Grant. For those who don't me, Grant Fritchey. I work with Steve Jones, the person normally talking to you here. Yes, Redgate actually employs me, and continues to. I don't know why either. Anyway, Steve is off for a few weeks on his sabbatical. More power to him and I hope […]

5 (3)

You rated this post out of 5. Change rating

2025-07-02

106 reads

Blogs

By

 Truncate Table Pitfalls: What Pros Watch Out For Truncating a table can be gloriously fast—and...

“SQL Server Is Slow” Part 4 of 4

By

Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...

How to Install DBeaver and Connect to a PostgreSQL Instance

By

Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...

Read the latest Blogs

Forums

Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Vector Datatype Dimensions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Vector Datatype Dimensions

SQL Server DBA - Immediate need

By kblue

Immediate need for a hands-on SQL Server DBA. This is a greenfield opportunity to...

Visit the forum

Question of the Day

Vector Datatype Dimensions

The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?

See possible answers