The Powershell Challenge
I’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve...
2013-11-07
1,409 reads
Blog Posts
Transparent Data Encryption’s Dirty Little Secret
Remember when you were eight years old, how exciting it was to order some of those amazing products that were...
2013-11-07
936 reads
hacked
ugggh.
My Drupal site in AWS EC2 was hijacked and is being used by the hijackers to do port scans.
Who said...
2013-11-06
604 reads
How to find empty tables in SQL Server : Quick Tip
These quick tips are short and sweet. They are nothing more than an explanation and some code. If you have...
2013-11-06
547 reads
Murder They Wrote
For those of you that know me, you know that I enjoy learning, and passing on what I have learned...
2013-11-06
798 reads
One Database Mirror disconnected case
Today I got a database mirror case, I was told the all databases were in disconnected\in recovery status on both...
2013-11-06
1,232 reads
Physical Join Operators by Ami Levin
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...
2013-11-06
683 reads
SQL Saturday Dallas
I've been to five SQL Saturdays so far and this was my first year to attend the Dallas conference. Therewere...
2013-11-06
405 reads
Transactionally Consistent
What does this mean? I had someone ask me in a session recently, and I think I have a good...
2013-11-06
1,102 reads
Adding a column to a table with a default (NULL vs NOT NULL)
There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...
2013-11-05 (first published: 2013-10-30)
5,177 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