What's OLD in SQL Server 11 aka Denali? - Deprecated Feature List
Well, we always see, hear, and read about the list of NEW features in the myriad of articles, columns and blogs...
2011-02-08
1,744 reads
SQL University: SQL Server Security Architecture - 3rd Party, No Options
Welcome back to day 2 of Security Week for this semester of SQL University. If you missed yesterday's introduction, you'll...
2011-02-08
2,476 reads
Book #2 - Dynasty in the making?
Ok so dynasty might be a bit strong, but check out this
newest volume from the folks @ Pragmatic Works. We...
2011-02-08
628 reads
10 Things Every DBA Should Do
Recently I spoke about how The Best Database Administrators Automate Everything, as well as Document Everything and this got me...
2011-02-08
2,325 reads
February PASSMN Meeting Announced
If you are looking for a change to get together with other SQL Sever professionals in February to talk about...
2011-02-07
721 reads
Promoted to MSDB Rockstar Blogger
I just found out this morning that I was promoted from TempDB to MSDB on Thomas LaRock’s (blog|Twitter) Rockstar blogger...
2011-02-07
493 reads
SQL Saturday #60: The Saga
First, let me thank Erin Stellato (blog|twitter) and all the volunteers for running such a great event. Nicely done.
This event...
2011-02-07
756 reads
SQLSaturday #62–Tampa Recap
I had the privilege of attending and speaking at SQLSaturday #62 – Tampa the weekend of January 15th and this is my belated recap post of what I did...
2011-02-07
12 reads
Speaking at the Houston SQL Server Users Group
Since I am working at a client this week in Houston, I begged Nancy Hide Wilson (President Houston SQL Server Users...
2011-02-07
593 reads
PowerShell: Download List of SQL Server MVPs
Turtle Shell?!
This weekend, I was working on something that I will blog about later this week. As part of that,...
2011-02-07
760 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...
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
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