checkmarkIT

Stephen Wild is the technical director for Checkmark IT. Stephen has more than 20 years of experience in the IT industry and is an HPE Master Accredited Solutions Expert (MASE).

Stephen began his career at a second-hand refurbished computer company, where he assisted with sales and fixing basic Windows issues while also rebuilding and repairing computer equipment before moving to account management and becoming a technical account manager.

Following four years in account management roles, he moved into a pre-sales role aligned to the company’s commercial division, focusing on storage - which became his area of specialism - particularly around 3PAR mid-range and high-end 10K and 20K systems.

One of the most significant projects Stephen has worked on during his career is the Transport for London 10K 3PAR system, designed to help measure passenger numbers during the London 2012 Olympic Games. During this project, he designed and scoped the array to address the business needs and capacity required by the customer, alongside HPE.

All authors

SQLServerCentral Article

All flash vs adaptive flash storage - which is right for my organisation?

Many data professionals might not worry about hardware, but someone needs to watch for changes and improvements in technology. Learn about how flash storage technology has changed and how this might be useful if you still need to build a fast database server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-06-25

2,905 reads

All authors

Blogs

Architecting Zero Downtime Deployments–Day of Data Boston

By

Here are the resources for my talk at Day of Data Boston. Slides –...

The Book of Redgate:A Prehistory

By

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

When the evidence names the database, it says so. When it doesn’t, it stops....

Read the latest Blogs

Forums

Today's AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Today's AI

Split Large Queries in Athena with a Simple Modulo Trick

By Rahul Gupta

Comments posted to this topic are about the item Split Large Queries in Athena...

Finding Trailing Spaces

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Trailing Spaces

Visit the forum

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        Sally
I 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