Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done some amazing stuff over the years. We’re going to be doing even more amazing stuff...
2020-02-24
37 reads
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another example comes from the stack of audit events that exist only in Extended Events. One...
2020-02-24
60 reads
Speaking for Omaha Azure User Group Wednesday
This Wednesday, February 26th, I will be presenting a new session entitled “All Things SQL in the Microsoft Cloud” for the Omaha Azure Users Group, starting at 6pm Central...
2020-02-24
11 reads
Stop #AzureDataStudio from opening a connection screen on startup
When I’m working with a tool I like a clean startup. And by that I mean don’t automatically open anything. ... Continue reading
2020-03-03 (first published: 2020-02-24)
168 reads
SheLeadsTech Webinar: Braving the Wilderness of Cybersecurity
ISACA has a SheLeadsTech webinar for tomorrow, February 25, 2020 titled Braving the Wilderness of Cybersecurity. Registration Link: https://www.isaca.org/education/online-events/lms_w022520 If you can’t make the talk, ISACA archives all webinars...
2020-02-24
22 reads
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post! I was talking with my...
2020-02-22
50 reads
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions. .NET Notebooks are Jupyter Notebooks that use .NET core to enable C#,...
2021-04-28 (first published: 2020-02-22)
265 reads
Come work with me! Be a Sales Engineer for Redgate
Redgate is growing, and we have some fresh, new open positions around the world which would be a great fit for SQL Server developers or DBAs who would like...
2020-02-21
16 reads
My Deadlock Resolution Progress Report
As I wrote last month, I went through a period of feeling personally and professionally deadlocked, and flailed about for some time before I found the answer of making...
2021-04-28 (first published: 2020-02-21)
388 reads
ACM Lecture at SELU
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at the Southeastern La. University ACM group. Big thanks to the bright student organizers for inviting...
2020-02-27 (first published: 2020-02-21)
140 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