You don’t need to be a sysadmin
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,324 reads
Availability Group DMVs Reporting Incorrect Values
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism for AlwaysOn Availability Groups. Check out the many new...
2016-03-10
20 reads
Availability Group DMVs Reporting Incorrect Values
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism...
2016-03-16 (first published: 2016-03-10)
1,819 reads
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
20 reads
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
7 reads
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...
2016-03-10
107 reads
New developer build of SQL Code Guard released
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
1,021 reads
Update Your Scripts!
I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:
As...
2016-03-15 (first published: 2016-03-09)
3,022 reads
Quick PS script to get SQL Server Configuration Aliases - Syndication – WaterOx Consulting
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
803 reads
Notes from SQLSaturday Tampa 2016
Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...
2016-03-09
619 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
Alamat BCA KCP Penjernihan Telp:08218520154
WhatsApp CS 628218520153 Jl. Penjernihan I No.23, RT.2/RW.7, Bend. Hilir, Kecamatan Tanah Abang, Kota...
Alamat BCA KCP Tanah Abang 2 Telp:08218520154
WhatsApp CS 628218520154 Jl. Tanah Abang II No.49 & 51, RT.1/RW.4, Petojo Sel., Kecamatan...
ALAMAT BCA KCU GUNSA 45 Telp:08218520154
WhatsApp CS 628218520154 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
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