Azure Data Explorer
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data...
2019-03-14
2,276 reads
Blog Posts
Azure Data Explorer
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes...
2019-03-14
300 reads
Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when I was trying to build a Power BI demo...
2019-03-14
15 reads
Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when I was trying to build a Power BI demo...
2019-03-14
75 reads
Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when I was trying to build a Power BI demo...
2019-03-14
234 reads
Git, GitHub, GitLab, BitBucket, What’s the difference?
I was watching Brent’s webcast session on GitHub recently. I’ve struggled to explain this to users in the past, and...
2019-03-14 (first published: 2019-02-25)
3,662 reads
Scalar UDF Inlining in SQL Server 2019
How does Scalar UDF Inlining affect the performance of scalar functions?
SQL Server 2019 introduces a new feature called “Scalar UDF...
2019-03-14 (first published: 2019-02-25)
3,276 reads
SQL Server – max server memory
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
496 reads
#ITechDay in Warsaw
We were enjoying Thursday on conference in Warsaw. We have arrived pretty lately but easily saw the awesome atmosphere there....
2019-03-13
258 reads
Achieving SQL Server HA/DR with a mix of Always On Availability Groups and SANless SQL Server Failover Cluster Instances
Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
2,585 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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