A great question came up over at DBA.StackExchange regarding the query store reports time intervals: How can SQL Server’s Query Store Reports show data for minute-length intervals, when “Statistics...
2023-11-24 (first published: 2023-11-13)
273 reads
I’m up in Seattle this week for the PASS Data Community Summit 2023. This is almost an annual event for me. I’ve missed a few since 1999, but not...
2023-11-13
16 reads
Earlier this year I presented at PyCon 2023 in Salt Lake City, UT on the topic of "Efficient Cross-Server Data Joins on Slow Networks with Python". You can watch...
2023-11-13
23 reads
Earlier this year I presented at PyCon 2023 in Salt Lake City, UT on the topic of "Efficient Cross-Server Data Joins on Slow Networks with Python". You can watch...
2023-11-22 (first published: 2023-11-13)
175 reads
Force parameterization in Microsoft SQL Server is a feature designed to optimize query performance by converting literal values in Transact-SQL statements into parameters. This process helps in plan reuse,...
2023-11-27 (first published: 2023-11-13)
893 reads
As PASS Summit approaches this week, I’m re-reviewing my evaluations from SQL Saturday Boston and I’d like to give feedback about feedback.
Why Feedback? Both speakers and event organizers depend...
2023-11-12
15 reads
There was an update to Flyway Desktop which lets you see the type of database your project is associated with, and this post shows how to get this in...
2023-11-10
105 reads
heartspur – n. an unexpected surge of emotion in response to a seemingly innocuous trigger – the distinctive squeal of a rusty fence, a key change in an old...
2023-11-10
22 reads
Appreciate everyone who has reached out asking if I would be attending the PASS Data Summit out in Seattle this year. Yes, I will be, and I am looking...
2023-11-10
55 reads
A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...
2023-11-10
30 reads
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Comments posted to this topic are about the item Finding Bad Queries