I’m back! I’m still a Microsoft Data Platform MVP. And other minor life updates.
I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading
2023-07-27
29 reads
SQLStudies
SQL Agent job history on a Managed Instance
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them ... Continue reading
2023-08-09 (first published: 2023-07-25)
257 reads
db_ddladmin Jr.
A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema ... Continue reading
2023-07-20
53 reads
How do I tell if a user is orphaned or actually created without a login?
One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what ... Continue reading
2023-08-02 (first published: 2023-07-18)
656 reads
The two hardest concepts of security are Who? and Where?
I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security ... Continue reading
2023-07-28 (first published: 2023-07-13)
300 reads
Code that made you feel a certain way : T-SQL Tuesday #164
It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever ... Continue reading
2023-07-26 (first published: 2023-07-11)
348 reads
End of year planning: T-SQL Tuesday #157
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the ... Continue reading
2022-12-15 (first published: 2022-12-13)
47 reads
#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading
2022-12-08
145 reads
What’s next: Job search burnout
I was given 4.5 months notice this past June and was fortunate to find a new job. I blogged about ... Continue reading
2022-12-06
18 reads
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
446 reads
Blogs
Speaking at the TechnoSecurity and Digital Forensics East Conference
By Brian Kelley
The Techno Security & Digital Forensics Conference (East) runs from June 3-5, 2025, this...
Techorama 2025 – Slides
You can find the slides for my session Building the €100 data warehouse with...
Query Hints and Estimated Plans
I’m working on an update to my Query Performance Tuning book for SQL Server...
Forums
SQL Cookbook: Query Solutions and Techniques for All SQL Users
Comments posted to this topic are about the item SQL Cookbook: Query Solutions and...
SQL Server 2022 Query Performance Tuning
Comments posted to this topic are about the item SQL Server 2022 Query Performance...
Architecting Power BI Solutions in Microsoft Fabric
Comments posted to this topic are about the item Architecting Power BI Solutions in...
Question of the Day
CONCAT_WS
What output do the queries produce?
SET CONCAT_NULL_YIELDS_NULL ON; SELECT CONCAT_WS ('-', NULL, NULL); SET CONCAT_NULL_YIELDS_NULL OFF; SELECT CONCAT_WS ('-', NULL, NULL);See possible answers