• 3 Jul 2017

    The Fourth V

    The key characteristics of Big Data are commonly known as “the 3 V’s”: Volume , Velocity , and Variety . Volume for the amount of data stored to process; Velocity for the tremendous pace required to generate, store and analyze data; and Variety for the many sources of data generated as well as the disparity of formats. There are “2 V’s” that have become incorporated into the literature...
    • 27 Apr 2017

    TDP is EDC !

    What is EDC or “Every Day Carry”? Wikipedia describes EDC as items that are carried on a consistent basis to assist in dealing with normal everyday needs of modern society, including possible emergency situations. Some of the most common EDC items are knives, flashlights, multi-tools, smartphones, notebooks, duct tape, and pens. The type and quantity of each items may vary widely like IT tools. Toad...
    • 3 Mar 2017

    Forget Fake News, what about Fake Data?

    Over the past few months we’ve all seen how “fake news” and “alternative facts” can influence a presidential campaign, but it’s not just world leaders who can be affected. “Fake data” has the potential to cause chaos within organisations. People talk about being in the Information Age, but for organisations it’s more like the Data Age, epitomised by trends such as...
    • 31 Jan 2017

    Automation is cool! Repetition is not!

    "Repetition is the sign of a weak mind and I tell people that over and over and over …….." Repetitive processes can be a time consuming job and automating these processes and tasks is not always a simple effort. Whether automating tasks in a Dev Ops environment or more commonly just automating day to day job requirements such as reporting, data pulls, data cleansing and emailing reports can be...
    • 24 Jan 2017

    Do you know where your java transactions are, part 2

    Java Workload Characterization – Part 2. My 3, 5, 7, 10 Rule I hope you had a chance to look at do you know where your java transactions are, my Java Workload Characterization – Part 1 blog. And I love to hear what else you can add or suggest to our audience. Here in this part two, I like to cover some additional dimensions to my monitoring. Occasionally you end up working for one very large composite...
    • 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...
    • 12 Dec 2016

    Toad Data Point 4.1’s NEW 64-bit Installer is now available!

    One of the big new features of Toad Data Point 4.1 release is a 64-bit installer offering. There is a unified installer that contains both a 32 and 64-bit Toad Data Point 4.1 installer. (Note: The Toad Data Point beta will only come in a 64-bit installer.) Although, the installer will not allow a side-by-side install with the same bit version; the new installer makes it easy to swap one-bit flavor for another via...
    • 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 Oct 2016

    Bridging the (SQL) gap with Toad’s Query Builder

    Toad for Oracle’s Query Builder window provides a quick method for creating the framework of a SQL queries (Select, Insert, Update, or Delete statement). Additionally, one can select Tables, Views, or Synonyms, join columns, select columns, and generate the chosen sort of statement. In this concise video, Senior Support Engineer, Danny H Pham, demonstrates how easy it is to be creating and building queries along...
    • 20 Oct 2016

    What’s New for InTrust 11.2 - September 2016?

    This monthly publication will provide new and updated information regarding the products that we offer and organized in the following categories: product notifications, new knowledgebase articles, product life cycle, services, training, trending videos, awards, and testimonials.
    • 15 Sep 2016

    Fast and Furious Agile Development

    If we’ve learned anything from the cinematic achievement that is all 72 Fast and Furious films, it’s that high-stakes operations can quickly go awry with the slightest technical glitch. Staying ahead of the competition requires agility a...
    • 13 Sep 2016

    Coming soon… A new Quest

    Thank you for taking a minute to read this short post. I know your time is valuable , so if you want to skip the text and just watch the video , go for it. Still reading? Cool. As you should know by now, Francisco Partners and Elliott Management have announced an intent to acquire the Quest Group. In the coming months, we’ll be starting a new chapter and launching a new company known as Quest. Our plan is...
    • 13 Jul 2016

    Isn’t it time to expect more from IT management?

    It’s crazy - technology and business are moving faster than ever and you’re sprinting just to keep up. Meanwhile, your workday is wasted on tons of repetitive, day-to-day tasks. That’s why we hosted a Virtual Tradeshow . The ba...
    • 17 May 2016

    Statistica 13.1: Citizen data scientists are not here by accident.

    The onslaught of big data is well-documented, and the consensus is that the technology that has enabled its rapid proliferation has far outpaced the ability of human study (and matriculation rates) to keep up with the resulting need for analysis. Big
    • 13 Apr 2016

    #ThinkChat- Best Practices in Big Data / IoT Analytics

    Join us April 22nd at 11:00 AM PST for this month's #ThinkChat event live on Twitter! Talk with and learn from folks in the industry on how to successfully implement Big Data and IoT projects. This month's #ThinkChat gives us an opportunity to
    • 4 Apr 2016

    Blocking Out the Noise: A Path Forward for Women in STEM

    Much has been made in the media in recent weeks about the challenges women face in pursuing STEM (science, technology, engineering, and mathematics) careers. The challenges are real and they’re plenty, everything from lack of opportunity and unequal
    • 22 Mar 2016

    Joanna Schloss Named Among Top Women in Business Intelligence and CMSWire Contributors of 2015

    Joanna Schloss is our subject matter expert in data warehousing, business analytics, business intelligence and big data analytics. Along with her work on data and information management in the Dell Center of Excellence, Joanna speaks and publishes frequently
    • 23 Feb 2016

    ThinkChat- Stemming The Gender Gap

    While advances have been made in recent years, a gender gap still exists and in some cases have widened in the STEM (science, technology, engineer, and mathematics) fields. Please join us for a ThinkChat conversation to discuss how women today are bridging
    • 22 Feb 2016

    Thought Leaders in the Mix - Feb. 2016

    Our subject matter experts for Statistica keep busy, staying abreast of current trends with big data and small data, IoT, predictive software and real-world analytics solutions. And they frequently comment in industry publications, professional forums
    • 8 Feb 2016

    Mobility Tranquility, Part 2: Pull Out a Smartphone and Monitor Your SQL Server performance

    Mobility Tranquility is the state we want to put you in. It’s where you are when you’re using the Spotlight mobile app to monitor the performance of your SQL Server instances anytime, from anywhere. Spotlight collects SQL Server performance
    • 25 Jan 2016

    #ThinkChat- Technology Predictions for 2016

    Special Guest, John Myers Topic of the day –sharing views on what to expect and look forward to in the coming year, 2016. At this month's #ThinkChat, we will have a John Myers (@JohnLMyers44) from EMA guest tweet alongside our
    • 16 Dec 2015

    Statistica Receives 2015 Technology Innovation Award from Dresner Advisory Services

    For Dell Statistica, a great year just got even better. Earlier this morning, Dell was recognized as a technology leader in Advanced and Predictive Analytics for 2015 in the inaugural Dresner Advisory Services Technology Innovation Awards, a new awards
    • 8 Dec 2015

    Thought Leaders in the Mix - Dec. 2015

    Our subject matter experts (and guest bloggers) for Statistica keep busy, staying abreast of current trends with big data and small data, predictive software and real-world analytics solutions. And they frequently comment in industry publications, professional
    • 8 Dec 2015

    That Giant Sucking Sound You Heard Is it Your Data

    Nature abhors a vacuuum. So does data analytics. The whole idea behind collecting and analyzing data is to answer questions within some kind of context and, thus, enable decisions to be made--hopefully, better decisions than those made without the data
    • 1 Dec 2015

    Is Statistica 13 Really All That Great? (Duh.)

    Probably every IT department has at least one cynic who believes that every software maker touts every new release as something earth-shattering. After all, why give software a new number if it doesn’t represent a quantum leap of some kind, right