SQL Server in Luxembourg
The SQL Server Luxembourg User Group will be holding its first major event of 2012 on Tuesday 17th January, starting at 4:30pm. The venue will be Microsoft's offices at Cloche d'Or.
2012-01-02
351 reads
Articles
Querying SQL Server Agent Job Information
Is there an easy/automated way to get information on SQL Server Agent jobs instead of connecting to each server and manually getting the information through the SSMS GUI?
2012-01-02
3,521 reads
A Simple way of Automating Scripts
Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.
2011-12-30 (first published: 2009-07-30)
51,582 reads
SQL Saturday #104 - Colorado Springs
Start your 2012 off right with a free day of training in Colorado Springs. Bring the kids as well, as the venue is very family friendly.
2011-12-30 (first published: 2011-12-06)
1,125 reads
Understanding the SQL Server SELECT @@VERSION command
Check out this tip to learn about the SELECT @@VERSION command in SQL Server.
2011-12-30
4,818 reads
An Introduction to Integration Services log providers
SSIS features log-providers that can write to five different types of logging destinations; three of them are files, one is the 'dbo.sysssislog' table, and the last is the Windows Event Log.
2011-12-29
4,372 reads
2011-12-29 (first published: 2010-06-09)
8,916 reads
Great SQL Server Debates: Lock Pages in Memory
There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.
2011-12-29
2,878 reads
Writing New Hash Functions for SQL Server
This blog, explores ideas for extending SQL Server with new, fast hash functions. As will be shown, the high speed, built in functions CHECKSUM and BINARY_CHECKSUM are not always optimal hash functions, when you require the function to spread data evenly over an integer space.
2011-12-28
2,595 reads
Mirroring and different sector sizes? BAD IDEA!
Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.
2011-12-27
4,691 reads
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