Training – Learning Data Science
You should never stop learning, especially within the IT industry. There are many fields to move into nowadays within the data space, you still have your classic / cloud...
2019-09-12
229 reads
Gatekeeping and the lack of diversity in the workplace
Recently I have become more vocal on Twitter and on my personal blog about my social activism. For the record, I have been an activist for LGBTQIA+ rights since...
2019-09-11
117 reads
Workshop – Kubernetes Zero to Hero at SQL Saturday Denver!
Pre-conference Workshop at SQLSaturday Denver
I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Denver on October 11th 2019! This one won’t...
2019-09-11
15 reads
Workshop – Kubernetes Zero to Hero at SQL Saturday Denver!
Pre-conference Workshop at SQLSaturday Denver I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Denver on October 11th 2019! This one...
2019-09-11
11 reads
SQLSATDenver PreCon – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment!
Pre-conference Workshop at SQLSaturday Denver I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Denver on October 11th 2019! This one...
2019-09-11
47 reads
Quick SSMS Tip
It is widely known that I am a horrible speller and hate to type code. I tend to use a lot of code snippets and reuse code to avoid...
2019-09-20 (first published: 2019-09-11)
1,265 reads
Changing the SQL Data Masker Connection Target
This post will explain how to change the connection in your masking set when using SQL Data Masker from Redgate. I’m writing this more for myself than anyone else....
2019-09-11
45 reads
SQL Server Wishlist
This month for T-SQL Tuesday Kevin Chant asks us what our fantasy SQL feature would be. https://www.kevinrchant.com/2019/09/03/t-sql-tuesday-118-your-fantasy-sql-feature/ I think it’s appropriate to give a shout-out to Microsoft at this...
2019-09-11
90 reads
Weekly reading #25
It has been a long time since the last weekly reading post. We have been in Shanghai and Bangalore during the time. We attended in #DPS10 in Bangalore –...
2019-09-11
5 reads
Weekly reading #25
It has been a long time since the last weekly reading post. We have been in Shanghai and Bangalore during the time. We attended in #DPS10 in Bangalore –...
2019-09-11
28 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...
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