SSIS: Custom Folder in your Package Store
Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store. I...
2011-02-07
1,482 reads
Second Book Available for Pre-Order
Over the past six months I have writing chapters for my next book. The book is titled SharePoint 2010 Business...
2011-02-07
769 reads
Using PowerShell To Search The Event Log
The “30-minute DBA” was operating in a highly effective mode. He’d automated most everything that could be automated. The first...
2011-02-07
2,692 reads
One Simple Doorstop
I saw an article in American Woodworker by Alan Lacer about making wooden doorstops and decided to try one. You...
2011-02-07
516 reads
Pre-Order SharePoint 2010 Business Intelligence 24-Hour Trainer
I wanted to announce that you can now pre-order your copy of my latest book to be released called SharePoint...
2011-02-07
953 reads
SSMS Tips and Tricks – ALTernative Highlighting
This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share...
2011-02-07
1,326 reads
SQLSaturday #62–Tampa Recap
I had the privilege of attending and speaking at SQLSaturday #62 – Tampa the weekend of January 15th and this is...
2011-02-07
921 reads
28-days in February - What to do - Read about Waits & Queues
Happy Monday! I'm sure many of you may have already caught on, that Waits & Queues is the way to go...
2011-02-07
718 reads
SQL University: Architecting SQL Server Security, the Big Picture
Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...
2011-02-07
3,331 reads
RTFM365, Weeks 8-9
I’m not gonna lie to you, Marge…I haven’t exactly been keeping up with the RTFM365. And when I have read,...
2011-02-07
611 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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