DBA 101: Altering a column
People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly...
2017-02-06 (first published: 2017-02-02)
2,231 reads
Getting Started with Power BI: Setup (Part 1 of 3)
This is part 1 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-02
203 reads
Microsoft Data Platform MVP Award
I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is...
2017-02-02
511 reads
Compare Execution Plans
Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the...
2017-02-02
452 reads
Speaking at SQL Konferenz 2017
I’m heading back across the Atlantic this February for SQL Konferenz. This is an intimate SQL Server event in Darmstadt...
2017-02-01
567 reads
Changing what SSMS opens on startup
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and...
2017-02-01
795 reads
SQL Containers and Networking
I recently talked with the guys over at SQL Data Partners on their podcast about SQL Server and containers. It...
2017-02-10 (first published: 2017-02-01)
1,914 reads
Columnstore Indexes – part 97 (“Working with Strings”)
Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
After many years of using & fighting the...
2017-02-01
662 reads
Availability Group on SQL Server 2016
The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...
2017-02-01
2,343 reads
Improve performance by replacing temp tables with memory optimized tables - Part 1
There are many cases where you will be using temp tables, and many of us are trying to seek for...
2017-02-01
6,950 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