Creative Database Naming
Every now and again, we as DBAs need to get away from the daily grind of the hum drum tasks. We need to find a way to have a...
2020-01-02
581 reads
Powershell : Desire State Configuration -DSC
Powershell in 2012, Powershell 4.x onwards introduced Desire State Configuration(DSC) which help to build the standard configuration/ process /template for your system state and can be use or maintain...
2020-01-02
198 reads
POWERSHELL -SQL Assessment
June/July 2019 Microsoft – powershell is providing another great feature with SMO and SQL Server module as SQL Assessment. This is a great feature where Microsoft- SQL Server is...
2020-01-01
114 reads
Looking ahead to 2020
This week all I want to say is Happy New Year, and may 2020 be the start of a successful decade for you. Live, love, learn. Remember to take...
2020-01-01
20 reads
2019 in Review
What an incredible year it’s been. I kept thinking that I was busy, but I had no idea until I looked at the final numbers (I have a Power...
2020-01-01
125 reads
SQL Homework – January 2020 – Document, document, document
Happy New Year! It being New Year’s, at least by the Gregorian calendar, I thought we could make this month’s ... Continue reading
2020-01-01
28 reads
Cannot Open Backup Device
When running into error 1326, it makes plenty of sense to try to create a backup dump device (only as a testing exercise) as well as test the connectivity...
2020-01-01
26 reads
Cannot Open Backup Device
When running into error 1326, it makes plenty of sense to try to create a backup dump device (only as a testing exercise) as well as test the connectivity...
2020-01-01
351 reads
2019 Year in Review
As we open 2020 (and the house is still quiet on this New Year’s Morning), I thought I’d take a moment to reflect on the past year.
Blogging 2019 was...
2020-01-01
15 reads
Negative Port Numbers
Validating your server setup is an integral component of your duties as a SQL Server DBA. When performing those validations, it is possible to run into an intriguing difference...
2019-12-31
128 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