Getting Started with the MSSQL AI Agent in VS Code
Recently I was working in VS Code and I saw a walkthrough for the new Copilot chat features. I decided to give those a try in trying to get...
2025-09-08
534 reads
Blog Posts
Summer Speaking Summary 2025
In the blink of an eye, summer has passed. I don’t know about you, but I’m ready for things to get back to “normal” after 10 weeks of events...
2025-09-08
24 reads
Why DBAs Still Need to Know the Foundations of SQL Server
Over the years, I’ll admit, SQL Server has come a long way in making life easier for database administrators and with each version it keeps getting better and better....
2025-09-08 (first published: 2025-08-19)
510 reads
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...
2025-09-06
240 reads
Advice I Like: Praise
Don’t reserve your kindest praise for a person until their eulogy. Tell them while they are alive when it makes a difference to them. Write it in a letter...
2025-09-05
865 reads
Cosmos DB vs Traditional SQL: When to Choose What
From where I stand, the decision between Cosmos DB and a traditional SQL database often wants to be chosen between a sports car and a reliable sedan. Both will...
2025-09-05 (first published: 2025-08-18)
688 reads
Power BI dataflow Gen1 needs Gateway to connect to Azure SQL DB
I’m in the progress of migrating some legacy stuff at a client, and in their Power BI environment there are still quite some Power BI dataflows Gen1. I had...
2025-09-05 (first published: 2025-08-20)
375 reads
Adding a Named Default Constraint to a Table: #SQLNewBlogger
As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a...
2025-09-03 (first published: 2025-08-11)
480 reads
Azure IoT Operations
I want to talk about a fairly new product that you may not be aware of: Azure IoT Operations, which GA’d last November (it was first announced at Ignite...
2025-09-03 (first published: 2025-08-19)
789 reads
Using Python Code in SSIS
SQL Server Integration Services (SSIS) is a mature, proven tool for ETL orchestration and data movement. In recent years, Python has exploded in popularity as a data movement and...
2025-09-01 (first published: 2025-08-11)
414 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers