Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-11
27 reads
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-18 (first published: 2019-11-11)
575 reads
Azure Synapse Analytics new features
Almost lost in all the announcements from Ignite was a bunch of amazing new features that were added to the Provisioned Resources/SQL Pool section (read SQLDW functionalities) side of...
2019-11-19 (first published: 2019-11-11)
532 reads
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing event every year, but this last week, I saw a ton of indications that our...
2019-11-20 (first published: 2019-11-11)
632 reads
Improving the Quality of Your Automation Logging with Cowsay
TEST Automation Taxes Your Sanity
You have to glue together systems with your amazing duct taped scripts.
You see failure after failure.
You want help predicting the success of your next run,...
2019-11-11
20 reads
SQLSaturday Orlando Notes – Coffee
I like to say that the goal for any event is to meet the expectations of attendees. The trick is to set the expectations because if you don’t, they...
2019-11-11
31 reads
New HA Licensing Benefits
Microsoft announced recently that they were changing the way licensing works for HA and DR situations. I think this is a great change, and the summary is: You can...
2019-11-11
42 reads
Weekly reading #30
Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...
2019-11-11
26 reads
Weekly reading #30
Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...
2019-11-11
53 reads
AG without WSFC SQL 2017 and more…
Starting Sql Server 2017 Microsoft can allow you to enable the configuration manager for “Always ON” feature for standalone system without WSFC and linux without Pacemaker . it has...
2019-11-11
49 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