Articles about Queries

Ruby slippers from wizard of Oz

We ain't in 1996 anymore, Dorothy: SQL Server 2016 proves it

Microsoft has had a database since 1989, initially working with Ashton-Tate and Sybase to create a variant of Sybase SQL Server for IBM’s OS/2. But it wasn’t until 1995 that Microsoft really got serious with SQL Server 6 for Microsoft’s rock-solid server operating system Windows NT. Back then, however, engines like SQL Server …
Mark Whitehorn, 18 Jul 2016
tsa_gloves_648

EU waves antitrust claims in Google's face, snarls 'You want some?'

EU antitrust regulators have accused Google of preventing rivals from competing in online advertising and search, deepening its existing probe into anti-competition allegations against the ad-flinger. The antitrust charges are the latest effort to clamp down on the advertising biz, following existing investigations claiming …
Kat Hall, 14 Jul 2016
cloud

Boffins bash better brains into OpenFlow

One of the pitch points of open white-box networking is that it makes Ethernet switches extensible – something exploited by some packet boffins to build what they think is a better way to skin the network monitoring cat. The researchers, from Brown University, are trying to overcome the mismatch between the limitations of old- …
Boy with a backpack hides his eyes and cries. Pic by Shutterstock

A bad day for DBAs: MIT boffins are replacing you with a mere spreadsheet

MIT boffins reckon they've cracked one of the tough nuts of usability, creating an easy-to-use SQL interface for non-database administrators. The tool, SIEUFERD, has been in gestation since at least 2013 (Oracle mentions it here), but considering the problem it addresses has been around since the 1970s, let's not be harsh …

700,000 Muslim Match dating site private messages leaked online

Hackers have leaked the personal details of 150,000 users of the Muslim Match website after breaking into the niche dating portal. Almost 150,000 user credentials and profiles, as well as more than 700,000 private messages between users, were posted online. "These private messages cover a range of subjects from religious …
John Leyden, 01 Jul 2016

Cassandra props GridGain

In-memory compute platform GridGain has added Cassandra support in v1.6 of its GridGain Professional Edition. As well as native support for Apache Cassandra, there is a new ODBC driver, deadlock-free transactions, and a new hosted web management console. Cassandra database users should see faster performance compared to disk- …
Chris Mellor, 30 Jun 2016

InfiniBand-on-die MIA in Oracle's new 'Sonoma' Sparc S7 processor

Oracle's Sparc S7 processor codenamed Sonoma will not feature on-chip InfiniBand interfaces as expected. The CPU, designed for scale-out systems and revealed in detail by The Register in August, was due to sport an integrated InfiniBand controller capable of shoveling 28GBit/s directly between the processor and other nodes and …
Chris Williams, 29 Jun 2016
Digital feet, photo via Shutterstock

Body of evidence: Biometrics and YOU

The proliferation of password protection has become an assault on the senses. The rise of biometric authentication is helping to create some balance, enabling verification with a simple interaction, which, for many, is the fingerprint reader on a mobile phone. And once you start using the fingerprint/phone combo for NFC payments …
Bob Dormon, 29 Jun 2016
Election form

London Mayor election day bug forced staff to query vote DB by hand

The confirmation of Sadiq Khan as Mayor of London last month was delayed for several hours by a database application bug. The announcement of the election's winner was pushed back from May 6 to May 7 as a result of the programming cockup, which was buried in the IntElect systems used to scan and tabulate citizens' votes. …
Shaun Nichols, 17 Jun 2016
Lady eating a sandwich checking her mobile phone

Biz networks' DNS troubles

More than four in five (83 per cent) of enterprise networks show evidence of malicious DNS activity. Malware such as botnets, the ZeuS banking malware, distributed denial of service (DDoS) traffic and the CryptoLocker ransomware generated malicious lookup queries picked up in a new study by DNS security specialists Infoblox …
John Leyden, 16 Jun 2016
Punnets, photo by Graze

When DIY is not enough: Web-snack firm Graze has an offline awakening

“Graze is doing the reverse of most companies,” co-founder and chief technology officer Edd Read tells me. “We started online and we are going offline. We started with bespoke home-made technology and we are beginning to adopt the opposite.” Started in 2008, Graze has done everything considered “normal” in today’s startup …
Gavin Clarke, 16 Jun 2016

Bing web searches may reveal you have cancer (so, er, don't use Bing?)

Search engine results can be a useful predictor for cancer and can even beat doctors to the mark, according to new research from Microsoft. In a paper published in the Journal of Oncology Practice, a Redmond team detailed how, by analyzing data from Bing users who looked up symptoms of pancreatic cancer, they could get an …
Iain Thomson, 08 Jun 2016
Slices of madeira cake

Big Data: analyse this

The Transaction Processing Performance Council (TPC) has announced availability of the TPCx-BB benchmark. It is designed to measure the performance of Hadoop-based systems including MapReduce, Apache Hive and Spark Machine Learning Library (MLlib). TPCx-BB executes frequently performed analytical queries in the context of …
Chris Mellor, 08 Jun 2016

'MongoDB ate my containers!'

Line Break Welcome back to The Register's weekly software bug parade, Line Break: Season Two. After a hiatus, and a vacation here or there, Line Break has been recommissioned. You can catch up on previous episodes, here. The idea is simple: if you spot buggy code in the wild that's driven you bonkers or to hysterics, drop us a line with …
Chris Williams, 08 Jun 2016
Crypto fingers

DNS security can be improved with cookies, suggest IETF boffins

A proposal raised late May at the Internet Engineering Task Force (IETF) suggests adding cookies to the DNS to help defend the critical system against denial-of-service exploits. The domain name system (DNS) is an old and fundamental piece of the Internet architecture, providing translation between human-readable addresses …
Dell's Triton liquid cooling rigs

Dell finds liquid cooling tech on eBay, now wants you to buy it

Dell is getting into the water-cooled server business for hyperscalers with an offering called “Triton” that it developed for eBay. Dell says it's keen on water cooling because it's cheap: data centres nearly always have a cooling tower that lower the temperature of water so it is sensible to put that cool water to good use. …
Simon Sharwood, 06 Jun 2016

New Android tricks for modern malware licks

Symantec engineer Dinesh Venkatesan says malware writers have one up on Google with the pillaging of a keystone trick that permits attacks on Android Marshmallow. The method was extracted from white hat proof-of-concept works published initially to show how malware could extract credentials from Android apps. It allows …
Darren Pauli, 06 Jun 2016
Security guard watches footage from hundreds of camera. Photo by Shutterstock

UK Home Office is creating mega database by stitching together ALL its gov records

Exclusive The UK Home Office is secretly creating a centralised database on the good folk of Britain without presenting the capability increases to the public or subjecting them to Parliamentary scrutiny. The Register can reveal the project, which was described as simply a “replatforming” of the department's aging IT infrastructure, has …
Iris flowers

'Limitless enterprise storage'. Really? Digging deeper into Symbolic IO

Backgrounder Remember the company we wrote about yesterday? The startup with the startling technology which claimed its storage and compute technology could run database queries 60 times or more faster than other systems, and offers ”limitless enterprise storage". Well here's a Q&A that sheds a little more light on the tech. The main …
Chris Mellor, 02 Jun 2016
SQL Server 2016 supports hybrid cloud as well as on premises deployment

SELECT features FROM bumf... What's new in MS SQL Server 2016

Microsoft has released SQL Server 2016, adding new security features, improved query profiling, Hadoop integration, hybrid cloud capabilities, and R analytics to its database server, along with numerous other improvements. Calling SQL Server a "database server" does not do justice to its scope. The main components are: …
Tim Anderson, 01 Jun 2016
Caringo_Swarm_8dot1_Portal

Caringo updates Swarm

Caringo’s Swarm gets hierarchical data protection policies, historical metrics and usage metering. The updated Swarm 8.1 object storage and cloud storage software has hierarchical data protection policies allowing users to set policies through Swarm’s UI or via an API across clusters, domains, buckets or objects. Features …
Chris Mellor, 01 Jun 2016
The Twin Jet Nebula. Pic: ESA/Hubble & NASA

This storage upstart knows its technical onions: Symbolic IO

Analysis Symbolic IO is a startup that claims its storage and compute technology can run database queries 60 times or more faster than other systems, and offers ”limitless enterprise storage.” It was founded in 2012 by Brian Ignomirello, a former CTO of Hewlett Packard’s Global storage unit, and secured $1.4m in debt financing in 2013 …
Chris Mellor, 01 Jun 2016

ISS 'nauts to face Mark Zuckerberg grilling

International Space Station (ISS) 'nauts Tim Kopra, Tim Peake and Jeff Williams will tomorrow enjoy a 20-minute Facebook Live vid Q&A session with Mark Zuckerberg. The action kicks off at 12:55pm ET / 11:55am CT / 10:55am MT / 09:55am PT / 16:55 GMT down at NASA's Facebook presence. Mere mortals are invited to join the event …
Lester Haines, 31 May 2016

​The hybrid cloud wants your data

Promo A coding competition is coming soon, brought to you by The Register in partnership with IBM. For now all we can tell you is that IBM's Cloudant platform will play a part in the proceedings. So let's get the ball rolling with this call to developers, data science professionals and IT analytic architects to sign up now for a …

Bold stance: Microsoft says terrorism is bad

Microsoft is enacting a new policy to remove terrorist content from its consumer services. The Redmond software giant said that the new terms and conditions for its hosted services will bar any content containing graphic violence or supporting material for any group considered a terrorist organization by the United Nations …
Shaun Nichols, 21 May 2016
Dog and fence, mage via Shutterstock

Dell opens Oracle exit route for SAP data shops

Dell has turned its Oracle database migration suite into an exit out of Larry Ellison’s empire. Dell’s SharePlex Oracle-to-Oracle replication suite has been updated so that SAP customers can now jump from the Big Red One to the ERP giant’s Hana in-memory database. You can also use the Dell suite to move to EnterpriseDB …
Gavin Clarke, 16 May 2016
IT Crowd's Roy: "Have you turned it off and on again?"

Microsoft phone support contractors told to hang up after 15 minutes

On-Call Welcome again to On-Call, in its regular Friday slot where we bring you readers' stories of stuff that goes on in the workplace. Yesterday's tale of four fellows paid elephant bucks to do nothing for three months prompted a submission from reader “Ivan” who says his first job in tech support was for “a call centre company that …
Simon Sharwood, 13 May 2016
Policeman claps in London street

Non-police orgs merrily accessed PNC without authority, says HMIC

Her Majesty's Inspectorate of Constabulary (HMIC), which inspects Britain's police forces, has reported on several cases of misuse of the Police National Computer (PNC) by non-police organisations. The PNC is a law enforcement database that holds personal information about people arrested by police or convicted of crimes – as …
Windows 10 Build 14328 has a revised Start menu and new pen features

Windows 10 free upgrade offer ends on July 29th

Microsoft has announced that the free all-you-can-eat Windows 10 upgrade buffet will close forever on July 29, and that after that you'll have to pay for all the fun of its latest operating system. US$119 is the price Redmond has set for the Home version of the operating system. A sales person in a live chat session on the …
Simon Sharwood, 06 May 2016

App Store loses own apps

An Apple App Store cockup left folks unable to search for some iOS apps earlier today – sparking fears Apple was stripping categories of software from its online bazaar. Reg reader Matt Drnovscek alerted us on Thursday morning to the fact that queries for particular types of apps – such as mobile device management (MDM) …
Shaun Nichols, 05 May 2016

Getting shafted the Silicon Valley way

Recap If there was one standout moment from the latest episode of tech satire Silicon Valley it would have to be when our eponymous hero finds out he is being shafted by his new CEO while in the background a thoroughbred horse is literally shafted by a white stallion. Subtle? No. Hilarious? Yes. And so our favorite valley TV show …
Kieren McCarthy, 02 May 2016
Cloudy server conceptual illustration. Photo by Shutterstock

Restaurant booked, flowers ordered ... Microsoft has a hot date for SQL Server 2016

Microsoft has announced that SQL Server 2016 for Windows will go into general availability on June 1 and is positioning it against Oracle on cost, security, and speed. The database management suite will come in three flavors – Enterprise, Standard, and Express – as well as a Developer SKU. Customers with a Microsoft Software …
Iain Thomson, 02 May 2016

Neo4j bolts on binary protocol to up its graph database game

Neo Technology has released Neo4j 3.0, which it declared comes with a "completely redesigned architecture." 3.0 comes with a new binary protocol dubbed Bolt, intended for speedier graph access, though the architectural redesign is centred on a new data store, where dynamic pointer compression is intended to expand Neo4j’s …
monty_python_french_knights_648

Red Hat bets on RHEL to sell its OpenStack elastic enterprise

Cloud killing on-premises kit for enterprise IT providers? Yes if you’re IBM, no if your name’s Red Hat. At least, according to Red Hat. Wall Street’s money men are shocked – shocked, I tell you – to discover Amazon with AWS is now number two on a list of enterprises’ mega-critical IT suppliers. IBM? Not so much. A firm with …
Gavin Clarke, 20 Apr 2016
Man with head in the cloud

Symantec.cloud portal limps back online after day-long TITSUP

Symantec.cloud’s portal is back online following a day-long outage. However, sysadmins report a continuing inability to perform basic functions such as adding new email accounts for new starters at the corporate firms they manage. Problems with the system followed a database crash on Monday morning that dragged on until …
John Leyden, 13 Apr 2016
Amazon under a cloud

IT suppliers: Amazon is starting to pay its debts. Some of them, anyway

Amazon has presented irate distributors and vendors with a deal that will see them receive some payment for historical disputed deliveries stretching back a year. As we exclusively revealed last month, suppliers are battling the retail giant to get paid for orders they claimed were delivered from the spring of 2015. The …
Paul Kunert, 13 Apr 2016
Slices of madeira cake

FBI declines to comment on WhatsApp encryption

The FBI has declined to make a comment on the news Tuesday that WhatsApp is going to offer end-to-end encryption in the next version of its messaging app. WhatsApp's decision to do so was sparked in part by the authorities in the US and Brazil trying to pressure the company to hand over confidential user conversations, and by …
Kieren McCarthy, 05 Apr 2016
google_chocolate_factory_cropped_648

Google fills BigQuery with public data, invites world+dog to play

In its latest move confirming the company's ascension to deity-level entrepreneurship, Google is now selling public data back to the public through its BigQuery analytics engine. The Chocolate Factory has inserted some delicious public data nougat into its BigQuery confectionery service, pointing out that it "pays for the …
BMW i3

BMW complies with GPL by handing over i3 car code

BMW has sent Terence Eden a DVD containing GPL-licenced code used in its electric i3 model . Why should you care? Because Oxford resident Eden last month inadvertently caused something of a global stir when he pondered the quality of the i3's software and the security of BMW's update mechanisms. Along the way he noticed that …
Simon Sharwood, 30 Mar 2016
The Hollow Crown

How NoSQL graph databases still usurp relational dynasties

Analysis Despite being assaulted from all sides, the relational model for databases is still the king of the hill and it looks like it will not only survive, but thrive as well. NoSQL databases have become increasingly popular and have been offering a number of data and deployment modes that have overcome the limitations – real or …
Andrew Cobley, 29 Mar 2016
SAP Match Insights

Some old SAP systems have default kernel user accounts. Guess what happened next?

Security researchers were able to access default SAP accounts on enterprise systems worldwide by using default passwords. The security snafu meant that SAP systems worldwide were potentially vulnerable to data theft, business process disruption and fraud, specialist security outfit ERP-SEC warned. Joris van de Vis, researcher …
John Leyden, 29 Mar 2016

Cloud security harder than 'encrypt everything'

Australia's wildly-enthusiastic adoption of cloud computing is providing the rest of the world a crucible in which a host of security challenges can be cultured, according to F5 security researcher David Holmes. Speaking to The Register's networking desk while visiting the antipodes, Holmes said that “Australia is becoming the …
Game of Thrones

She's coming... the Chief Data Officer

The chief data officer is on the rise. The number of CDOs appointed by major organisations rose from 400 in 2014 to 1,000 in 2015, according to Gartner. By 2019, 90 per cent will have a CDO, the analyst says. Their rapid emergence raises important questions about the role and position of the CDO in organisations. More …
Mark Samuels, 17 Mar 2016
SQL Linux

Behold, Microsoft SQL Server on Linux – and a firm screw-you to Oracle

Pic In an aggressive move, Microsoft has told Oracle customers: migrate to SQL Server 2016 and Redmond with give you free licensing for the lifetime of the product plus technical support. Microsoft made the offer at a special Data Driven day in New York City on Thursday, and has taken out full page advertisements in the national …
Iain Thomson, 10 Mar 2016

Oracle gives apps a ticket to ride on Sparc M7's SQL warp drives

Oracle will today release, in its words, "a free and open API and developer kit" for the hardware-accelerated SQL-crunching engines in its Sparc M7 processors. You can register to grab the goodies, here. "We're opening up the interfaces to enable programmers using C/C++, Java and Python to effectively use these accelerators," …
Chris Williams, 08 Mar 2016
Mobile banking, image via Shutterstock

NatWest tightens online banking security after hacks' 'hack' exposé

NatWest is tightening up its internet banking systems after security shortcomings were exposed by journalists. BBC hacks were able to hijack a colleague's NatWest online bank account and transfer money without knowing her password. The UK bank's parent, Royal Bank of Scotland (RBS) Group, is also shoring up its security. …
John Leyden, 08 Mar 2016
Grain silos

Secondary storage, the missed opportunity for object storage

Comment I've had a lot of conversations lately with vendors and end users about secondary storage - the scenario is quickly changing, with new products targeting this space and more end users adopting different forms. Object storage crossed my radar a few years ago, and even though its potential remains huge, radical changes are …
2001: A Space Odyssey

Aye, AI: Cambridge's Dr Sean Holden talks to El Reg about our robot overlords

Interview Fatigued by bluster about the implementations of yesteryear's machine learning algorithms, we spoke to Dr Sean Holden of the University of Cambridge to enthuse ourselves again. Holden, a senior lecturer in machine learning at Cambridge's Computer Laboratory as well as being a fellow of Trinity College where he shepherds along …
An eraser

Google gives ringing endorsement to US VPN providers with 'right to be forgotten' expansion

If you use Google in Europe, your search results will be censored under the Continent's right-to-be-forgotten policy – even if you try to use one of the ad giant's non-European sites. Until now if you used Google.com rather than, say, Google.de, you could still find results that have been removed at someone's request: the …
Shaun Nichols, 04 Mar 2016
Close up of elephant family, including cute calf. Photo by Shutterstock

Sparks fly as HPE and Hortonworks hold hands for data mould

Hadoop spinner Hortonworks is tweaking Spark for bulky workloads with Hewlett-Packard Enterprise as part of a "new strategic direction." The pair declared a breakthrough in raising Spark's ability to shuffle data across a cluster - Spark currently comes with shuffle utilities, but the companies claimed they'd managed “faster …