Do you have sensitive database rules?
You say “No” - well - I say “Yes”. All database rules are sensitive and have a sensitivity level. What does that mean? What is a sensitivity level? Where can I find it and can it be modified? Ok - a l...
Tune Your Queries with SQL Optimizer (Pt 1)
One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are: Minimize Response Time – End users who are interacting wit...
Spotlight on SQL Server Enterprise Tip: Reduce Noise Using Planned Outages
Naturally, it's VERY important to know when things are going wrong with our monitored instances. What's not helpful is the dreaded "False Positive." You know the scenario I'm about to describe. It's 0...
“License and Registration, please…” Spotlight
So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It ...
Measuring the Impact of Meltdown and Spectre Patching on your Databases
The new year kicked off with some big news on January 3rd, 2018 with the news of the Meltdown and Spectre chipset vulnerabilities. There are a lot of resources available to understand the details and ...
Agile Development: Advanced Code Review using Toad Code Analysis
Are you looking for a simpler, more effective way to carry out code quality reviews of all your Oracle PL/SQL code that takes subjectivity out of the equation and gives you the foundation for an autom...
Agile Development: Creating a simple Oracle PL/SQL unit test using Toad
Is your organization moving to agile development and DevOps and you now have to test your Oracle PL/SQL code and have no idea what to do? Your worries are over! With Toad for Oracle, creating some sim...
Agile Development: Accessing Database Objects from Version Control using Team Coding
Now you've successfully configured Toad's Team Coding with your preferred version control system, how does Team Coding actually work? Watch this video to learn how simple the process is and how Team C...
So you want to be a pro-active DBA?
During a recent installation of Foglight for SQL/Oracle the DBA announced how excited he was to get Foglight installed because he was desperate to become a pro-active DBA and stop being a re-active on...
Top 5 challenges of managing cross-platform databases
If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technol...
How to Avoid Extinction in the Database Evolution
Friends. Change is here. All of us DBAs are dealing with it. Look at the number of new database platforms. It’s relentless. They just keep coming. And we’re expected to take on any or all of them that...
Customer Conversation: Diagnose SQL Server Instances in an Availability Group
I recently spoke to a user of Spotlight on SQL Server Enterprise who wanted to be able to drill into the individual SQL Server instances that are participating in an Availability Group. The customer h...