Last Weeks Top “Reading” Links #62
Monday afternoon and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout most days I tweet...
2013-12-16
1,386 reads
Blog Posts
NFC Tags-Fun, And Maybe Useful at SQLSaturday
Last week I had one of those days when I read something and then heard someone talking about the same...
2013-12-16
905 reads
Nine T-SQL best practices
SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...
2013-12-16
971 reads
Scalzi’s Law of Cleverness, as applied to resumes
John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish...
2013-12-16
942 reads
SQL Saturday in Ancona and Verona – English slide decks available for download
You can download the english version of my sessions at SQL Saturdays (on SlideShare):
SQL Saturday 257 in Verona: “Put databases...
2013-12-16
306 reads
SQL Server 2012 AlwaysOn Presentation Given at Vermont PASS SQL Server User Group Last Week
This past Wednesday evening, 11th Dec, I braved the snowy roads down from Montreal to Winooski (Burlington area) to join...
2013-12-16
1,342 reads
Talk Your Boss Into A Free Lunch and Giveaways!: Day 6
Monday Giveaway!
It's Monday again! I know we all hate Mondays, but let's have a Fun Monday!It's another week to give...
2013-12-16
656 reads
MDX Implementing Logical OR On Members of Different Hierarchies
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...
2013-12-15
17 reads
MDX Implementing Logical OR On Members of Different Hierarchies
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...
2013-12-15
35 reads
Recent events wrapup
The last two weeks were just incredible! I gave my first SQL Saturday PreCon training session in Washington DC and...
2013-12-15
661 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