Methodology for dealing with bad data in production
Pinal Dave wrote up his methodology for what to do when you discover bad data in production. If you’ve never been in this situation, having a plan beforehand is...
2026-07-30
8 reads
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...
2026-07-30
10 reads
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview) to find cryptographic weaknesses in two algorithms. However, this doesn't impact anything anyone has in...
2026-07-29
15 reads
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out of the database, calls Amazon Bedrock, and writes the vectors back. That is a second...
2026-07-29
7 reads
Resolving SQL Server Transaction Log Issues Efficiently
Transaction log issues are one of the quietest ways a healthy database turns into an incident. A log file fills up, backups fall behind, and by the time anyone...
2026-07-29
14 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-07-29
38 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-07-28
40 reads
Getting the SQL Server MCP Server Running
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The SQL MCP Server is a part of the Data API Builder (DAB). DAB is a...
2026-07-27
68 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-07-26
36 reads
Rambling about Data on Wheels – origins, branding, expansion
I have been asked many times about how the name “Data on Wheels” came to be. I decided that is a good topic to ramble about, so here goes....
2026-07-25
42 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Kontak BCA KCP Semanggi Telp:08218154392
WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers