Learn how you can get alerts when you centralize the Event log. This is part 2 of the previous article "How to centralize your SQL Server Event Logs."
2014-05-09 (first published: 2012-05-24)
7,462 reads
In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.
2011-10-26
3,444 reads
It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.
2011-09-01
3,959 reads
This script quick tip for those who will accurately monitor sessions on SQL Server.
2011-08-16 (first published: 2011-08-02)
1,686 reads
Using linked connections you can collect system information on your Oracle server from SQL server.
2011-06-06
3,482 reads
Learn how you can centralize the Event log data for your servers using a process that Geoff Albin has been using for over 10 years.
2014-05-02 (first published: 2010-11-08)
14,176 reads
Your application code may look neat and clean, and you are using a sound Object-relational Mapper, but when you put the pedal to the metal, you're not getting the performance. The time has come to lift the hood and see what SQL is being generated by the ORM, and what part of your code is causing the bottlenecks. The effect can be spectacular.
2010-11-05
3,304 reads
Learn how to use a free utility to quickly monitor the uptime of your SQL Server instances.
2010-06-23
8,433 reads
Extended events provide DBAs with a new lightweight tool to monitor SQL Server performance.
2010-04-19
2,712 reads
In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.
2011-07-22 (first published: 2010-03-31)
15,980 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