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

238 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

82 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

210 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

130 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

52 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

94 reads

SQLServerCentral Editorial

Two Events, Two Worlds: A Week in the Life of a Technologist

Last week, I had the chance to speak at two very different events, and the contrast between them really stuck with me. The first was all a traditional vendor conference-  enterprise-level, built around a well-established product with over 40 years of vendor-driven development. Think polished sponsor tables, polished shoes, and more than a few suits […]

(1)

You rated this post out of 5. Change rating

2025-04-12

67 reads

Blogs

Learn Better: Pause to Review More

By

If you want to learn better, pause more in your learning to intentionally review.

Azure SQL Managed Instance Next-Gen: Bring on the IOPS

By

If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...

SQL, MDX, DAX – the languages of data

By

Ramblings of a retired data architect Let me start by saying that I have...

Read the latest Blogs

Forums

Two foreign keys to the same table. Can't cascade deletes.

By FunkyDexter

Not sure if this is really a relational theory question but it seems about...

Connecting Power BI to SSAS and effective user not working

By Paul Hernández

Hi everyone, Below is a consolidated summary of what we validated Architecture & data...

High Availability setup - has anyone seen this method?

By Paul Lancaster

Hi all, I recently moved to a new employer who have their HA setup...

Visit the forum

Question of the Day

Encoding URLs

I have this data in a SQL Server 2025 table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO
If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?

See possible answers