Get a List of Files with Data
The trick here is to find a way to search thousands of files quickly and filter easily the bad from the good. Sounds like an opportunity for an automation...
2019-12-30
7 reads
Get a List of Files with Data
The trick here is to find a way to search thousands of files quickly and filter easily the bad from the good. Sounds like an opportunity for an automation...
2020-01-13 (first published: 2019-12-30)
698 reads
Azure – BGP Community for Application Insights (Need Votes)
Working with Microsoft, we determined that there is no BGP community for Azure’s Application Insights. As a result, I’ve created a feedback request for Microsoft to consider doing just...
2020-01-08 (first published: 2019-12-30)
120 reads
Ending My Time as PASS President
With the end of the year, other things are coming to an end as well. Tomorrow, December 31st, will mark my final day as President of the PASS organization....
2020-01-10 (first published: 2019-12-30)
455 reads
What I’ve learned from Groundhog Day.
One of my all time favorite movies is Groundhog Day staring Bill Murray. In case you’ve never watched it (and ... Continue reading
2020-01-10 (first published: 2019-12-30)
424 reads
What is the Merit of the Job?
One tries to climb the ladder of success but at the cost of being an approachable human being. Nice people don't need to finish last.
Related Posts:
It's an Honor:...
2019-12-30
5 reads
What is the Merit of the Job?
One tries to climb the ladder of success but at the cost of being an approachable human being. Nice people don't need to finish last.
Related Posts:
To Influence or...
2019-12-30
177 reads
Where is that Mask?
In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.
Related Posts:
Failed to Create...
2019-12-28
8 reads
Where is that Mask?
In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.
Related Posts:
Encrypting a Database...
2019-12-28
31 reads
Resolving Merge Conflicts in SQL Source Control – the Basics (video)
In this 35 minute livestream recording, I commit conflicting code to a Git repo in Azure DevOps Services using Redgate’s SQL Source Control, then step through options to fix...
2019-12-27
36 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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