dbakevlar@gmail.com


SQLServerCentral Editorial

Lessons from the Postmark-MCP Backdoor

The Koi Security team recently uncovered the first known, malicious MCP server in the wild: a package called postmark-mcp, downloaded over 1,500 times per week, that silently BCCs every outgoing email to an attacker-controlled domain. So, what happened?  High-level, a lot: The attacker cloned the legitimate Postmark MCP repository, made one small but nefarious change […]

You rated this post out of 5. Change rating

2025-10-04

141 reads

SQLServerCentral Editorial

Building AI Governance and Policies- First Steps

AI has moved from experimental to operational in record time for many organizations. In industries like fintech, healthcare, and retail where sensitive PII (personally identifiable information) and relational databases are the backbone of daily operations, this innovation speed to adopt AI brings enormous opportunity, but also significant risks

You rated this post out of 5. Change rating

2025-09-27

57 reads

SQLServerCentral Editorial

Why Tech Events Matter for Data Pros (and why I’m grateful)

I just got back from the Redgate Summit events in New York City, where I had the chance to present, swap stories, and nerd out with a lot of brilliant data folks. I came home energized… and then promptly slept for 14 hours on Thursday. That’s the best kind of exhaustion in my book.  The […]

5 (1)

You rated this post out of 5. Change rating

2025-08-23

47 reads

SQLServerCentral Editorial

Using Ollama on Windows 11 as an Alternative to Public LLMs

In my ongoing war against shadow AI, I’ve been testing out alternatives that most everyone can use, no matter what your technical expertise.  Although somewhat limited depending on your resources available, (laptop CPU/GPU, memory, etc.) If you want to try the newest open models without sending your prompts to the cloud, or you just want […]

You rated this post out of 5. Change rating

2025-08-16

169 reads

SQLServerCentral Editorial

Everyone Wants a Piece of the AI Pie

Swiping through LinkedIn feels like watching a campsite suddenly flooded with s’mores. Every other ad, i.e. post, promises the next miracle AI service, platform, or “AI-powered” widget. It’s a frenzy that says: “If buzzwords paid the bills, we’d all be billionaires already.”  I can’t fault the reasoning, there’s a lot of buzz out there telling […]

5 (1)

You rated this post out of 5. Change rating

2025-08-09

97 reads

SQLServerCentral Editorial

Critical Data and Insomnia

Most evenings I spend some time soaking in the tub and reading articles/watching videos on InfoSec, Data Protection and AI.  It may sound like a terrible way to spend some time, but I always find it educational and I’m in shock by the lack of concern around data security, and yet….I’m not.  For decades, the […]

5 (2)

You rated this post out of 5. Change rating

2025-08-07

121 reads

SQLServerCentral Editorial

The Double-Edged Sword of AI and Data Democratization

Agentic AI is often hailed as a game-changer by organizations, bringing autonomous decision-making, intelligent automation, and powerful predictive capabilities. However, as organizations rush to leverage these technologies, those dealing with critical data in relational databases, documents and datasets, especially personally identifiable information (PII) face a harsh reality: moving AI projects from proof-of-concept to production is […]

You rated this post out of 5. Change rating

2025-08-06

146 reads

Blogs

SQL Server Alerts

By

Don’t Let Trouble Sneak Up on You   Most SQL Servers run quietly. Until...

Prompt AI helping with Auditing

By

I had a conversation with a customer asking this question: how can I tell...

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

By

There was a time when the Chief Data Officer lived in the shadows of...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Collation errors...what is best way to deal with it?

By water490

Hi I have a SP that occasionally get this error: Cannot resolve the collation...

Was the index created or not?

By water490

Hi everyone I am getting an error when I create the index but I...

Visit the forum

Question of the Day

Estimated Rows

I have two calls to the GENERATE_SERIES TVF in this code:

SELECT   TOP 10 gs.value
FROM     GENERATE_SERIES(1, 10) AS gs
ORDER BY NEWID ()
OPTION (RECOMPILE);
go
DECLARE @a int = 10;
SELECT   TOP (@a) gs.value
FROM     GENERATE_SERIES(1, @a) AS gs
ORDER BY NEWID ()
OPTION (RECOMPILE);
In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022?

See possible answers