Cloud Security
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those...
2016-08-22
660 reads
Who did what to my database and when…
One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table,...
2016-08-30 (first published: 2016-08-22)
2,850 reads
Power BI Custom Visuals Class (Module 13 – Aster Plot)
In this module you will learn how to use the Aster Plot Power BI Custom Visual. The Aster Plot is...
2016-08-22
1,091 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
779 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
72 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
58 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac's. In particular I am talking about how...
2016-08-21
20 reads
Setting PowerShell as your default Linux shell
In this post we’re going set PowerShell as your default Linux shell.
What is a shell? In Linux systems you’re given options, tons of options, you can set, reconfigure, add/remove...
2016-08-20
13 reads
Setting PowerShell as your default Linux shell
In this post we’re going set PowerShell as your default Linux shell.
What is a shell?
In Linux systems you’re given options,...
2016-08-20
725 reads
Introduction to Power BI Desktop – Session Materials Available
For my second time, I was afforded the great opportunity to present virtually to the great people of the Madison...
2016-08-19
584 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