Last Week Reading (2019-09-08)
Hello all and welcome after my one month of my absence. What was I doing? Thank you for asking! I have been on holiday. ONE month of very relaxing,...
2019-09-08
31 reads
Kamil
- Website: https://sqlplayer.net
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
Last Week Reading (2019-07-21)
Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first...
2019-07-22
22 reads
ASF 024 video invitation
I’m happy to announce that the next episode of “Ask SQL Family” podcast is coming. This time our guest is an amazing woman, not only in AI and Power...
2019-07-19
8 reads
Last Week Reading (2019-07-07)
Hello, data eaters! Today, coming back from my friend by car, I was browsing a few posts on my cell (calmly – my wife was driving). At some point,...
2019-07-07
18 reads
Azure Databricks – create new workspace and cluster
In this post, I will quickly show you how to create a new Databricks in Azure portal, create our first cluster and how to start work with it. This...
2019-07-04
97 reads
Last Week Reading (2019-06-23)
Hello folks! Let’s take a look at a set of information from the field again. Press The best practices for performance comparison between Azure SQL Managed Instance and SQL...
2019-06-23
25 reads
ASF 023 video invitation
I’m happy to announce that the next episode of “Ask SQL Family” podcast is coming. This time our guest is Amit Bansal. We were talking to him during this...
2019-06-21
20 reads
Last Week Reading (2019-06-16)
Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of the data platform. Here you have a big portion of news today. Press Unlock the...
2019-06-16
15 reads
SSDT (SqlPackage) thread crashes with error when publishing
In this post, I will show you one of the scenarios when SSDT (SQL Server Data Tools) can fail unexpectedly while publishing database project to target server or preparation...
2019-06-12
83 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...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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