Deployed Session Settings
Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...
2015-09-28
17 reads
Deployed Session Settings
You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...
2015-10-05 (first published: 2015-09-28)
1,237 reads
SSMS Connection Information
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...
2015-10-05 (first published: 2015-09-28)
2,103 reads
Advanced SSIS Training Course Preview
If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and...
2015-10-02 (first published: 2015-09-28)
2,037 reads
Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...
2015-10-01 (first published: 2015-09-28)
4,292 reads
Why I Don't Use the Architect Title
I get nervous when I see the title "architect" in IT job roles.
I've had this title before as an employer's...
2015-09-28
473 reads
Table partitioning
What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...
2015-09-28
546 reads
SQL Saturday as an Attendee
Last week I did something that many people have already done. However this was my first experience, and I really...
2015-09-25
663 reads
Thoughts on the 2015 PASS Election
We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim...
2015-09-25
678 reads
The Extended Event GUI
The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Related Posts:
Profiler...
2015-09-25
12 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