Schema evolution solved using Delta Lake & Databricks
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
16 reads
Schema evolution solved using Delta Lake & Databricks
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
116 reads
Schema evolution solved using Delta Lake & Databricks
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-31 (first published: 2019-12-15)
1,372 reads
SSMS Tip: Management Studio Script Projects
Did you know that SQL Server Management Studio can help you arrange your SQL scripts into logical groupings? SSMS includes the ability to associate multiple code files together into...
2019-12-14
48 reads
Understanding Azure Geo-Redundant Storage
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-13
26 reads
Understanding Azure Geo-Redundant Storage
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-27 (first published: 2019-12-13)
313 reads
Prompt in ADS
Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...
2020-01-02 (first published: 2019-12-13)
252 reads
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...
2019-12-13
8 reads
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...
2020-01-06 (first published: 2019-12-13)
570 reads
SSMS Tip: Vertical Text Selection
Occasionally, I’ll stumble across one of those neat tricks that makes me ask myself, “Why didn’t I know about this years ago?”. This next tip was one such discovery,...
2019-12-13
60 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
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