Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller
This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
Part...
2015-04-29
2,137 reads
Using SSIS Lookup Transformation in ETL Packages
Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of...
2015-04-29
17,874 reads
Are You Backing Everything Up?
We hear the common refrain among DBAs all the time. Back up your data! Test your restores! If you can’t restore the backup, it’s worthless. And yes, absolutely, you...
2015-04-29
17 reads
Restoring a database that doesn't exist
When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't...
2015-04-28
2,355 reads
Restoring a database that doesn’t exist
When restoring a database that doesn’t exist, say for instance when a client sends a database to you, you can’t...
2015-04-28
277 reads
A Tale of SQL Server Disk Space Trials and Tribulations
#SQLNewBlogger
Details:
System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the...
2015-05-05 (first published: 2015-04-28)
5,725 reads
Using PowerShell to Export SQL Data to CSV. How well does it perform?
So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following...
2015-05-07 (first published: 2015-04-28)
33,538 reads
Windows Temporary Profile
Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc...
2015-04-28
811 reads
Use PsPing When Working in Azure IaaS
Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best...
2015-04-28
1,119 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our...
2015-04-28
23 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