Dipping into the Cookie Jar: T-SQL Tuesday #112
This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies....
2019-03-12
257 reads
Blog Posts
Fix For Using Azure Active Directory to Connect to SQL
Hello! The other day someone was kind enough to get in touch with me to thank me for some post I wrote back last year. For the sake of...
2019-03-12
23 reads
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
33 reads
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
3 reads
Gaps and Islands Across Date Ranges
Watch this week’s episode on YouTube.In a traditional gaps and islands problem, the goal is to identify groups of continuous...
2019-03-12
7,077 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion. Azure Data...
2019-03-12
19 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion. Azure Data...
2019-03-12
13 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion. Azure Data...
2019-03-12
10 reads
How to Submit Feedback to Azure Data Studio WITHOUT tweeting.
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data...
2019-03-12
412 reads
Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
387 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