Presentation Deck For Hardware 201 at Denver SQL Server User’s Group on May 19, 2011
I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance...
2011-05-20
789 reads
IT and Innovation
This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a...
2011-05-19
745 reads
MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it last year with the exception that I at least...
2011-05-19
5 reads
MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it...
2011-05-19
519 reads
Change SQL Servers Authentication Mode with PowerShell
Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One...
2011-05-19
5,845 reads
WHERE HAVE YOU BEEN, patrick leblanc????
Ok, so what have I been up to?Well a lot has changed for me over the past couple of months,...
2011-05-19
1,130 reads
Report Builder: Change Report Server Connection
A question that I have been asked quite often is, “How can I change the Report Server that I am...
2011-05-19
6,496 reads
The 2013 PASS Summit Goes to Charlotte
Just in case you didn’t catch the news yesterday on Twitter, the PASS blog, or via the PASS Connector, we...
2011-05-19
694 reads
Answering SQL Questions and Forum Fun Overview
Why SQL questions are interesting and how I'm using forums to challenge myself and help others.
I like a good SQL...
2011-05-19
653 reads
Fun with SQLskills
I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal)...
2011-05-18
894 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...
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