Interview with Greg Low
This is the sixth interview we have done. This time our guest is Greg Low! I bet you know Greg as he is one of the most recognizable person...
2019-09-27 (first published: 2019-09-17)
244 reads
Blog Posts
Pre-Con in Denver
As prep for our pre-con at the PASS Summit, Kendra and I are presenting a pre-con at the Denver SQL Saturday#908, on Friday, October 11, 2019. We’ll be talking...
2019-09-27
77 reads
Quick Blog: Making the Power BI PowerShell cmdlets easier to use
One of the top reasons I love PowerShell so much is that from the beginning, it was designed to let you, yes you, make it run better for the...
2019-09-27 (first published: 2019-09-19)
675 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
The post Quick Blog: Run PowerShell Core from...
2019-09-27
24 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
The post Quick Blog: Run PowerShell Core from...
2019-09-27
15 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
2019-09-27
148 reads
2019-09-26T13:58:58+00:00
TEST You know you probably reserved the wrong hotel when you drive around from the back and think it's a condemned building, only to come around the front and...
2019-09-26
8 reads
2019-09-26T14:04:40+00:00
TEST I have a new term for the wait my daughter eats food. Instead of please stop wearing food all over your face and eat proper I'm going to...
2019-09-26
10 reads
ASF 025: Rob Farley interview
Introduction Rob Farley is a Microsoft Certified Master, Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server since 2006. Rob provides consulting and...
2019-09-26
27 reads
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live Query Statistics feature was introduced with SQL 2016, but I was using the functionality this...
2019-09-26 (first published: 2019-09-18)
1,933 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