MongoDB -Access different databases and Collections
You can use db.getSiblingDB() method to access another database without switching the database.
To List Collections of PP database and query...
2016-01-14 (first published: 2016-01-07)
1,937 reads
Download the Power BI Architecture Diagram
Update: I’ve updated the Power BI architecture diagram! Click here to view version 2!
As a Data Platform Solution Architect for...
2016-01-06
4,611 reads
XenApp/XenDesktop 7.6 FP3 VDA Deployment Issue
During the upgrade to XenApp 7.6 FP3 VDA encountered the following message.
I was wondered on seeing this popup to restart...
2016-01-06
568 reads
T-SQL Tuesday #74 Invitation: Be the Change
Happy New Year and welcome to another T-SQL Tuesday (number 74 to be exact). This time of the year, everyone...
2016-01-08 (first published: 2016-01-06)
2,148 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked...
2016-01-06
1,211 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked about the first major category the development ide and...
2016-01-06
5 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked...
2016-01-06
19 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked...
2016-01-06
42 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked...
2016-01-06
31 reads
Be an Expert not an Ehhpert!!!
As we embark on a new year I decided to take a look back at my career within I.T. trying...
2016-01-12 (first published: 2016-01-06)
2,250 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
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