Business Mum of the Year Finalist 2019
Here at gethynellis.com we are proud to announce that our Operations Director Sabrina Ellis is a finalist for the Business Mum of the Year award, taking place on Wednesday...
2019-11-26
28 reads
Business Mum of the Year Finalist 2019
Here at gethynellis.com we are proud to announce that our Operations Director Sabrina Ellis is a finalist for the Business Mum of the Year award, taking place on Wednesday...
2019-11-26
55 reads
How to Fix SQL Database Logical Consistency Based I/O Error
There can be several reasons that cause Database Logical Consistency based I/O error:
Unexpected system shutdown/crash or forced shutdown
SQL administrator tries to query or modify SQL data
In both the circumstances,...
2019-11-26
35,102 reads
Containers: Upgrading SQL Server from 2017 to 2019 RTM
Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...
2019-12-05 (first published: 2019-11-25)
333 reads
#PowershellBasics: Working with arrays
I mentioned arrays in a previous post so I figured I should talk about what they are and how to ... Continue reading
2019-12-06 (first published: 2019-11-25)
465 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
17 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
18 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-11-25
15 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-12-09 (first published: 2019-11-25)
757 reads
SQLSaturday Orlando Notes – Cupcakes & Ice Cream
For the past few years we’ve had a a local sponsor provide cupcakes as the “sweet treat”. We started with mid afternoon but found it worked well if we...
2019-11-25
30 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers