July 12, 2017
Spirited competition is under way among cloud providers as they enhance large-scale relational data warehouses in the cloud. An Azure SQL Data Warehouse update by Microsoft is the latest example.
December 13, 2016
Microsoft's Dec. 2016 Patch Tuesday was a fairly routine monthly entry in a year that ended up setting a new record for most Windows patch bulletins.
September 30, 2016
The big data movement has frozen out many data professionals who are versed in SQL. Microsoft's U-SQL programming language tries to get such folks back in the data querying game.
September 29, 2016
Among a handful of new SQL-oriented, in-memory databases is MemSQL. Recent product updates are meant to improve data pipeline creation and performance in high-speed ingestion applications.
SQL Get Started
Bring yourself up to speed with our introductory content
A query is a question, often expressed in a formal way. A database query can be either a select query or an action query. Continue Reading
Learn about big data technologies and architecture, vendor developments in the big data arena and what CIOs say are their biggest challenges when implementing big data in their storage environments. Continue Reading
Many consider virtualizing critical applications a liability, but it's only a problem if you overlook the risks. Continue Reading
Evaluate SQL Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Spark's draw has gone beyond its batch processing speed. Find out why more than 500 organizations, including Webtrends and Synchronoss Technologies, have turned to the technology. Continue Reading
One benefit of Docker containers is their portability, but several common configuration mistakes can limit automation and the ability to move them between cloud environments. Continue Reading
It's still hard to move existing data warehouse jobs to Hadoop, but emerging tools can help. Cloudera Navigator Optimizer is one such Hadoop tool tapped by digital marketing company Conversant. Continue Reading
Learn to apply best practices and optimize your operations.
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
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
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
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.
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
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 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