SSIS Basics: Introducing Variables
In the third of her SSIS Basics articles, Annette Allen shows you how to use Variables in your SSIS Packages, and explains the functions of the system-defined variables.
2012-08-20
3,122 reads
Articles
REPLACE Multiple Spaces with One
Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method from MVP Jeff Moden.
2012-08-17 (first published: 2009-11-16)
65,460 reads
Row Count Plus Transformation
As the name suggests we have taken the current Row Count Transform that is provided by Microsoft in the Integration Services toolbox and we have recreated the functionality and extended upon it. There are two things about the current version that we thought could do with cleaning up Lack of a custom UI You have to type the variable name yourself In the Row Count Plus Transformation we solve these issues for you.
2012-08-17
3,183 reads
Tell Us What You Think
Red Gate needs your help! Fill in our quick survey to help us improve our products – as a thank-you, you'll have the chance to win a Kindle Touch.
2012-08-17 (first published: 2012-08-13)
2,015 reads
2012-08-16
7,063 reads
SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages
Marcin Policht explores a method of running SSIS packages that relies on the dtexec.exe utility.
2012-08-16
2,694 reads
Red Gate’s new custom metrics site - with a little help from our friends
With contributions from MVPs and the SQL Server community, the SQL Monitor team at Red Gate has put together a custom metrics site, SQL Monitor Metrics, to accompany the release of SQL Monitor 3.2. The site hosts T-SQL scripts which can be imported directly to SQL Monitor for custom metric monitoring.
2012-08-15
873 reads
Implement Continuous Integration In Your Software Project
Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.
2012-08-15
2,241 reads
PASS Data Architecture VC presents Louis Davidson on Designing for Common Problems in SQL Server
On Thursday August 16th 12PM noon Central, Louis Davidson will do a design and code review of several common patterns of solving problems that a typical programmer will come up against in SQL Server.
2012-08-15
1,182 reads
11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
2012-08-14
7,678 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