31 Days of SSIS for SQL Server 2014 Update Question
A few years back, I put together a blog series on SQL Server Integration Services (SSIS) titled 31 Days of SSIS....
2014-02-24
1,302 reads
Blog Posts
Accenture and DataStax Establish Big Data Alliance #bigdata
Accenture and DataStax have signed an alliance agreement, formalizing their longstanding collaboration in helping clients manage and drive insights from...
2014-02-24
585 reads
Expiration dates: SQL Server 2008 and 2008 R2
SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support...
2014-02-24
576 reads
Free Presentation Software
Here’s a list of free presentation software I ran across, maybe worth a few minutes to get out of the...
2014-02-24
734 reads
HealthySQL 2.0 for SQLSaturday#268
Over the last year, I was presenting and touring the SQL Saturday circuit with my HealthySQL 2.0 presentation. HealthySQL is...
2014-02-24
1,194 reads
How to check for last SQL Server backup
As a database professional, I get asked to review the health of database environments very often. When I perform these...
2014-02-24 (first published: 2014-02-18)
3,119 reads
Last Weeks Top “Reading” Links #72
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-24
1,052 reads
Modern Retail Architectures Built with Hadoop | Hortonworks
We’ve probably all heard the famous quote by John Wanamaker, the father of modern advertising: “Half the money I spend...
2014-02-24
1,031 reads
Notes From SQLSaturday #273
Speaker dinner at Spaghetti Warehouse was packed. Great crowd, not such great service. At 8:45 pm we still had not...
2014-02-24
676 reads
Oracle Tips for MSBI Devs #5: Working with Oracle on Windows Azure
As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work...
2014-02-24
888 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
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
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