Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,207 reads
Blog Posts
Last Weeks Top “Reading” Links #54
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-21
865 reads
MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
981 reads
No, Simple Mode Doesn’t Disable The Transaction Log
If you’ve spent any time with me in person, trading war stories, you’ve likely heard my rant about the consultant...
2013-10-21
6,266 reads
PASS Summit 2013 and SQL Saturday Charlotte in Review
I love reading the many blogs posts that pour in following a PASS Summit. I think it is fun to...
2013-10-21
769 reads
PASS Summit 2013-Almost Final Thoughts
I’m home in Orlando, reveling in not being jet lagged for once. A great traveler I am not. I was...
2013-10-21
652 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Summit 2013. The abstract is below. It...
2013-10-21
767 reads
Presentation Slides for Transitioning to a BI role
Thanks to everyone who attended my session “Transitioning to a BI role” at the PASS SQL Saturday Charlotte. The abstract is below. Another...
2013-10-21
704 reads
Win a Free Conference Pass to SQL Server Live! in Orlando
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional. Courtesy SQL Server Live! I’ve got an outstanding opportunity for...
2013-10-21
16 reads
Win a Free Conference Pass to SQL Server Live! in Orlando
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional.
Courtesy...
2013-10-21
609 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