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 […]
2020-11-24
46,770 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
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...