When DBAs Should Consider Using SQL Server to Store Vector Data and If It Makes Sense

As we continue to build more applications using AI embedded solutions, database professionals are increasingly being asked to support workloads that would have seemed outside their charter just a few years ago. One of the most significant shifts has been the rise of vector data (i.e. high-dimensional numerical representations of content like text, images, and […]

Capacity Planning for an Existing SQL Server Workload?

Why Podcasts Matter for the Technical Professional

In a world of always-on learning and the relentless march of tech evolution, podcasts emerged as a quiet revolution in how I consume information.  I’ve been part of several podcasts this year, including recording one earlier today with Ed Roske for the Oracle community. As a data professional and technical specialist, for me they’re more […]

TCP Provider Errors in SQL Server

Transactional DDL in SQL Server: In Oracle, It Does Not Compute

Oracle treats most DDL as auto-committing, meaning once it executes, it's done. SQL Server, however, blurs that line in fascinating ways, allowing some DDL operations to be part of an explicit transaction.

Always On AG Latency for Read-Only Workload After Failover?

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

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

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

Query Plan Regressions --