Data Mining Part 22: Analyze the Data Mining Data with Excel
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
How Often Does Production Drift?
Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.
The Salesforce Platform: The Return of the Citizen Programmer
The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?
Generate SSRS reports from a SSIS Package
Learn how to invoke SSRS reports from an SSIS package after the data load is completed.
Real World T-SQL Tricks
This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.
Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask
It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.
Achievement Unlocked: Balance 0
Steve Jones completed a task this year that he's rarely completed in the past.
Distribution Database Migration
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
Monitoring Azure SQL Database
Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.
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