Articles about Queries

Type arms of an old typewriter

BIND bashes bugs

The folk who maintain the ubiquitous BIND DNS server have issued a patch for two bugs, one of them serious. Most of the time, organisations treat denial-of-service bugs as less serious than, for example, information disclosure or remote code execution bugs. BIND, however, is special: it's a fundamental part of the Internet …
Cat and mouse

Oh, ALL RIGHT, says Facebook, we'll let Windows admins run osquery

Two years after it first arrives for Linux and OS X, Facebook's "osquery" developer kit is now available for Windows. Osquery is designed to let sysadmins check out system and process information by issuing SQL queries, rather than (for example) having to watch syslogs. An example (drawn from the GitHub repo) is the kind of …

Startup iguazio launches NVMe-propelled missile at enterprise analytics

iguazio’s Data-as-a-Service Enterprise Data Cloud converges different storage access protocols and use cases behind an access abstraction layer and claims to out-perform Amazon and all-flash filers at lower costs. The startup’s pitch is that Big Data analytics data, input, extraction, loading and storing is grossly complex and …
Chris Mellor, 27 Sep 2016
Laptop leaning against a stack of news papers in front of a world map illustration

Impala beats Amazon

Cloudera says Apache Impala is 10x faster than Amazon Redshift and has 275 per cent better cost efficiency. Impala is an incubatory native analytic database on Apache Hadoop that runs in the cloud. It claims Impala offers elastic scalability, better flexibility, and direct Amazon S3 query-ability that are unavailable from …
Chris Mellor, 23 Sep 2016
Ellison

Larry Ellison today said really nice things about rival Amazon's cloud

OpenWorld Oracle’s founder and CTO Larry Ellison took to the stage for his second OpenWorld keynote today, and spent the bulk of his presentation pointing out flaws in his chief cloud rival Amazon. Amazon Web Services (AWS) has three database products running on its cloud (Redshift, Aurora and DynamoDB), and in terms of features they …
Iain Thomson, 21 Sep 2016

Cooky crumbles: Apple mulls yanking profits out of Europe and into US

Apple CEO Tim Cook may pull billions of dollars in profit out of Europe and bring them home to the US, less than a month after he vowed he wouldn't. In the aftermath of the massive €13 billion ($14.5 billion) back tax claim that the European Commission landed on the electronics giant and the Irish tax authorities, Cook has …
Kieren McCarthy, 01 Sep 2016
Little girl embraces robot. Photo by Shutterstock

Huawei hugs open-sourcey Alluxio: Thanks for the memories

Huawei has announced a Big Data analytics acceleration scheme using its FusionStorage product and Alluxio open source software; which seems to be the canine genitalia du jour for speeding up lethargic analytics queries. Alluxio is the renamed Tachyon Nexus, an Andreessen Horowitz-backed startup. FusionStorage is Huawei's …
Chris Mellor, 01 Sep 2016
bomb

Windows Update borks PowerShell – Microsoft won't fix it for a week

You'd be forgiven for thinking Microsoft is actively trying to stop people using Windows 10 Anniversary Edition. A patch this week broke one of the key features of the OS: PowerShell. KB 3176934, released on Tuesday as an automatic update, addresses a good number of bugs and other oddities in the operating system, including …
Iain Thomson, 25 Aug 2016
Robots, image via Shutterstock

Microsoft buys Genee's lamp, tips it into Office 365, smashes lamp

Microsoft has bought aspiring digital assistant start-up Genee and will roll it into Office 365. Billed by Microsoft as an “artificial-intelligence-powered scheduling service,” Genee uses natural-language queries to set up tasks. In its beta phase the service was available free of charge. The service will now, however, shut …
Gavin Clarke, 22 Aug 2016

UK's mass-surveillance draft law grants spies incredible powers for no real reason – review

IPBill An independent review into bulk surveillance powers in the forthcoming Investigatory Powers Bill has warned that there is no proven case to let British snoops hack the planet. The study group examined the UK government’s Operational Case for Bulk Powers [PDF], which provided the government’s reasons for needing the most …
Google's Santa project

Google hopes to sniff out OS X badware

Google's Macintosh Operations Team has quietly been working on a whitelisting application for OS X . Code-named Santa, the software (currently described as pre-1.0) has an SQLite database holding a list of permitted and blocked applications; a userland daemon to check the database; a kernel extension to monitor for executions …
Headshot of Trojan horse

Running a DNSSec responder? Make sure it doesn't help the black hats

Sysadmins are making mistakes configuring and managing DNSSec, and it's leaving systems that should be secure open to exploitation in DNS reflection attacks. That's the conclusion of Neustar, in a study released here and which found that of more than 1,300 DNSSec-protected domains tested 80 per cent could be used in an attack …
Trainspotting

US extradition of Silk Road suspect OK'd by Irish judge

An Irish court has authorized the extradition to the US of a man accused of helping to administer the infamous Silk Road website. Gary Davis, 27, of Kilpedder, Co Wicklow, has moved one step closer to a US trial on charges of conspiracy to distribute narcotics, computer hacking and conspiracy to commit money laundering. Mr …
John Leyden, 12 Aug 2016
Two execs in a server room. Has to have happened some time heh. Photo by Shutterstock

No supercomputer cash? Time for a systems squeeze

Many companies have, understandably, a burning desire to learn things from their data. There's a cost and this manifests itself in one – or, frequently both – of two forms: money and time. Big data equals big storage and big processing power, and both of those equate to a financial cost. (And yes, we could go into the idea of …
Dave Cartwright, 08 Aug 2016
Privacy

Microsoft adds new 'Enterprise Products' section to privacy policy

Microsoft has updated its privacy policy and, for the first time, added a section devoted to “Enterprise Products.” The new section is the listed last in Microsoft's privacy policy and covers “those Microsoft products and related offerings that that are offered or designed primarily for use by organizations and developers.” …
Simon Sharwood, 04 Aug 2016
Angry man on laptop. Illustration via Shutterstock

Sealed with an XSS: Popular vulnerabilities probed

If we have internet-facing web servers (and other types of server, for that matter) we care about how vulnerable they are to attack. There are loads of services out there that you can use to probe your public-facing systems, and they'll tell you loads of useful stuff about why they might be vulnerable. But of course they're only …
Dave Cartwright, 03 Aug 2016
Facepalm from Shutterstock

The Australian Bureau of Statistics has made a hash of the census

Bootnoted The Australian Bureau of Statistics (ABS) has so badly mishandled the question of retaining names that its senior leadership need to consider their futures. The ABS is – sorry, was – probably one of Australia's most trusted bureaucracies, alongside the Bureau of Meteorology, the Australian Electoral Commission, and Geosciences …
Woman in balaclava with shopping bags. Photo by Shutterstock

Oh deer.io: Cyber criminals* using one-stop DIY web biz shops

Updated Cybercrime miscreants seem to be flocking to a one-stop online web business shop. The use of sites like Deer.io prove the barriers to entry for cybercrime are continually being lowered, according to threat intel firm Digital Shadows. Darkside.global, a URL associated with cybercriminal Tessa88 who has distributed leaked …
John Leyden, 27 Jul 2016
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