Running Powershell with Task Scheduler
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
One...
2015-12-09
2,534 reads
PASS Board Update: First Year
This represents my 12th month on the board so I thought I would recap my time there so you know...
2015-12-09
484 reads
Getting Started with Azure Data Factory - Part 1
Getting Started with Azure Data Factory - Part 1
DECEMBER 9, 2015
IntroductionThe Azure Data Factory is a means of moving data around in the cloud. In a similar way that...
2015-12-09
27 reads
Getting Started with Azure Data Factory - Part 1
Getting Started with Azure Data Factory - Part 1DECEMBER 9, 2015
Introduction
The Azure Data Factory is a means of moving data around...
2015-12-09
4,153 reads
Documenting Your Database with Diagrams
Documenting Your Database with Diagrams
Don’t get too excited. I know you love documentation, and just can’t wait to spend some...
2015-12-09
375 reads
T-SQL Tuesday #73 – Naughty or Nice?
Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday.
As you work with SQL Server look around you....
2015-12-09
1,490 reads
T-SQL Tuesday #73: IOPS on Azure VM's Naughty to Nicer
Hello Dear Reader! Last week I posted the invitationto T-SQL Tuesday #73. The premise? “As you work with SQL Server look around you. Is your environment Naughty or Nice? ...
2015-12-08
18 reads
T-SQL Tuesday #73: IOPS on Azure VM's Naughty to Nicer
Hello Dear Reader! Last week I posted the invitationto T-SQL Tuesday #73. The premise?
“As you work with SQL Server...
2015-12-08
654 reads
T-SQL Tuesday 73 – Naughty or Nice?
Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday.
As you work with SQL Server look around you. Is...
2015-12-08
90 reads
T-SQL Tuesday #73: Never Made That Mistake Again
T-SQL Tuesday is a monthly community-wide blogging event created by Adam Machanic (blog|@AdamMachanic), and everyone is invited to particpate. This...
2015-12-08
1,900 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