Database Management Blog

Welcome to our blogs

To help our user community locate the latest information about trends that are impacting their primary interest, we organize our community blogs by solution area.

  • Let's backup in Google storage with LiteSpeed for SQL Server 8.7!

    We know that from LiteSpeed for SQL Server 8.5 we can backup to Azure and  Amazon S3.Now that LiteSpeed for SQL Server 8.7 is out, we can also backup to Google storage.Google Cloud Storage is unified object storage for d...
    • 11 Jun 2018
  • Litespeed for SQL Server 8.7 is out now!

    Good news! The new version of Litespeed (v8.7) is out now!This version brings a couple of new features - Cloud Backups to Google Cloud Storage, and new Microsoft AES Encryption support. Until now cloud backups to Azure and Amazon S3 were possible. In...
    • 7 Jun 2018
  • Toad TSR, Best Tip Ever??

    Well maybe not the best tip ever, but certainly one of the most popular in Toad Tips and Tricks sessions. The Toad Script Runner (TSR), not terminate and stay resident for you old time IT folks, is a great feature in Toad that allows you to execute l...
    • 6 Jun 2018
  • Checking Query Plans for Columnstore Index Candidates

    A customer asked recently if there is a way to find SQL that references objects that are a certain size. They are evaluating historic queries on tables to find possible candidates for conversion to columnstore indexes. One option is to use the "Scan ...
    • 25 May 2018
  • Dude, You’re Getting a Del…ta Migration

    Eliminate data replication risk and reduce database downtime with Quest SharePlex. Learn how Dell was able to reduce downtime from 20 hours to 40 minutes.
    • 22 May 2018
  • AOUG Konferenz 2018 – "30 Jahre AOUG"

    Quest Software stellt die neuesten Produktversionen auf der AOUG Konferenz 2018 in Wien vor. Erfahren Sie von 11. bis 12. Juni, wie Sie mit unseren Lösungen die Zeit zur Entwicklung und Verwaltung Ihrer Datenbanken reduzieren und so innovativer sein können.

     Wir präsentieren Ihnen unsere Produkte rund um Oracle:

    • Toad – das preisgekrönte Allzweckwerkzeug für DBAs und Entwickler
    • SharePlex…
    • 17 May 2018
  • Is Your Environment As Complex As This? SharePlex Can Help!

    IT environments are complex like the formulas on the pages of Stephen Hawking's thesis about expanding universes. Feeling overwhelmed? SharePlex can help.
    • 10 May 2018
  • Spotlight Data Collections

    Spotlight offers a variety of performance health metrics with diagnostic drilldown screens for each problematic area of your server. Each drilldown screen provides detail data to help you diagnose and isolate application problems. Spotlight provides the users the capability to customize the frequency of data collection in addition to the option of storing historical date in Spotlight’s Repository database.

    In order…

    • 7 May 2018
  • Toad for Oracle 13.0 is already available!

    Let's play a game! Open Toad for Oracle and go to Help | About. Which version do you have installed?

    Peter: 12.10
    Alicia: 12.11
    Diane:12.12

    Ok! that is fine (although you can always go for the latest version of course!).

    Caveman: 9.7! 

    Me: hummmm... ok!In this case there isn't any other option than upgrade. There are lot of reasons...let's see some of them:

    • This version isn't supported by Quest
    • Toad for…
    • 4 May 2018
  • DBAs Honor International Firefighters’ Day

    No DBA would equate our work to that of a firefighter, but the fires we fight often rely on vital database performance and monitoring. Learn more.
    • 3 May 2018
  • How Can Monitoring Help a DBA Participate in DevOps?

    DevOps is everywhere, seemingly permeating every aspect of IT.  The way that companies are building and managing their applications has become increasingly agile, and many of the comforts that DBA's used to rely on are no more.  Specifically, DBA's used to find comfort in knowing that very rigid change control processes would limit the likelihood that a production database server would experience a change, potentially…

    • 1 May 2018
  • SharePlex and Transaction Relationship

    How hard is it to setup replication?  Most information out there makes it simple since they are high-level replication setup.  The instructions you find are: Installing the software Starting up the software Run preparation for replication ...
    • 25 Apr 2018
  • Tune Your Queries with SQL Optimizer (Pt 2)

    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/b/en/posts/tune-your-queries-with-sql-optimizer-part-one-why-tune-and-where-can-i-get-it

    This blog (Pt 2) is intended to familiarize you with the SQL Optimizer interface…

    • 24 Apr 2018
  • Diagnosing Historical Sessions in SQL Server TempDB

    In the recent 5.7.5.50 release of Foglight for SQL Server, a change was made to the TempDB drilldown. Specifically, the Sessions tab would formerly show the current sessions, regardless of the time range selected on the dashboard. Now, it will allow you to drilldown to the sessions that had activity in TempDB during the desired time range.

    To start, drilldown to the Databases dashboard, select TempDB (1), select your…

    • 19 Apr 2018
  • Toad for Db2 - Editing of PDS-member on a z/OS subsystem

    With the last release of Toad for Db2, a new capability was introduced. The user can now edit any PDS member on the host in the SQL editor of Toad: simply open an existing member and load it into the editor.

    For a longer time you could already upload scripts with SQL statements (in particular DDL statements from advanced alter or compare) or Db2 utilities via the remote job execution feature in Toad as a PDS member. As…

    • 19 Apr 2018
  • Are you following the best practice recommendations for SQL Server Database Backups? More about automated restore!

    Are you following the Best Practice recommendations for SQL Server Database Backups? If the answer to this question isn't "yes, without any doubt" then we need to act! 
    For example, we need to be absolutely sure that the backups we are doing can be properly restored and we must verify that we can restore them with all the options and conditions we need to use during a planned or a real disaster recovery scenario…

    • 18 Apr 2018
  • Transformation, Partitioning and Selective Replication with SharePlex

    Customers often ask “Can SharePlex do transformation?”.  Often, what they’re really asking is, “Can SharePlex selectively replicate rows or columns?” or “Can SharePlex move data from one column in the source, to a different column in the target?”

     

    For Oracle to Oracle replication, the answer to all three of these questions is, “Yes!”  For Oracle to all other targets…

    • 17 Apr 2018
  • Do you need to refresh any database on a test environment or just test restores? See how Automated restore can help you!

    In this post we are going to talk about the Automated restore option.
    This feature restores the most recent full disk backup created with LiteSpeed and optionally differential and transaction log backups.
    Where is the last backup located? What is the file name of the most recent backup? You don't need to ask this anymore as LiteSpeed will scan the folders/subfolders you specify for you.
    As you can imagine this is very…
    • 12 Apr 2018
  • Winning the Blame Game – Go, DBAs!

    Let Foglight easily identify where performance degradation originates, diagnose and resolve issues, plus automate performance metric analysis and responses fast to prove'em wrong!
    • 9 Apr 2018
  • A new license key format in Litespeed 8.6

    From v8.6, Litespeed has introduced a new license key format within the product. Your old key will still work for the foreseeable future, but there is now the option to enter either a newer format v8.6 key, or the existing and older format v8.5 key.

    Upon entering your key in v8.6, you'll see a new option, highlighted below:

     

    If you do have an existing key, please select this option, and you'll see a box appear for…

    • 6 Apr 2018
  • Which DBA Zombie Are You?

    Is your database performance scary? Learn how to survive when the DBA monsters emerge, check out this on-demand webcast.
    • 4 Apr 2018
  • DevOps in der Datenbankentwicklung 3/3

    Toad DevOps Toolkit

    Quest hat über die letzten zwei Jahre mit vielen Kunden zusammengearbeitet, um besser zu verstehen, welche Herausforderungen bestehen, die Oracle Datenbankentwicklung in ihre DevOps Infrastruktur zu integrieren. Die Befragung fokussierte sich auf Mitarbeiter, Prozesse und Technologien, die eine Rolle für die erfolgreiche Implementierung von DevOps spielen.

    Quest stellt in diesem Umfeld ein…

    • 27 Mar 2018
  • DevOps in der Datenbankentwicklung 2/3

    Wo helfen die DevOps Datenbanktools?

     

    Verwaltung von Codeänderungen - Die Versionskontrolle spielt in Datenbankentwicklungsprojekten eine andere Rolle als in der Anwendungsentwicklung. Sie ist jedoch eine gute Möglichkeit zur Nachverfolgung von Änderungen an der Data Definition Language (DDL) in allen Schritten während des Verfahrens. Die Nachverfolgung von Überarbeitungen der gespeicherten Funktionen und Prozeduren…

    • 27 Mar 2018
  • DevOps in der Datenbankentwicklung 1/3

    Brauchen Sie DevOps?

     

    Wenn Sie noch überlegen, ob DevOps für Ihr Unternehmen sinnvoll sein kann, stellen Sie sich einfach die folgenden Fragen:

    • Verlangt das höhere Management von Ihnen, Ihre Lieferfristen und Prozesse zu beschleunigen?
    • Kommt es in Entwicklung, Qualitätssicherung und Lieferung zu Verzögerungen?
    • Gibt es im Anwendungslebenszyklus viele manuelle Prozesse, die die Bereitstellungszeit…
    • 27 Mar 2018
  • IT Telepathy: Predicting Database Migration Trends

    By reviewing the results of a recent DBTA survey, we can see what you and other DBAs dealt with last year – and what’s coming your way soon.
    • 21 Mar 2018