Support for SSMS 2016 now available
Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install...
2015-11-11
568 reads
Don't Trust the Wizard
If you need to move data from one table into a new table, or even tables in a database into another database, the Import/Export Wizard in SQL Server Management...
2015-11-11
17 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage
Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage
NOVEMBER 11, 2015
IntroductionIn my next series of posts, I am going to look into processing files in...
2015-11-10
178 reads
Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage
Using AzCopy in a SQL Job to Upload Files to Azure Blob StorageNOVEMBER 11, 2015
Introduction
In my next series of posts,...
2015-11-16 (first published: 2015-11-10)
7,304 reads
More Thoughts on the PASS BAC
Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by...
2015-11-10
485 reads
Poor Data Modeling – T-SQL Tuesday #72
This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people...
2015-11-10
1,026 reads
T-SQL Tuesday #72 Invitation – Data Modeling Gone Wrong
T-SQL Tuesday is here again. I’ve had good intentions the past few times this event has come around and even...
2015-11-13 (first published: 2015-11-10)
1,980 reads
Renewed as MVP
I was renewed for another year as a SQL Server – now Data Platform – MVP, always pleasant news. My plan for...
2015-11-10
701 reads
New FileTable Questions Posted on SQLServerCentral
I’m late posting this, I wrote six questions after doing a refresh of what I knew (or should have known) about...
2015-11-10
448 reads
Why are you still using datetime?
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a...
2015-11-12 (first published: 2015-11-10)
4,854 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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