Reblog: June 14 to June 20
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-21
852 reads
Key Change
I love music. In fact, I like to think that I’m a student of music – although anyone who has heard...
2013-06-21
1,012 reads
Managed Service Accounts - The Saviour for the Domain-based SQL Server Service Account?
For those Database Administrators seeking to lock-down security related to a Service Account(s), there is an option starting with Windows...
2013-06-21
2,249 reads
Huge collection of Free Microsoft eBooks
I must share it, there are many useful resource
http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server.aspx?Redirected=true
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more.aspx
Thank you , Eric
2013-06-21
1,967 reads
use Table Variables in transaction
when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL
Because table variables...
2013-06-20
2,788 reads
TRY, CATCH, and Transactions
The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood,...
2013-06-20
2,413 reads
Exploring Excel 2013 for BI Tip #8: Adding Calculated Measures
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-06-20
934 reads
TechEd North America 2013 videos online
Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free! What a...
2013-06-20
800 reads
Disaster Recovery’s big brother Operational Recovery
I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...
2013-06-20
945 reads
SQL Server Running Slow
A user calls to say the app or server is slow today. Here’s a quick summary of how I get...
2013-06-20
876 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