MS Certs Exam price is rising …
Today Marlon Ribunal twittes come with new info about MS Certifications exams are rising…
This is not a good news, so...
2011-04-28
750 reads
DevConnections – Heavily Discounted Passes !
DevConnections – London June 2011
DatabaseExpertise has negotiated 10 tickets for the main 2 day conference, at an amazing price of £100!!!
The first...
2011-04-28
706 reads
Daily Denali Delight – Day 6
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released you can be sure to...
2011-04-28
807 reads
A SQL Server Hardware Nugget A Day – Day 27
For Day 27 of this series, I am going to talk a little bit about disk performance and one easy...
2011-04-27
1,319 reads
It’s a Deal, It’s a Steal…
Its the sale of the century. To coin a cleaned up phrase from a Guy Ritchie film (either Snatch or...
2011-04-27
643 reads
Connection strings and application name
G’day,
There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply...
2011-04-27
15,008 reads
What name should I call myself?
In creating this blog, I was thinking about using some catchy name for myself. Something with “DBA” in it. However,...
2011-04-27
744 reads
Presenting On DR & HA Twice This Week
Just a quick mention that I'm presenting Paging DR Availability, You're Wanted in the Recovery Room twice this week - today,...
2011-04-27
577 reads
What’s Mentoring?
We have just kicked off The Mentoring Experiment after talking about it for months. There has been a lot of...
2011-04-27
1,367 reads
Powershell Day 27
Day 27 Inventory As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as:...
2011-04-27
528 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