Restore AWS RDS Databases On-Premises
Did you know that you can restore AWS RDS databases to a SQL Server 2022 instance running locally using native backup and restore? Well you can. Let’s talk about...
2023-03-13
44 reads
Daily Coping 10 Mar 2023
Today’s coping tip is to notice three things you find beautiful in the outside world. I haven’t been outside a lot lately. It’s been cold and I’ve been busy...
2023-03-10
26 reads
The Microsoft Ability Summit in Review
As many of you are aware, I have been dealing with a progressive version of ALS which is affecting my hands and arms and thus my ability to type....
2023-03-20 (first published: 2023-03-09)
116 reads
Using a data lakehouse
As I mentioned in my Data Mesh, Data Fabric, Data Lakehouse presentation, the data lakehouse architecture, where you use a data lake with delta lake as a software layer...
2023-03-09
35 reads
Daily Coping 9 Mar 2023
Today’s coping tip is set an intention to live with awareness and kindness. One of the best things about these coping tips is that I have learned to be...
2023-03-09
23 reads
Intelligent Query Processing (IQP)
In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by...
2023-03-20 (first published: 2023-03-09)
734 reads
T-SQL Tuesday #159– Resolutions
I missed T-SQL Tuesday last month. I got busy and distracted with some travel. For #159, Deepthi Goguri hosted. I’ve enjoyed watching her blog and grow her knowledge the...
2023-03-08
78 reads
Daily Coping 8 Mar 2023
Today’s coping tip is ask someone how their day is going and really listen to them. I had the chance to do this with one of the kids I...
2023-03-08
20 reads
Daily Coping 7 Mar 2023
Today’s coping tip is give positive comments to as many people as possible today. On a travel day, I made an effort here. Those are always better for me,...
2023-03-07
22 reads
SQLpassion Live Training about SQL Server Query Tuning Fundamentals
On April 4, 2023 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when...
2023-03-17 (first published: 2023-03-07)
329 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries