FireEye, Inc.

SQL News

View All News

SQL Get Started

Bring yourself up to speed with our introductory content

View All Get Started

Evaluate SQL Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

View All Evaluate

Manage SQL

Learn to apply best practices and optimize your operations.

  • Smart BI software choices expand data analysis skills, staff

    When building an analytics infrastructure, it's important to choose software that allows you to expand the types of job candidates you can consider. The example of a healthcare insurer's analytics team shows why. Continue Reading

  • How do the T-SQL commands TRUNCATE TABLE and DELETE differ?

    TRUNCATE TABLE and DELETE are T-SQL statements with similar functions, but that doesn't make them interchangeable. They operate differently and use different amounts of SQL Server resources. Continue Reading

  • SQL-on-Hadoop tools help satisfy big data's elephantine appetite

    Despite all the attention it gets, Hadoop's use as a framework for supporting big data processing has been limited to programmers with specific skills. Enter SQL, the standard programming language for relational databases. The integration of SQL tools is speeding Hadoop's performance and opening the door to more developers and data analysts who are well-versed in SQL. Users can choose from more than a dozen SQL-on-Hadoop open source and commercial tools, but most of these technologies are immature and have kinks to work out. And since many are specialized, it's important to understand their optimal uses.

    In this e-book chapter, Executive Editor Craig Stedman presents real-world examples of several organizations using SQL-on-Hadoop engines to simplify the process of querying and analyzing Hadoop data. He also delves into the IT challenges companies are facing and how they're resolving them. These businesses range from healthcare analytics providers to marketers to auto insurers to online dating services. Despite the diverse array of SQL-on-Hadoop users, one general theme prevails: Integrating SQL tools with Hadoop has definitely rejuvenated the elephant. One technical architect sums up SQL's influence this way: "Really all [the developers] understood was SQL. … So we were able to develop a lot more, a lot faster, because they were using the SQL syntax they were familiar with."

     Continue Reading

View All Manage

Problem Solve SQL Issues

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

  • Many say yes to NoSQL software for easing big data management woes

    In the ever-burgeoning world of big data compounded by the cloud and internet of things, NoSQL database technology is gaining popularity as perhaps a solution to scalability and performance issues that relational databases and the SQL programming language can't address. Even though the adoption rate of relational databases continues to be very high, more than one-fourth of respondents to an ongoing TechTarget survey say they've installed NoSQL systems. NoSQL software is especially useful in processing and analyzing massive amounts of unstructured and semi-structured data as well as data stored on multiple virtual servers in the cloud. Yet, in many cases, NoSQL is grossly misunderstood, partly because of its very name. NoSQL, or not only SQL, lives under the misconception that it prohibits SQL -- as in "no SQL allowed" or SQL with a slash through it. Not so. Even though some NoSQL systems are entirely nonrelational or simply avoid relational functionality, NoSQL and SQL can coexist.

    For those evaluating and considering deployment of NoSQL databases, this handbook raises enterprise and functionality issues that need to be addressed. In the first feature, consultant David Loshin explores one form of NoSQL software called graph databases, which provide an easily understandable and flexible framework for capturing, manipulating and analyzing data to help hasten development of analytics apps. In a Q&A second feature, enterprise information architect Mike Bowers says "NoSQL is completely reinventing the database from the inside out," yet many NoSQL databases lack the necessary ACID compliance. And in the third feature, consultant David A. Teich believes that in the relational versus nonrelational database tug-of-war, relations between NoSQL and SQL can indeed be symbiotic.

     Continue Reading

  • Managing shadow IT risk to the business

    With more users turning to external IT platforms to meet business needs, IT professionals must take steps to start managing shadow IT. Continue Reading

  • Using Oracle ADDM reports to resolve SQL performance problems: Step-by step guide

    Using Oracle ADDM is an effective way to resolve SQL performance problems, according to Brian Peasland. ADDM is his go-to tool for finding problem SQL statements. Continue Reading

View All Problem Solve