ASF 024: Leila Etaati interview
Introduction Leila Etaati is an AI MVP, mentor, trainer, speaker and consultant. She spoke in some important conference such as Microsoft USA Ignite, Microsoft Data Insight Summit, SQL PASS,...
2019-07-26
30 reads
The Data Request
Spotify implemented a way to get your data from your profile. This looks at the request and initial data download. The Request When you go there, you see a...
2019-07-26
32 reads
Finding the Best Azure Datacenter
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x...
2019-07-26
306 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 3
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
13 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 3
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
33 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 3
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
139 reads
Azure SQL Database Connect and Query
There is a lightweight and quick way to start querying your database in Azure which doesn’t involve SQL Operations Studio or Management Studio. You can use the query editor...
2019-07-25
23 reads
Intent Locks In SQL Server
Intent locks, one of those things in SQL Server that seem to be very often misunderstood. They’re something that I’ve found myself explaining time and time again, I’ve even...
2019-07-25
666 reads
Why We Don’t Truncate Dimensions and Facts During a Data Load
Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While...
2019-07-25
812 reads
How do we test ETL pipelines? Part one unit tests
Why do we bother testing? Testing isn’t an easy thing to define, we all know we should do it, when something goes wrong in production people shout and ask...
2019-07-25
8 reads
Blogs
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...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
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