VSCode Tips–Remove the Highlighted Line
VSCode was making me crazy as I was writing a script. I like a light theme, and every time I went to type, I saw this: The highlight was...
2019-09-05 (first published: 2019-08-23)
2,526 reads
Blog Posts
Azure Storage Explorer
I only ever use the storage explorer when managing my blobs, files, queues within storage accounts. It is your single view access point for all your storage needs and...
2019-09-04
77 reads
Convert legacy password storage without aggravating your users
In a previous post I wrote about storing password hashes in a database, which raises the question of how to convert an existing legacy password storage system to use hashes (or...
2019-09-04
35 reads
MEAP MEAP – #dbatoolsMoL – Live Book edition
It’s been a busy time! As well as many other things, the fantastical BDFL of dbatools Chrissy Lemaire @cl and myself have written enough of a chunk of Learn dbatools in...
2019-09-04
64 reads
Query Performance Tuning with Filtered Statistics
Introduction I recently got a call from our DBA telling me that the CPU usage is hitting 100% on the DB server and the ETL process runs for more...
2019-09-04 (first published: 2019-08-26)
690 reads
Query Store stores dates as UTC
One of the powerful aspects of Query Store is the ability to directly query the DMVs for details of historical executions and performance. A key view for this is...
2019-09-04 (first published: 2019-08-21)
316 reads
Quick Blog: Clone Power BI Workspace Permissions
However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It's a pretty...
2019-09-04
49 reads
Quick Blog: Clone Power BI Workspace Permissions
However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It's a pretty...
2019-09-04
9 reads
SQL in the City Streamed is Today
Today is SQL in the City Streamed!!! Only three of us, , as Kendra has other commitments. Still, it’s exciting for Kathi, Grant, and myself to be presenting the...
2019-09-04
19 reads
Use of SQL server statistics and how to make a query to use them
Statistics are very important in the query...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-09-04
206 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