A Quick Look at Travel
I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll...
2019-12-24 (first published: 2019-12-02)
292 reads
SQLSaturday Orlando Notes – Owning Stuff
One of the choices you make as an organizer is whether to buy anything that you want use or give away at the end of the event. Owning nothing...
2019-12-20 (first published: 2019-12-02)
180 reads
Take the 2020 State of Database DevOps survey
It’s still 2019, but we’re looking forward to 2020 and wonder how your world has changed since our survey last year. There are a number of questions and this...
2019-12-13 (first published: 2019-12-02)
92 reads
PASS Summit 2019 in Photos
I took a bunch of photos at and around Summit this year, including more selfies than in years past - I’m getting better about it! For a few more...
2019-12-02
25 reads
Information Measurement with SQL Server Part 4.7: The Bhattacharyya and Hellinger Distances
By Steve Bolton …………Over the course of this segment of the series, we’ve slowly assembled a classification system for some distances measures that can be used for DIY data...
2019-12-11 (first published: 2019-11-30)
421 reads
Happy Thanksgiving
Yesterday was Thanksgiving for those of us living in the United States. If you celebrate this particular holiday, I hope that it was a day full of love and...
2019-11-29
8 reads
How to fork a GitHub repository and contribute to an open source project
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To collaborate with a repository in...
2019-11-29
28 reads
ASF 027: Mikael Wedham interview
Introduction Mikael Wedham is the first Microsoft Certified Master on SQL Server 2008 in Sweden. He has worked as a developer and database administrator since 1993 and in ’97,...
2019-12-12 (first published: 2019-11-29)
140 reads
PASS Summit 2019 Photowalk
This was my first year joining the Summit Photowalk organized by Jamie Wick (blog | twitter). I had a lot of fun - Seattle is full of great photo...
2019-11-29
13 reads
Woman in STEM award 2019!
gethynellis.com is proud to sponsor the Woman in STEM award at the Woman’s Business Club conference 2019! The Women in STEM award recognises the outstanding contributions of woman in...
2019-11-28
22 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
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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