What would you say you do here?
The other day, I was looking back at an excellent blog post my colleague Jamie Wallis wrote about what Product Marketing Managers do at Redgate. I really like the...
2019-12-09
16 reads
Distributing Jupyter Notebooks
If you’re working with the Microsoft Data Platform, you should be, at the least, exploring Azure Data Studio as a new tool in your toolbox. One of the big...
2019-12-18 (first published: 2019-12-09)
347 reads
Azure SQL Database – Automatic Tuning – Have you enabled it?
Do you enable this setting to allow automatic tuning to care of all your performance needs? Well not ALL your needs, more so: CREATE INDEX DROP INDEX FORCE LAST...
2019-12-09
70 reads
SQLSaturday Orlando Notes – Large Printed Schedules
One of the things we’ve done most years in Orlando is to print poster sized schedules. This started out as a supplement to giving everyone a printed schedule and...
2019-12-09
17 reads
Upgrading Windows 10 Home to Pro
I use Hyper-V and a few other things that require Windows 10 Pro. When I got my new laptop, it had Windows 10 home on it. Not a big...
2019-12-09
98 reads
Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic
Welcome back to my series on Power Platform quick tips! In this episode you will learn how to document your flow logic with comments.
2019-12-17 (first published: 2019-12-06)
520 reads
State of Database DevOps Survey
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe you’re automating all the things or maybe you’ve got a completely manual set of processes....
2019-12-06
53 reads
2019 PASS Summit Recap from a First Timer
Heading to PASS Summit… It is Sunday the week of PASS Summit and I am at the airport after a relaxing morning with my wife and son. Unfortunately, I...
2019-12-06
12 reads
Call to Action – Mentoring
A few weeks ago I attended the annual PASS Summit conference in beautiful Seattle, Washington. This is an event that I look forward to every year. Being able to...
2019-12-06
7 reads
HP is the 2019 Laptop Winner
This is for me, not necessarily for you, but I decided to go with the HP Spectre again. I saw an email from Best Buy over the Thanksgiving weekend,...
2019-12-06
52 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