Connections in Toad Data Studio
In this tutorial, you will discover how to establish connections to various data sources within Toad Data Studio. You will see how to work with the Navigation Manager to create, view and manage your c...
How to compare multiple database schemas in Toad Data Studio
In this tutorial video we will learn how to compare multiple database schemas using Toad Data Studio. Toad 1.0 Beta Release offers a homogeneous schema compare supporting multiple data sources incl...
Git Version and Source Control Integration in Toad Data Studio
Learn about GitHub, GitLab, Bitbucket integration with Toad using diverse data sources including Oracle, SQL Server, SAP ASE, SAP IQ, and SAP Anywhere. ...
Spotlight Enterprise Workload Analysis
While your database handles requests from end-users, it starts to consume various resources. With increased number of requests, the database may suffer from resource waits. Excessive wait types and ti...
Monitoring Always On Availability Groups and Always On Failover Cluster in Spotlight
SQL Server provides us with a number of high availability and disaster recovery solutions. Two of them are Always On Availability Groups and Always On Failover Cluster offerings. In order to leverage ...
Deploy, Customize and Schedule Spotlight Reports in SSRS
Spotlight reports are designed in SQL Server Report Definition files (RDL) and stored in the local installation folder of Spotlight client application making them accessible to Spotlight users. By def...
Manage and automate Spotlight by PowerShell Command Line Access
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...
Introducing user level access with Spotlight 13.0
Spotlight 13.0 introduces a brand new feature of managing access to monitored connections at the user level. It provides the ability to assign or deny a user access to a set of connections that have b...
How to Query the Spotlight Statistics Repository Database
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 New Features
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...
Spotlight Federation Steps
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...
Spotlight 12 Plan Visualizer – Enhancements
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...