The Selfish Case for Learning AI
Steve has a good reason to spend time working with and learning about AI technology.
2025-10-31
151 reads
Artificial Intelligence (AI)
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 […]
2025-10-04
258 reads
Natural Language Query for SQL Server
Data is usually the most important asset in organizations, but only SQL developers can frequently access that data. Technical teams often write queries for non-technical users. This restricts agility, slows decision-making, and creates a bottleneck in data accessibility. One possible remedy is natural language processing (NLP), which enables users to ask questions in simple English and receive answers without knowing any code. Still, the majority of NLP-to-SQL solutions are cloud-based, which raises issues with cost and privacy.
2025-10-03
2025-09-29
241 reads
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
2025-09-27
121 reads
Getting More Time from AI
Today Steve wonders what you might do with extra time if the AI can give it to you.
2025-09-24
100 reads
AI Steals Joy
Are the AI tools developers use making them enjoy their jobs more or less? Steve has a few thoughts.
2025-09-15
1,165 reads
2025-09-06
166 reads
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 […]
2025-08-16
893 reads
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 […]
2025-08-09
135 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers