Speaking at PASS Summit 2013
I’m happy to announce that I have been selected to present
at the SQL PASS Summit in Charlotte, North Carolina this...
2013-05-22
683 reads
Cumulative Update – 11 for SQL Server 2008 SP3 Is Now Available !
The 11th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 11 contains all...
2013-05-22
649 reads
Wildcards and Indexes
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...
2013-05-22
1,728 reads
Connecting a service between Publishing and Consuming SharePoint 2010 farm
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Let’s today discuss about connecting...
2013-05-22
714 reads
Do you check to see if an SSIS package has been modified?
Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...
2013-05-22
2,725 reads
SSAS Event Type Calculation Dimension
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For...
2013-05-22
1,281 reads
Blocking – Capturing and Monitoring
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
703 reads
SSIS 2012 Deployment Fail
(Update: Part 2 focuses on clearing out the SSISDB by creating new stored proc based on the one used by the maintenance job. If your Maintenance Job is taking...
2013-05-22
18 reads
Digby’s Top 10 reasons you need a DBA
Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.
They can handle unexpected database growth...
2013-05-21
459 reads
There is currently a lease on the blob and no lease ID was specified in the request
I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well,...
2013-05-21
5,948 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
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
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