Editorials

SQLServerCentral Editorial

Databases and Disasters

I was just reading about how the Philippines are working to update their databases in support of faster and better responses in the case of an emergency. While I do volunteer for some of the local emergency services, I'm right at the bottom of the heap as just a radio operator. I don't have any […]

(2)

You rated this post out of 5. Change rating

2025-07-18

118 reads

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, […]

(1)

You rated this post out of 5. Change rating

2025-07-14

161 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. […]

(1)

You rated this post out of 5. Change rating

2025-07-12

92 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 […]

(3)

You rated this post out of 5. Change rating

2025-07-11

219 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 […]

(4)

You rated this post out of 5. Change rating

2025-07-09

136 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)

You rated this post out of 5. Change rating

2025-07-08

179 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 […]

(1)

You rated this post out of 5. Change rating

2025-07-05

84 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 […]

(3)

You rated this post out of 5. Change rating

2025-07-04

93 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 […]

(3)

You rated this post out of 5. Change rating

2025-07-02

115 reads

Blogs

Claude Desktop

By

Claude is more than a chat window. The desktop experience includes structured workspaces, generated...

PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate

By

A sequential scan is not always a problem — PostgreSQL's planner often chooses one...

Giving AI Agents Visibility Into SQL Server with MCP

By

I’ve been thinking a lot lately about what it actually takes to make an...

Read the latest Blogs

Forums

Running script without having permission to Function

By Reh23

Good Morning. I have a T-SQL Script which has been developed to execute a...

Stop Prompting Your AI Agent. Give It a Playbook.

By Kumar Abhishek

Comments posted to this topic are about the item Stop Prompting Your AI Agent....

Finish the quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finish the quote

Visit the forum

Question of the Day

Finish the quote

Finish this quote (for a fun Memorial Day question):

Do not try and bend the spoon. That's impossible. ...

See possible answers