If anyone had any doubts that a panel discussion where Brent Ozar and Pinal Dave would be answering attendees’ SQL Server performance questions would be a success, those were quickly dispelled during the blockbuster Ask the Experts session Quest hosted…
With the landscape of the tech industry rapidly changing, the adoption of and adjustment to application and infrastructure management presents a major challenge. As a result, companies are increasingly expanding and relying on a mix of relational and…
Why is SQL performance tuning so important to database management?
Because it can save you money big time. Bear with me and you’ll see how.
Most database professionals spend…
Application deployments are often delayed when related database changes are required. That’s because it still follows a traditional waterfall process, which can result in high technical debt and code defects that can cause application downtime. …
In the world of the DBMS, more than half (52%) of your fellow database professionals say that the cloud has a big impact on how they approach database administration.
“That many DBAs, database developers and architects can’t all be wrong,” you say. “Glad…
Here at Quest, we love winning awards – really, who doesn’t? But some awards feel more meaningful than others. We’re referring to the ones that come from customers’ ratings of Quest solutions, like the Best Software awards from G2. Quest was recently…
![Database development and management while working from home [IT and Covid-19]](https://www.quest.com/community/cfs-filesystemfile/__key/communityserver-components-secureimagefileviewer/communityserver-blogs-components-weblogfiles-00-00-00-00-37/8838.Blog_5F00_A_5F00_Database_5F00_development_5F00_and_5F00_management_5F00_while_5F00_working_5F00_from_5F00_home1100x500_2D00_US_2D00_LR_2D00_58547.jpg_2D00_100x100x2.jpg?_=637214671244876850)
Just when you thought your database development was running on all cylinders, **BAM** the pandemic hit, and now your database developers are practicing social distancing and working from home (WFH).
As shelter-in-place orders have spread across entire…
We’re all in the same global boat. In response to COVID-19, and to curtail the spread and keep employees and the general population well, companies worldwide have suddenly sent their employees home to work.
The pursuit of historical data and its analysis is a significant part of the functionality that Spotlight on SQL Server users have come to expect and continue to seek improvements upon. In the past, users have expressed the need for ad-hoc query capability…
Database cartridges allow you to monitor your database instances. But you can boost the power of your monitoring by adding one or more of these features.
A Spotlight on Foglight – How Spotlight Users can ease their way into Foglight
What’s that you say? You think it may not be appropriate that a technology blog dive into politics?
Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.
Administration options are available…
We all remember Abbott and Costello’s skit “Who’s On First?”. If you haven’t seen it, I highly recommend you pop over to YouTube and give it a watch. It has become one of the legendary classic comedies of all times, with Costello not knowing baseball…
Spotlight Cloud is a cloud hosted database monitoring and diagnostics application providing DBAs with diagnostic tools to quickly identify and help resolve performance issues. The Workload Analyzer of Spotlight Cloud is a very robust query evaluator tool…
We've all been there, the dreaded ticket that comes across our inbox. Always light on detail, just a single sentence: "The database server is slow." No five words bring as much fear, uncertainty and doubt to a DBA than those (well, maybe…
For a Happy Halloween and a happy time anytime in Toad! Enjoy these five sugar free Toad Treats!!
It is a foregone conclusion that performance monitoring is part and parcel of managing a database instance once it is in production. But what about pre-production? Especially when the instance itself is reaching critical phases of testing and quality…
In an earlier blog, I wrote about a company’s success with Quest’s flagship SQL Server monitoring and diagnostics solution – Spotlight Enterprise. The blog detailed a customer success story and revealed detailed use cases explaining how this application…
It never gets old hearing about how Quest Performance Monitoring solutions offer actionable insight to mission-critical systems. Upon visiting a customer for a 'health check' of their environment, we had the pleasure of learning about two distinct ways…
Spotlight on SQL Server provides excellent real-time monitoring, workload analytics and more for SQL Server. You can download the complete software for a 30-day trail on as many systems as you'd like. A previous post walked through the installation
…Apologies to Rogers and Hammerstein; but the title fits. In addition to listening to the scores of old musicals, one of my hobbies is watching the weather. I have about 20 years of weather data in a MariaDB database - for those unfamiliar with OpenSource…
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 had successfully created a connection to the Availability…
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 lot of questions, so let's start…
In Part 1 of this blog post, I review how you can get an evaluation copy and explain the various integration points from Quest’s monitoring solutions – Foglight and Spotlight Enterprise. You can find it here -> https://www.quest.com/community…
DBAs are all kinds of awesome. We’re smart. Stylish. Capable of administering databases! Who else can say that? Yeah. Just DBAs. Our technical wizardry is second to none.
Because we’re awesome.
And guess what today is. It’s our day. That…
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 03:00 and you're sleeping soundly and dreaming of the…
