24 Hours of PASS: Day 1
Yesterday was the first day of PASS’ 24 Hours of PASS event. For those not familiar, 24 Hours of PASS is...
2011-03-16
769 reads
Disaster Recovery Exposure - Part Two
In part one, I gave a general overview of some of the things that may affect IT services in the...
2011-03-15
537 reads
Disaster Recovery Exposure. - Part One
G'day,
I've just readPaul Randal's sqlmag article about the need to test your disaster recovery strategy. In that article Paul mentions...
2011-03-15
1,166 reads
The MCM is Worldwide
Well, not everywhere, but as long as Prometric sites meet some security requirements, they can offer the MCM tests. I...
2011-03-15
841 reads
Has Microsoft Desktop Virtualization Reached The End Of The Road?
I'm a big proponent of using Virtual Machines for development on your local machine. It just doesn't make sense to...
2011-03-15
614 reads
24 Hours of PASS Spring 2011 Code Sins
Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring...
2011-03-15
676 reads
Boulder SQL Server User’s Group Meeting
I will be presenting at the Boulder SQL Server User’s Group (BSSUG) on March 15, 2011. My presentation will be...
2011-03-15
525 reads
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person...
2011-03-15
9 reads
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good...
2011-03-15
711 reads
3rd Simple-Talk.com Article: 'The Polyglot of Databases: How Knowledge of MySQL and Oracle Can Give SQL Server DBAs an Advantage'
After revising the popular Blog post, Developing Your DBA Skills Futher Thanks to Experience with Multiple RDBMS, of just over a year...
2011-03-15
852 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
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
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