Excellent article on securing msdb
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's why you should read it if you're a DBA or security professional.
2026-08-11
323 reads
Blog Posts
T-SQL Tuesday #201: Temp Tables
This month we have a new host, which I am grateful for. So many people have stopped blogging that it’s a challenge to keep this going. Jeff Taylor has...
2026-08-11
146 reads
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than simply creating one and using it. As I started digging into the topic, I realized...
2026-08-11
342 reads
Accept the no and move on
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin. When we are rejected, whatever the situation, many of us want to know why. We...
2026-08-10
311 reads
Adding an HTTP MCP Server to VSCode
I wrote earlier this week about the SQL MCP Server using the Data API Builder. In that post I showed how to query the MCP server from VSCode, but...
2026-08-10 (first published: 2026-07-29)
586 reads
Don’t Fight with AI
I was recently trying to handle a simple task with a few AI tools to see how well things worked. I realized that AI isn’t great for everything and...
2026-08-10
444 reads
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against a local Azure SQL Database Developer container — the same engine as the cloud, running...
2026-08-10 (first published: 2026-07-26)
809 reads
Car Update: August 2026
It’s been some time since I provided a car update, so I decided to showcase a few things I’ve learned about my cars since the last one. In this...
2026-08-07
174 reads
Microsoft announces new cybersecurity AI multi-model
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included in that announcement were high level details about MDASH with MAI-Cyber-1-Flash, which is reported to...
2026-08-07 (first published: 2026-07-28)
387 reads
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the diagnosis and it will usually stop at the first two subtasks that come to mind:...
2026-08-07
204 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Alamat Telp BCA KCP Sulawesi (+62) 838-4945-0961
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers