• 16 Jan 2017

    Using SharePlex Efficiently – Only Replicate the Data You Need

    One of the more attractive features of the SharePlex data replication tool is its ability to be very selective about the data it replicates. If you’re looking at workload offloading, making data more available to your users, building data...
    • 13 Jan 2017

    Spotlight 11.7.1 Is Now Available For Download

    Hear ye, hear ye! Spotlight version 11.7.1 is here! There are several fixes and a few enhancements included in Spotlight 11.7.1. The product fixes included are listed below for your reference: ID 6097 - Resolved an issue with the Spotlight Connection Manager, where Spotlight Connection Manager sometimes selected the wrong connection type to delete in cases where the request to delete a connection and the name...
    • 6 Jan 2017

    Use SharePlex Analyze to Find Out How Your Application REALLY Works

    As a DBA, how many times have you asked yourself, your application team or your vendor, “What tables does this application update?” or, “How many changes does the application make to this table?” or, “What’s the no...
    • 6 Jan 2017

    Data, Information and Knowledge

    Nowadays with such a growing interest in data analysis / data science, there are abundant articles and material covering the skillset necessary to master those disciplines. Virtually, any blog, magazine, book, or specialized web site or portal descri...
    • 4 Jan 2017

    May the Shard be with You!

    Oh how I remember when the first Star Wars movie came out, all the action, adventure and of course the lightsaber. Who didn’t want a lightsaber? You could slice your way through anything with it. Well I never did get one, but what I did get was SharePlex and that’s just as good. Using SharePlex’s ability to slice data at the row level or the column level is just as exciting to me. This ability is called...
    • 4 Jan 2017

    No More Large Databases for the Storage Cart

    I have some very exciting news. The new Storage cartridge is coming out. Version 4.4. Its due to be released very soon! The big news for this release is that we are going to migrate the database that has always been a part of ...
    • 4 Jan 2017

    Why be NORMAL?

    When monitoring databases for performance , we certainly want to understand things like CPU spikes, memory pressure, I/O latency, and the like. If we see this type of performance, the next step is to take a closer look and attempt to find out what's causing it, right? But taking a step back for a moment, have you ever realized one of the first questions you are often asking yourself when you notice performance deviations...
    • 29 Dec 2016

    Excel Puzzler - Problem Solved with AverageIf Function

    I could write SQL to solve this problem.. but the data was in Excel. I pulled pricing and mileage data from several car for-sale sites and dropped it in an Excel sheet. Columns include year, price, kilometers (mileage), etc. Here is a snippet of the data: Now I had some data in Excel that would mimic how it would be stored in a relational database but I wanted to analyze it. I wanted to get the average price and...
    • 23 Dec 2016

    Spotlight on SQL Server Enterprise: Just the Facts! Part 4: What is the Alarm Setting?

    As we continue our navigation of Spotlight on SQL Server Enterprise and we can diagnose an alarm that triggers. Let us see what setting caused an alarm to trigger. The fact is when you start monitoring an Instance it is assigned the preset “Factory Settings. Those settings may need to be adjusted it may be a good practice to familiarize yourself with the setting values and determine if you should adjust them to...
    • 22 Dec 2016

    Spotlight on SQL Sever: Just the Facts! Part 2: Acknowledging Alarms from Spotlight Today

    Just the facts! Part 2 Acknowledging Alarms in Spotlight on SQL Server Enterprise Now that we have establish a view of the facts let’s see what we can do with them. Some on these alarms are set by default to be acknowledged before they will clear for the alarm list. I would like to take this opportunity to walk to through the process of “acknowledging” these alarms from the “Spotlight Today”...
    • 22 Dec 2016

    The 5 Ws of Your Oracle Transactions with No Database Performance Impact

    When a large customer appreciation company needed to categorize their Oracle auditing data by region, SharePlex came to their rescue. They were already using SharePlex’s Change History feature to track the userid’s, timestamp...
    • 20 Dec 2016

    Quest Customer Story - Don't Wait Days for Your Data - Cut Out the Middleman

    A large educational Institution recently approached us with a problem. Their Student Information and Financial databases were in Oracle, and a data warehouse containing extracts from both of these used for decision making, including opening more sections of a class or cancelling a class, was in SQLServer. Extract-Transform-Load process extract data from the Oracle databases, create “staging tables” in SQLServer...
    • 20 Dec 2016

    Toad Turnpike: Real Stories from the Road

    Off-roading, Maps, and Nine Gray Hairs We all tend to spend most of our time on the “turnpike” of a product’s feature set: you know, the “power” set of its features that get us to many of our endpoint destinations within...
    • 19 Dec 2016

    Backing up your Databases

    It doesn’t matter what type of organization you are; small, big, public or private – everyone has a database of some description. Databases come in many forms from Microsoft Exchange, Oracle, SQL to a litany of lesser known databases. The database, for many companies, is the ‘crown jewel’ of their data. More often than not, it contains critical customer, financial or business transaction data....
    • 15 Dec 2016

    Quest Customer Story - Use SharePlex to Ensure Availability of Your Master Data

    How Available Is Your Master Data? A major financial institution recently completed a project to consolidate all of their employee information, including credentials for building and online access, into a single database. Of course, they protected their database with Oracle RAC and Oracle DataGuard, and had redundant infrastructure in their data center. However, they needed to address outages that might impact their...
    • 8 Dec 2016

    Quest Customer Story: Large Charity Organization leverages Foglight's Custom Dashboarding and Saves Hours Traversing Growth Trend Data

    The Database Administration Manager communicated his need to efficiently gather and report upon growth data in the QA and Production environments. The project at hand was to build an accurate growth model for 6, 12, and 24 month time windows. He explained he also needed data like Session Counts, CPU and Memory Utilization, Storage, and I/O Throughput. The current method required executing script after script against each...
    • 8 Dec 2016

    Execute queries on multiple SQL Server Instances

    Back in my SQL Server DBA days, I worked for an Application Service Provider (ASP) which would now be called Software as a Service (SaaS). I recall during application upgrades I often had to run a few thousand line script in each of our client's databases. Now this would be fine if it were only 5-10 client databases but we had anywhere from 75-100 at any given time. At that time we had to use native tools so I would...
    • 7 Dec 2016

    A Wait-Free Introduction to Spotlight on SQL Server's Wait Events and Workload Analysis Views

    I once attended an excellent training on giving effective software demonstrations, and the main point was simple: Don’t make your audience wait - show them the good stuff FIRST! So here it is, in just three steps in Spotlight on SQL Server Enterprise‘s Wait Events drilldown, you can find out what your heaviest queries were, for any recent time range: This really “turns on the lights” in terms...
    • 7 Dec 2016

    Monitoring Raspberry Pi with Foglight - Part 2

    In part one of monitoring Raspberry Pi with Foglight , I showed that the Infrastructure agent worked pretty much as expected when collecting from the Raspbian OS. I was curious though if it exposed any metrics via snmp. The first step was to check if snmpd was even installed and running. I ran "sudo /etc/init.d/snmpd restart" and to my mild surprise, it showed the service restarting. Now it was time...
    • 5 Dec 2016

    Minimize SAP ERP Migration Downtime with SharePlex

    Now that SAP has announced that the latest release of their ERP Software (S4) will support only their Hana database, customers are facing time-consuming data migrations to move their data from Oracle to Hana . SharePlex can help! While there are ...
    • 1 Dec 2016

    A Day in the Life of a DBA – Part 2: The No-Stress Data Management Express

    Moving big amounts of data can be very stressful and quite often requires all of your technical skills. Users expect data migrations to be done quickly and ideally with no downtime and impact on the applications that they are working with. Sometimes it is necessary to move data: upgrading your database or moving the whole database to another server. Furthermore you can reduce your IT costs with data migration tool...
    • 1 Dec 2016

    Performance Monitoring from Spotlight Cloud

    The Spotlight Cloud services lets you monitor your servers on the web and mobile devices. It also analyzes your server performance data and gives health checks on your servers, evaluates their capacity and provides other insights into their performan...
    • 29 Nov 2016

    Enhancements in SharePlex for a peer-peer setup.

    SharePlex peer-to-peer enhancements Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer replication is not appropriate for all replication environments as it requires a major commitment on the application and database design that may not be practical when packaged applications...
    • 23 Nov 2016

    Can Toad Data Point help me win the lottery?

    I was looking at my losing Mega Millions ticket last night and thought 'can I ever win this?' I am not holding out much hope but then I thought, 'how about if I took the winning numbers for the year so far and tried to find a pattern in them?' Genius! Maybe. So I went to the Illinoislottery.com website to find the numbers. I thought they used to have a link to download the data directly but that...
    • 21 Nov 2016

    DevOps Adoption in Database Development: Make It a Reality [New Survey]

    DevOps has been pervasive within Application Development for several years, but the database environment is so different and sensitive in nature, making database development a barrier to an end-to-end DevOps strategy. The most important element of De...
Read Tech Center Blog Posts RSS