Keynotes in Australia and New Zealand
I get to do the SQL in the City Summit keynotes in Australia and New Zealand. I’m excited, following the footsteps of Kendra Little and Donovan Brown, who have...
2019-05-21
21 reads
Event Log File Paths
How does one consistently find the correct path to the Extended Event Log file (XEL file)? This article shows a thorough method to capture that information for all sessions...
2019-05-20
11 reads
Event Log File Paths
How does one consistently find the correct path to the Extended Event Log file (XEL file)? This article shows a thorough method to capture that information for all sessions...
2019-05-20
16 reads
Event Log File Paths
How does one consistently find the correct path to the Extended Event Log file (XEL file)? This article shows a thorough method to capture that information for all sessions...
2019-05-20
237 reads
Clearing an Email from the Microsoft Directory
Years ago I was working on a demo with Microsoft and someone added me to their VSTS (now Azure DevOps) project. Somehow, I got an account in the Live/Passport/Joe-Schmo...
2019-05-20
25 reads
Learning Containers
I find that I’m using containers more and more to get things done with SQL Server. They’re so easy to set up for testing, spin ’em up, do stuff,...
2019-05-20
78 reads
Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading
2019-06-06 (first published: 2019-05-20)
994 reads
Inspector V1.4 now available
The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project...
2019-05-20
29 reads
Quick Tip – How to fix SQL Server 2017 install error on Ubuntu 18.04: E: Could not get lock /var/lib/dpkg/lock-frontend – open (11: Resource temporarily unavailable)
Problem Recently, when I tried to install SQL Server 2017 (mssql-server package) in Ubuntu 18.04, I encountered the error below: The command that I used to install the mssql-server...
2019-05-20
7 reads
Quick Tip – How to fix SQL Server 2017 install error on Ubuntu 18.04: E: Could not get lock /var/lib/dpkg/lock-frontend – open (11: Resource temporarily unavailable)
Problem Recently, when I tried to install SQL Server 2017 (mssql-server package) in Ubuntu 18.04, I encountered the error below: The command that I used to install the mssql-server...
2019-06-06 (first published: 2019-05-20)
304 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers