Last Weeks Top “Reading” Links #69
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-03
1,095 reads
Blog Posts
Negative session_ids
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...
2014-02-03 (first published: 2014-01-27)
2,176 reads
Powershell in a Month Day 15 – Jobs
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-02-03
634 reads
Renaming The Reporting Services TempDB Database
Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to...
2014-02-03
1,343 reads
SSIS – Using Kill with SP_Who to Break locks
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
1,685 reads
SSIS – Using Kill with SP_Who to Break locks
The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...
2014-02-03
414 reads
Verdasys Digital Guardian and SQL Server
I’m writing this post as a reminder for myself and possibly to help out the poor souls that may suffer...
2014-02-03
1,044 reads
Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs
As we get closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2...
2014-02-03 (first published: 2014-01-27)
2,473 reads
What Tables Are In My Filegroups
One issue I've found a bit troublesome is trying to find out what's in a specific Filegroup. Let's say you're...
2014-02-03
385 reads
Analyzing your Microsoft Exchange Account Data with Power Query
One of the interesting additions to the Power Query Preview December update is the ability to import data from Microsoft...
2014-02-02
496 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