Phil Factor offers a clever way to report on a SQL Server intrusion, with a query that shows a full narrative description of all the security-related changes that have been detected by a set of Redgate Monitor custom metrics. Read more
The best way to learn how to protect your databases from SQL Injection is to to see it in action and confront its consequences. This article tells the story of an attack on a vulnerable SQL Server REST interface, explaining how the attack unfolds, the mistakes that made it possible, and Redgate Monitor's role as the 'canary in the mine'. Read more
Phil Factor uses the default trace and a Redgate Monitor custom metric to alert you to unauthorized changes in security membership or permissions in any of your monitored databases. Read more
Phil Factor uses Extended Events and a Redgate Monitor custom metric to detect when the metadata of a database has 'drifted', meaning that a database object has been created, deleted or modified outside of the official change management process. Read more
If someone makes unauthorized changes to SQL Server configuration settings, it could compromise the availability, performance or security of your servers. Using using Extended Events, and a custom metric, in Redgate Monitor, Phil Factor offers a way to get an immediate notification of such changes, and investigate their cause. Read more
Phil Factor shows how to monitor for the errors indicative of a possible SQL Injection attack on one of your SQL Server databases, using a Redgate Monitor custom metric that uses diagnostic data from Extended Events. Read more
This article uses the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like Redgate Monitor to assess the impact of patching on the throughput and performance of your SQL Servers. Read more
