Power BI Interview Questions – Volume 03 – DAX
Welcome to our continuing series that Erin Ostrowsky [Blog | Twitter] and I spend focusing on interviewing for a Power BI position. This series will
2019-07-30 (first published: 2019-07-09)
723 reads
New Security Update for SQL Server in July 2019 Patches
It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...
2019-07-17 (first published: 2019-07-09)
1,745 reads
T-SQL Tuesday #116–Always Linux
This month is an interesting invitation from Tracy Boggiano. It’s on Linux, which I like. I hadn’t thought about this in terms of T-SQL Tuesday, but I think it...
2019-07-29 (first published: 2019-07-09)
187 reads
Create New Azure VM with PowerShell
Every so often I set out to create new resources in my Azure subscription using the command line tools (PowerShell or CLI) just to keep up to date on...
2019-07-25 (first published: 2019-07-09)
489 reads
SELECT Expression Execution Order
Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...
2019-07-23 (first published: 2019-07-09)
813 reads
SELECT Expression Execution Order
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
12 reads
SELECT Expression Execution Order
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
8 reads
Low Tech Repeating Tasks in Trello
I mentioned in earlier posts that I’m using Trello this year for managing SQLSaturday tasks and figured I might as well go all in and add some of the...
2019-07-26 (first published: 2019-07-09)
296 reads
OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2
Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of extended support with Microsoft today! 9th July...
2019-07-24 (first published: 2019-07-09)
718 reads
Learning More about Kubernetes (K8s)
I know a bit about this, but I’m always looking for more. I had the chance to see Brendon Burns recently and I was impressed. That is one seriously...
2019-07-25 (first published: 2019-07-08)
720 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