Reblog: November 8 to November 14
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-15
761 reads
Blog Posts
SQL Server Diagnostic Information Queries for November 2013
I have made a number updates and bug fixes, including some additional columns in some of the queries for all...
2013-11-15
1,171 reads
SSRS Map Layers Parameter
With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If...
2013-11-15 (first published: 2013-11-11)
1,514 reads
The Failed Job
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,674 reads
Use application lock to synchronize T-SQL code
Application lock can be used to synchronize T-SQL code, you can control if the session is able to run the...
2013-11-15
5,087 reads
Automated Permissions Auditing With Powershell and T-SQL: Part 3
In this episode, I’m going to start introducing some of the Powershell elements that tie this audit process together.
DISCLAIMER: I...
2013-11-14
3,544 reads
Baseline Maintenance Statistics Job For Indexes. (say that three times fast)
This is a project I've been working on for a while. The information is all there... how it's queried may...
2013-11-14
514 reads
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
927 reads
Free Online SQL Server Training for the Week of November 17, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-14
463 reads
Free Online SQL Server Training for the Week of November 17, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-14
2,232 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
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers