SQL Prompt Tips–Using $surroundtext$ in a Snippet
A user on the SQL Community Slack was asking about what the $surroundtext$ variable. This post looks at how this can be used in snippets. This is part of...
2023-11-29
97 reads
Blog Posts
Force parameterization is powerful-feature
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)
940 reads
Giving a Security Webinar this Wednesday
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern Standard Time, I’m presenting a webinar on how to harden SQL Server. Link to Register...
2023-11-27
26 reads
Part 1: The Modern Azure Data Warehouse – Choosing The Tech
With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and...
2023-11-27 (first published: 2023-11-16)
635 reads
VMUG Ireland End of Year Event
This Thursday, November 30th, is the next VMUG Ireland event…our end of year social meetup! We’re going to be down in BrewDog Dublin: – THREE LOCKS SQUARE, 4, DUBLIN...
2023-11-27
24 reads
Last Weeks Reading (2023-11-26)
📰 News Deploy a Delta Sharing Server on Azure Want to learn how to deploy a DeltaSharing server on Azure, but don’t know where to begin? Why Structured Streaming...
2023-11-26
46 reads
A New Word: Emodox
emodox – someone whose mood is perpetually out of sync with everyone else around them, prone to feelings of naptime panic, heart-to-heart snark, or dance club pensiveness. I had...
2023-11-24
67 reads
Creating a Self Referencing FK in a CREATE Statement–#SQLNewBlogger
I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this...
2023-11-24 (first published: 2023-11-06)
274 reads
Memories of the PASS Data Community Summit 2023
I’ve been to a lot of conferences, and one that I’ve probably attended the most is the annual PASS Data Community Summit. It’s been listed under various names, but...
2023-11-24
116 reads
Query Store Reports Time Intervals
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)
283 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers