SQL Server Memory Usage Query
Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.
2021-05-03
SQL Monitoring
Fixing "Login failed for user" error in SQL Server
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2025-12-31 (first published: 2020-11-24)
55,478 reads
SQL Server Licensing and SQL Monitor
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out.
2020-07-06
Easily manage SQL Server licensing with SQL Monitor 10.1
SQL Monitor 10.1 now gives you a comprehensive overview of your SQL Server licensing, so you know which licenses are in use, and which versions are on which servers. This simplifies license auditing and lets you unearth misconfigurations that could potentially cost you money. The new version also integrates with Microsoft Teams and Splunk, and supports complex Active Directory environments.
2020-07-02
Cloud adoption rates see increase in 2020
Usage of Microsoft Azure is up by 15 percentage points compared to 2019 and it remains the most-used cloud platform. This is possibly as a result of increased remote working and the need to no longer rely on physical machines. For more insights into 2020 trends and challenges, download the State of Database Monitoring report here.
2020-06-26
When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation
Phil Factor on the fill factor, pages splits and index fragmentation, and how SQL Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues.
2020-06-24
What is the impact of remote working on estate management?
Distributed workforces have very quickly become the norm. The 2020 State of Database Monitoring survey explores the impact of remote working on estate management and how organisations are responding. You can read the full findings in the free report, here.
2020-06-19
Challenges and trends for Database Monitoring in 2020
Nearly 1000 database professionals took part in this year's State of Database Monitoring survey. Providing insights into how they monitor their estates, the technologies they work with, what their biggest challenges are, and emerging trends for 2020. For the detailed analysis of the responses, download your free copy of the report.
2020-06-09
2020-06-01
What’s changed for database monitoring this year?
Have your say on the state of database monitoring in 2020. In this latest blog, Redgate’s Jamie Wallis reviews what we discovered from last year’s survey and how you can define the insights for 2020. Tell us and you can get early access to the report plus be entered for a chance to win a $500 Amazon voucher. Read the blog to find out more:
2020-04-22
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
SQL Server Certificates
Comments posted to this topic are about the item SQL Server Certificates
Connect an Azure Function to Azure SQL database Using a Managed Identity
Comments posted to this topic are about the item Connect an Azure Function to...
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers