Server Roles and Azure Active Directory in an Azure SQL Database
This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login...
2017-11-29
620 reads
Checking SQL Configuration with Pester & Dbatools
I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing...
2017-12-13 (first published: 2017-11-29)
1,859 reads
Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2
Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is...
2017-11-29
738 reads
Introduction to Extended Events
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...
2017-11-29
954 reads
How to Help with dbatools Comment-based Help
I wrote a post over on the dbatools website about how to get involved with improving comment-based help
Working on the CBH is a great way to get started with...
2017-11-29
12 reads
AlwaysON Reporting Solution with SSRS
We will be going over the implementation of automatic failover setup for reporting services using availability groups. The report server databases...
2017-11-28
5,395 reads
PoshSSDTBuildDeploy Update – Now With Dynamic SqlCmdVar Updates
One of the big challenges in the whole “build once/deploy many” ideology is the need for environment configuration. And this...
2017-11-28
283 reads
Automating T-SQL Code Analysis
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,262 reads
I have a new Passion
Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...
2017-11-28
367 reads
My Favorite SSMS Shortcut (After Copy/Paste)
Photo by Abhishek Desai on UnsplashIf there’s one keyboard shortcut I use more than any other (with the exception of...
2017-11-28
248 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