When dealing with large number of connections, the power and advantage of PowerShell API can be leveraged to manage, automate, and administer Spotlight configuration. The efficiency gains obtained thr...
All is well. Megan is having a good day. She’s a SQLServer DBA and her environment is humming along. Then…. someone drops a critical table bringing efficient data retrieval to a screeching halt. Now w...
![Server Compare sets itself apart [Toad for SQL Server]](https://s38063.pcdn.co/wp-content/uploads/2025/09/fi-medium.jpg.optimal.jpg)
Are you managing a large SQL Server environment and looking to migrate changes from Development through test and production, deploy and/or consolidating SQL Servers, or more easily manage your standby...
There are a couple easy, free ways to get VMware metrics collected by Foglight for SQL Server. This first part shows the easier way. When setting up the monitor for SQL Server, you can select (or not)...
Just like most people’s goal towards incorporating more raw food into their daily diet, accessing and manipulating raw data is very much a coveted functionality. The Spotlight Statistics Repository da...
Spotlight Enterprise 12.4 comes with some neat features you do not want to miss! Query Execution Plans available when needed the most: The Workload Analysis and the Query Execution Statistics drilldow...
We all get excited when our cell phone plan includes so called “Unlimited Data.” But, you know what happens if we push your luck. That’s right; we start to experience performance issues and get toss...
Imagine this.... you're hosting a Holiday Party...and the phone rings. You answer and the person on the other end says with a tense voice, "I'm sorry but we will be unable to deliver your beer, wine, ...
We’re excited to announce that with Spotlight version 12.3, the Plan Visualizer feature now includes several new enhancements. In my last blog, I covered the Plan Visualizer feature included in versio...
Toad World was originally launched back in 2006 as a free, exclusive resource for all things Toad and that’s as true to today as it was back then. It has become a valuable complement to the many Toad ...
A really great feature in Azure SQL DB went GA today. That feature gives you and SQL DB the ability to automatically fail databases over to a Secondary replia, without having to configure your applica...
Setting up Transparent Data Encryption, or Backup Encryption, or basically anything else where you need to restore a certificate to another SQL Server instance can get tricky as soon as you run the in...
