dbakevlar@gmail.com


SQLServerCentral Editorial

How Microsoft Fabric Is Reshaping Data Value

The data professional’s world is changing and I know you hear this from me in editorials, blogs posts and social media, but it’s the truth. With the rise of Microsoft Fabric, we’re not just seeing another platform shift; we’re witnessing a redefinition of how data is valued, governed, and protected across the enterprise. Fabric isn’t […]

You rated this post out of 5. Change rating

2025-07-22

243 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

84 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

214 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

134 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

174 reads

SQLServerCentral Editorial

Shades and Reflecting on SQLBits and the Bright Future of Data

There is something magical about SQLBits. Whether it is the technical sessions, the sense of community and fun, or the relentless commitment to learning about the latest innovation, this event continues to serve as a pulse check for where data is today and where it’s going tomorrow. This year’s SQLBits at the ExCel in London […]

You rated this post out of 5. Change rating

2025-06-21

53 reads

SQLServerCentral Editorial

Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere

As someone who has had the honor of delivering keynotes at both Oracle and SQL Saturday data events, I’ve spent time with professionals on both sides of the database world.  I’ve held the title of database administrator, developer, engineer and architect for structured, transactional giants and the analytics-heavy ecosystems of eight different database platforms, (not […]

(1)

You rated this post out of 5. Change rating

2025-05-17

97 reads

Blogs

RANK() vs DENSE_RANK(): #SQLNewBlogger

By

I haven’t done one of these in awhile, but I saw an article recently...

Using CAT for Testing of Data Agents

By

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By

Do you spend so long manipulating your data into something vaguely useful that you...

Read the latest Blogs

Forums

Fun with JSON

By ateraa

Comments posted to this topic are about the item Fun with JSON

Creating JSON II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON II

Engineer Lessons

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Engineer Lessons

Visit the forum

Question of the Day

Creating JSON II

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO

See possible answers