This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
102 reads
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
14 reads
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
158 reads
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-07-17
12 reads
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-08-09 (first published: 2019-07-17)
284 reads
This is the first in a series of posts about gatekeeping in Information Technology and other fields. I am not the first — nor will I be the last...
2019-07-17
54 reads
Requirement: Remove a node from one of...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-17
126 reads
At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure Databricks (ADB) and the Traditional DBA. I had heard a bit about Databricks, and read...
2019-07-17
59 reads
My last two blogs were on understanding columnstore and creating columnstore indexes. In this post, I will touch on one last topic, when to use columnstore indexes. As noted...
2019-08-05 (first published: 2019-07-17)
651 reads
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading
2019-08-07 (first published: 2019-07-17)
662 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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