The Short Answer? (In at least a couple of places) When I first learned about the DRU, I was very excited about the possibilities. I began to play with...
2019-03-28
17 reads
Brent recently did a post called In Azure SQL DB, what does “The connection is broken and recovery is not ... Continue reading
2019-03-27
124 reads
Last week I showed you how to use WorkloadTools to analyze a workload. As you have seen, using SqlWorkload to...
2019-03-27 (first published: 2019-03-12)
1,700 reads
The first critical task any data professional should ever learn how to do is how to connect to SQL Server. Without a connection to SQL Server, there is barely...
2019-03-27
493 reads
The first critical task any data professional should ever learn how to do is how to connect to SQL Server. Without a connection to SQL Server, there is barely...
2019-03-27
9 reads
When you drop a database from a SQL Server instance the underlying files are usually removed. This doesn’t happen however if you set the database to be offline first,...
2019-03-27
56 reads
In this article, we will learn how to enable the Azure AD multi-factor Authentication via Azure Portal. In previous article, we learnt how to set up Azure AD and...
2019-03-27
45 reads
There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool). I actually found the process quite messy...
2019-03-27
33 reads
And if you are still reading you probably fit into one of the following categories.
Not a DBAA relatively new DBALike...
2019-03-27 (first published: 2019-03-14)
859 reads
The SQL in the City Summits are back for 2019, and we’ve got more scheduled than every before. You can see the complete list on our event page, and...
2019-03-27
136 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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