SQL

SQL news, information, and how-to advice

sql course
cropped image of female runner from knees down

questionable signs 87489914

SQL Server 2016 heads for release, but Linux version is still under wraps

SQL Server 2016, sporting a full-fledged free edition for developer use, will have a June 1 release. But there's still no word about the promised Linux version

Big Data (4)

Microsoft SQL Server 2016 finally gets a release date

Microsoft's popular database software will have its latest major release on June 1

Spark Java microframework

Apache Spark powers live SQL analytics in SnappyData

The same team that created GemFire builds on Spark in a new open source database that can analyze OLTP and OLAP workloads side-by-side

patch fix wall bricks fix repair

Oracle security update includes Java, MySQL, Oracle Database fixes

Several vulnerabilities in Oracle's quarterly patch release are considered critical and could be remotely exploited

Data center servers

Support for SQL Server 2005 ends Tuesday -- are you ready?

There will be no more updates from Microsoft, so at this late hour, the key is to minimize your exposure

large container vessel ship and horizon 101123905

WinDocks does what Docker and Microsoft can't do

Designed to run on Windows Server 2012, WinDocks also wants to bring SQL Server to containers, which Microsoft doesn't yet do

tech background graphs arrows

MapD database rides GPUs for faster performance

A new SQL-compatible database uses GPUs to accelerate queries and GPU memory to cache data for even faster results

cockroach

Scalable, disaster-resistant CockroachDB enters public beta

As tough to take down as its namesake, CockroachDB combines high fault-tolerance, strong consistency, and horizontal scalability with familiar SQL syntax

bull statue rush horns

8 no-bull reasons why SQL Server on Linux is huge for Microsoft

SQL Server on Linux? You're not dreaming. Here's what is important about this historic shift on Microsoft's part

sql loves linux 2 twitter 002 640x358

Microsoft is bringing its crown jewel SQL Server to Linux

SQL Server, one of the most popular pieces of database server software, and a crown jewel of Microsoft's enterprise software empire, is coming to Linux. Seriously.

Data center servers

Microsoft continues hybrid cloud push with stretchable SQL Server

Microsoft is keeping up its push to provide businesses with hybrid cloud tools by offering a new feature that lets companies stretch their database tables from on-premises infrastructure to its Azure storage service.

bi business intelligence ts

How different SQL-on-Hadoop engines satisfy BI workloads

Benchmark of SQL-on-Hadoop engines Impala, Spark, and Hive finds they each have their strengths and weaknesses when it comes to BI workloads

Microsoft SQL Server 2005

How to conquer the SQL Server 2005 migration challenge

Moving SQL Server 2005 data will be the easy part compared to the app migrations

toy 2016 intro center crop

InfoWorld's 2016 Technology of the Year Award winners

InfoWorld editors and reviewers pick the best hardware, software, development tools, and cloud services of the year

rated r movie screen

SQL Server 2016 gets an R (language) rating

SQL Server's next on-prem version will have built-in support for analytics written in the R language, via Microsoft's acquisition and its own implementations

security cloud data

Azure SQL wraps databases in new encryption protections

Row-level security and column masking features in Azure SQL are meant to go beyond protecting data at rest

metanautixthedatasupplychain

Binding data to UI considered harmful

Complications of binding data to UI

N1QL brings SQL to NoSQL databases

A next-generation query language for document databases extends SQL to work with semi-structured data

Load More