SSMSDeploy Demo #2 - new features
I've made some changes to the addin, adding some new features:
Comments: You can now add a comment to your request....
2011-01-15
608 reads
PASSMN January Meeting Announced
The details are up and we have the meeting planned for January for the Minnesota SQL Server User Group (PASSMN). ...
2011-01-15
618 reads
SQLServerCentral.com Track at SQL Server Connections 2011 in Orlando in March
SQLServerCentral.com will be offering a track at SQL Server Connections, to be held March 27-31, 2011, at the JW Marriott...
2011-01-14
920 reads
Multi-tenant Architecture
When you design a database, or at least when I do, I think it’s important to build a database schema...
2011-01-14
4,475 reads
Failed Blog Posts
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some...
2011-01-14
732 reads
31 Days of SSIS – Instant Excel Spreadsheet (14/31)
31 Days of SSIS
It’s day fourteen of the 31 Days of SSIS blog series. It’s also Friday, so I’m taking...
2011-01-14
619 reads
Last Call for Speakers 24 Hours of PASS
Calling for Presenters!Today is the day! If you were planning to submit a session for the next 24 Hours of...
2011-01-14
793 reads
Denver SQL Server User’s Group Meeting on January 20, 2011
My good friend, Kevin Cox, of Microsoft’s SQLCAT (SQL Customer Advisory Team) will be giving a presentation on what is...
2011-01-14
567 reads
Removing Time From A Datetime Value
How much time would a DateTime have if a DateTime had no time?
Ok, forgive the bad pun. But the point...
2011-01-14
894 reads
Introducing MagicPASS - Orlando's New PASS Chapter
After a year of planning I'm proud to announce that South Orlando has a new PASS chapter: MagicPASS! Our first...
2011-01-13
1,004 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