Looking Up Email Addresses with PowerShell
A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that...
2011-01-20
13,867 reads
Tips & Tricks for DBAs Writing Their First Article
I have been writing full or part-time for nearly 30 years, and I have written and edited hundreds of articles....
2011-01-20
1,366 reads
Remember OBJECTPROPERTY(..) when investigating objects.
The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...
2011-01-20
1,303 reads
31 Days of SSIS – No More Procedures (20/31)
Time to shift off of configurations and environments and talk more about SSIS packages and best practices. If you haven’t...
2011-01-20
1,832 reads
PASS Update #49–SQLRally
I get a lot of questions about how SQLRally is going, which tells me that there is a lot of...
2011-01-20
638 reads
SSMSDeploy 1.1 Now Available
Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...
2011-01-20
713 reads
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca. ...
2011-01-20
9 reads
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually...
2011-01-20
1,204 reads
31 Days of SSIS – DTSConfig Configuration (19/31)
31 Days of SSIS
The last two posts in the 31 Days of SSIS talked about the use of environmental variables...
2011-01-20
1,256 reads
New Book: Introduction to SQL Server
Last year, Kevin Kline (blog | twitter) introduced me to Oracle and database expert, Bert Scalzo. Bert was looking to take...
2011-01-19
602 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