Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.
2019-05-14
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
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers