See you Saturday in Houston!
Here’s your friendly neighborhood reminder to get free learnin’ at SQL Saturday Houston this weekend, where we’ll have the MinionWare booth, and sessions...
2016-05-12
522 reads
Use The Correct Data Type
Blog post #5 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Saying that you should use the...
2016-05-18 (first published: 2016-05-12)
1,994 reads
Free eBook – Modern Storage Strategies for SQL Server
I’m pleased to announce the general availability of a new free ebook collaboration with James Green from ActualTech Media called...
2016-05-17 (first published: 2016-05-12)
3,757 reads
Comparing the contents of two tables
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...
2016-05-16 (first published: 2016-05-12)
3,581 reads
PowerShell – SQL Database Refresh -Restore – Multiple Databases
.SYNOPSIS
The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.
.DESCRIPTION
The...
2016-05-12
1,764 reads
Find Unused Database Objects in SQL Server
Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...
2016-05-12
585 reads
Upcoming SQL Saturdays - June 2016
I am speaking at two different SQL Saturdays in June!
--
First up on June 4th is SQL Saturday #517 Philadelphia (#SQLSAT517)...
2016-05-12
629 reads
PowerShell – Backup Specific group of SQL Databases
<#
.SYNOPSIS
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh...
2016-05-11
595 reads
Azure Speed Testing
Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...
2016-05-11
1,554 reads
SQL Server – Cleaning Procedure Cache for a particular database
HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...
2016-05-11
579 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