Undercover Catalogue 0.2.2 It looks like a bug has crept it’s way into the Undercover Catalogue. When running with certain versions of DBA Tools, a number of the modules...
2019-06-20
24 reads
One of my favorite events, in a wonderful place to spend the weekend. I’ve been to Pensacola a few times (3?), including a couple times with my daughter. It’s...
2019-06-20
42 reads
An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...
2019-06-20
19 reads
An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...
2019-07-04 (first published: 2019-06-20)
460 reads
Announced at DataGrillen 2019 today, the amazing dbatools PowerShell module has officially released version 1.0. This is a tremendous milestone for the best Open Source project built for data...
2019-06-20
13 reads
Announced at DataGrillen 2019 today, the amazing dbatools PowerShell module has officially released version 1.0. This is a tremendous milestone for the best Open Source project built for data...
2019-06-20
17 reads
If you want to run SSIS packages in Azure Data Factory, you need the Azure SSIS Integration Runtime (quite the mouthful), which is basically a cluster of virtual machines...
2019-07-09 (first published: 2019-06-19)
361 reads
Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. |???????|| CONTAINERS || ARE NOT...
2019-06-19
136 reads
When you run a query twice, and get dramatically different run times, your first step can be to try to identify the differences in execution plans. For many that...
2019-07-05 (first published: 2019-06-19)
935 reads
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting ... Continue reading
2019-06-19
108 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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