WIT Panel for Women’s History Month
I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...
2019-03-11
225 reads
Blog Posts
Favorite community scripts and their parameters
Here’s some of my favorite community scripts and how I like to run them. If you haven’t tried the optional...
2019-03-09
691 reads
Speaking
A place to collect abstracts & links to presentations I’ve given. Please be sure to check out my Sessionize profile as well.
Backup Basics with PowerShell and dbatools Abstract As...
2019-03-09
6 reads
Adding Objects to our SCA Project
In my last post, I started out with a new SCA project, getting a connection to my database up and...
2019-03-08 (first published: 2019-02-13)
2,686 reads
I’ve added data classifications. Now what?
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...
2019-03-08 (first published: 2019-02-20)
2,547 reads
Pausing the Learning for March
In my last update, I was disappointed with my February progress. Busy with life and work, I didn’t do much...
2019-03-08
866 reads
VMware vExpert for 2019
I’m honored and humbled to be awarded the VMware vExpert award for the seventh year in a row! Thank you...
2019-03-08
307 reads
Writing my presentation 2: Designing the presentation
This series is about my process for writing my upcoming presentation at SQL Saturday Chicago #825.
Today’s goals
Today I’m going to...
2019-03-08
343 reads
Can you speak at my User Group or Conference? No? Sweet As – can you help people register please?
This blog post is not going to be a technical one…. but it’s about technology – well more accurately about bringing...
2019-03-07
299 reads
Creating custom SQL Server Helm charts
In my previous post I went through how to deploy SQL Server to Kubernetes using Helm in which I used...
2019-03-07 (first published: 2019-02-20)
3,032 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