What does the Machine Learning process look like?
This is the second article in the Machine Learning area. I have explained a bit more about the steps the Machine Learning process is built of. You will be...
2019-07-21
301 reads
Blog Posts
SQL Saturday Albany Slides & Demo Code
Thanks to everyone who came out to see dbatools for the Uninitiated at SQL Saturday Albany on July 20th, 2019. I had a lot of fun sharing dbatools with...
2019-07-20
15 reads
“An installation package for the product Microsoft SQL Server 2012 Native Client cannot be found” – during SQL Server 2017 install
This blog post is about a situation that initially perplexed me – I was installing SQL Server 2017 onto a new DEMO machine – running Windows Server 2019. This...
2019-07-19
28,336 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
Azure SQL Database SLA Updates
I am sure many missed the updates to Azure SQL Database SLA (Service Level Agreement). It used to be 99.99% across all tiers but split between two different high-availability...
2019-07-19
213 reads
Behind the Scenes: How I Create Weekly Technical Videos
Be sure to watch this week’s video to get the full behind the scenes experience! Today I want to share my process for blogging and making weekly YouTube videos....
2019-07-19 (first published: 2019-07-02)
385 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
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
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
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
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
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
How to Persuade Your Company to Change
Like a lot of developers and database administrators, I do a fair amount of short-term problem solving during the course of my normal work week. I get to join...
2019-07-19
15 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