SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.
2019-05-14
Introducing a new user interface, enhancements and new features, you can now try the latest version of Data Masker for Oracle. Deliver production like data to development teams while ensuring that confidential data remains protected.
2019-04-26
Phil Factor uses SQL Clone, PowerShell and Visio to build a live 'clone network' diagram showing when there was last activity on each clone, and the number of object changes made to each one, alongside useful metadata such as the clone and image sizes, who created them and when.
2019-04-05
This article explains the Azure-tailored metrics and alerts in SQL Monitor that track use of the limited compute resources available to an Azure SQL Elastic Pool, and to each of the databases in it.
2019-04-05
Using broad SQL Server monitoring can instantly alert you to unusual activity or patterns across your entire estate, letting you can act fast to resolve problems and keep your systems online, secure, and compliant. Read our new SQL Server security white paper today and start using your monitoring to its fullest.
2019-04-05
SQL Prompt is a tool I use all the time for code completion and code formatting tasks, to the point of it feeling very wrong to write a query without it. Write a SQL Statement with a JOIN, and it auto-suggests the ON criteria.
2019-03-30
In the R&D division of Redgate, Foundry, we’re working on a new tool, SQL Census, in an effort to make your SQL Server permissions more manageable by seeing who has access to your servers and restructuring existing access rights into a simpler and more compliant format.
2019-03-30
Redgate invite you to participate in their survey on database modeling. In order to inform their future product decisions, they'd like to better understand the needs and motivations behind the use of such tools.
2019-03-30
It’s been forgotten about and neglected for few years but I’ve decided to dust...
I am honored to announce that I have been renewed as a Microsoft MVP...
By Rohit Garg
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
Comments posted to this topic are about the item How a Legacy Logic Choked...
I have tried a number of times to export and then import my SSMS...
Hi I need to connect to a SQL server via FQDN - that is...
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers