It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.
2013-05-13
8,102 reads
This article will show you the importance of Indexed Views and how they can help performance.
2013-05-10 (first published: 2010-11-16)
24,507 reads
This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.
2013-05-10
2,892 reads
I have heard about parameterization for SQL Server queries, but what is Forced and Simple Parameterization and which one should I use for my SQL Server database?
2013-05-10
5,199 reads
We’re putting together a free eBook of 50 tips for Azure Storage, if you’ve got tips that you’d like to share we’d love to hear from you.
2013-05-09
684 reads
If you are using replication in SQL Server, you can monitor it in SSMS, but it makes sense to monitor distribution jobs automatically, especially if you can set up alerts or even set up first-line remedial action when a problem is detected. Francis shows how to do it in T-SQL as an agent job.
2013-05-09
2,775 reads
Join us for a free day of SQL Server training and networking in Atlanta on May 18th.
2013-05-08
2,172 reads
To meet our database configuration standards we want to make sure that we have only one database transaction log file and more than one data file. In this tip we look at how this can be done using a policy.
2013-05-08
2,280 reads
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
2013-05-07
10,904 reads
The easiest ways to maintain and manage slowly changing dimensions is using Slowly Changing Dimension Transformation in the data flow task of SSIS packages.
2013-05-07
3,098 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Comments posted to this topic are about the item URL Safe or Not?
Comments posted to this topic are about the item No Defaults Passwords Ever
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers