Mixed feelings over the new truncation error
As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error....
2019-04-05 (first published: 2019-03-20)
2,040 reads
Blog Posts
Speaker at SQL Saturday’s Colorado Springs 2019
I’m very happy to announce that for the first time, I will be participating as speaker at the SQL Saturday# 830 in Colorado Springs Here are the details of...
2019-04-05
63 reads
That Awkward Moment When….
Let's be honest - some of our best learning experiences come from our mistakes. Here's one of mine....
2019-04-05
20 reads
What Chocolatey Packages Does a Business Intelligence Developer Need?
I’m getting a new work laptop next week: Hooray!! ?? I’m going to have to install A LOT of software: Opportunity! ?? Problem: I have a lot of meetings...
2019-04-05
15 reads
What Chocolatey Packages Does a Business Intelligence Developer Need?
I’m getting a new work laptop next week: Hooray!! ?? I’m going to have to install A LOT of software: Opportunity! ?? Problem: I have a lot of meetings...
2019-04-05
26 reads
Activate Conference 2019: Databases 101 for the Aspiring App Dev Session Info and Resources
A special hello if you're visiting this blog post during or after my workshop on Thursday afternoon, April 4 at the Louisiana Tech Park as park of the Activate Conference...
2019-04-04
14 reads
dbatools for the accidental DBA
dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are...
2019-04-04 (first published: 2019-03-18)
2,431 reads
Disk Space and SQL Server
Disk Space in SQL Server
One of the frequently required job functions of the database administrator is to track disk space...
2019-04-04 (first published: 2019-03-18)
2,411 reads
Speaking Again at the Techno Security and Digital Forensics Conference
I’ve once again been selected to speak at the Techno Security and Digital Forensics Conference in Myrtle Beach, SC, this year. I’m on the calendar for Wednesday, speaking again...
2019-04-04
32 reads
Two more of my presentations
I recently made available two more presentations that you might find helpful. Feel free to download them and present them to others (adding a line that you got them...
2019-04-04
69 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