Up until now, it has been a curiously frustrating search to find out the basics of SSIS, fast, in order to get up and running quickly. No longer, as Annette Allen comes up with a simple introduction for the rest of us.
2012-06-05
3,995 reads
The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.
2012-06-04
8,432 reads
SQL in the City the one day free SQL Server training event is back in London this July. Join fellow SQL Server professionals for 5 hours of technical presentations on key issues for SQL Server developers and DBAs delivered by top MVPs. The event also offers you the chance to network with users passionate about SQL Server and the chance to see the latest Red Gate tools and meet the developers who built them. Find out more and register today.
2012-06-04 (first published: 2012-03-09)
7,499 reads
SQL Server 2012 Integration Services parameters introduce a new way of dealing with package development, deployment, and execution. In order to truly appreciate their relevance, it is necessary to take a look at the new Project Deployment Model.
2012-06-04
2,551 reads
The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.
2012-06-01
6,046 reads
This article demonstrates how to use US Census' TIGER/Line shapefile to display CNN-style map in Reporting Services.
2012-06-01 (first published: 2011-03-07)
116,647 reads
SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will find out something new from reading it.
2012-06-01
5,760 reads
A quick how-to on configuring SQL Server Agent alerts to manage file space usage.
2012-05-30
15,713 reads
I often see questions online where someone wants to find out who started a trace, when tempdb last had an autogrow event, or when the last full backup for master occurred. Since these and other events are captured by the default trace, but the default trace only keeps five 20MB rollover files by default. This means that the event you are after may no longer be there, depending on how long ago it was and how busy your server happens to be. Unfortunately, people often need to find this information well after the fact.
2012-05-30
2,914 reads
This article will show you how to configure the FTP task in SSIS to recieve files from remote server using the FTP protocol.
2012-05-29
11,424 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item 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