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
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Hi all, I am running the following query in SQL, trying to export some...
Please suggest practice on SQL Server RLS On the database level, defined users with...
Ask SSC