Brian Kelley on Security at SQL Server Connections
Random notes from Brian Kelley’s security talk. Brian spent a number of years working a a security guy for a...
2011-03-30
1,898 reads
I laughed, I cried, it was better than CATS: The Fast Track Data Warehouse 3.0 Reference Guide
Careful what you say about cats, lady.
You know what’s crazy?
A comprehensive, technical, well thought-out, and ENJOYABLE document. One written with...
2011-03-30
1,794 reads
Improving Meetings
Most folks I know hate meetings. They especially hate meetings about meetings. Recently I was working with a developer who...
2011-03-30
2,099 reads
Tampa IT Camp 2011 Lessons Learned Part 1
On Saturday, March 19th 2011 we held the first ever Saturday “code camp” style event for the IT Pro (Sys...
2011-03-30
1,745 reads
SQL Saturday #74 Jacksonville
For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already...
2011-03-30
1,514 reads
How To Really Listen
One of the most undervalued skills that an individual can possess is the ability to listen. Are you really hearing...
2011-03-29
1,638 reads
Extended Events at SQL Server Connections with Jonathan Kehayias
I was very interested to hear Jonathan Kehayias’ session on extended events. I know this is one of the areas...
2011-03-29
1,907 reads
Brian Kelley talking Windows Internals for SQL Pros at DevConnections
I have known Brian for nearly as long as i have been running SQLServerCentral. He has been the guy that...
2011-03-29
1,705 reads
2011-03-29
1,573 reads
Brent Ozar Blitz at SQL Server Connections
The first session of the day for me was Brent Ozars Blitz talk on how to quickly get information on...
2011-03-29
1,882 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