Database management

Cloud adoption in ANZ gathering pace

Australia and New Zealand have seen a four-fold increase in the amount of data moving from on-premise environments to the top public clouds, survey finds Continue Reading

By

• Aaron Tan, TechTarget

Top 10 information management stories of 2019

Here are Computer Weekly’s top 10 information management stories of 2019 Continue Reading

By

• Brian McKenna, Senior Analyst, Business Applications

Has Y2K windowing been addressed by banks or is Y2.02K a risk?

Big banks that haven't replaced legacy systems or fixed temporary windowing solutions to Y2K could have problems at the beginning of 2020 Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

APAC IT leaders lay out priorities for 2020

Robotic process automation and data analytics are among the top priorities for IT leaders in the Asia-Pacific region in the new year Continue Reading

By

• Aaron Tan, TechTarget

Top database cloud migration considerations for enterprises

Many organizations are switching to cloud databases and big data platforms. But understanding what option best meets your data needs is an important first step. Continue Reading

By

• Chris Foot

Get ready for CCPA: Implications for UK businesses

The California Consumer Privacy Act, a wide-ranging data privacy and consumer protection law, comes into effect on 1 January 2020. How does CCPA differ from the EU GDPR regulations and what are the responsibilities for UK businesses operating in the US? Continue Reading

By

• Peter Ray Allison

Get to know Microsoft Azure Cosmos DB use cases

Organizations can deploy Cosmos DB for a range of important applications. Learn how to bolster Azure workloads with this Microsoft database service that is highly distributed and multi-model. Continue Reading

By

• George Lawton

What is QLC flash and what workloads it is good for?

QLC flash offers low per-gigabyte costs and lots of capacity, but can be limited by endurance and I/O performance. It can be a good disk replacement for several workloads, however Continue Reading

By

• Rene Millman

Alternative databases set for mainstream adoption?

The rise of non-relational databases has been a feature of the data management landscape in the wake of big data – but to complement or replace relational? Continue Reading

By

• Lindsay Clark

Software architects struggle with relational database legacy

Legacy relational database management systems were originally designed as systems of record, but they don’t work as well in modern, cloud-native designs Continue Reading

By

• Cliff Saran, Managing Editor

PLC flash: A solid state candidate for analytics and archives?

We thought flash would end at QLC, but storage media makers are working on penta-level cell, which could push capacity to double figures, but at a further performance cost Continue Reading

By

• Antony Adshead, Storage Editor

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle cloud, database and application users. Continue Reading

By

• Craig Stedman, Industry Editor

Cloud database services multiply to ease admin work by users

The list of vendors offering managed cloud database services is growing rapidly, which gives IT teams more opportunities to offload management of database systems. Continue Reading

By

• Craig Stedman, Industry Editor

Can Oracle substantiate its cloud bluster?

Larry Ellison talks aggressively about having more datacentres than AWS and how Oracle’s cloud sales are growing – but it may have to provide legal proof Continue Reading

By

• Cliff Saran, Managing Editor

How Malaysia is nurturing data analytics talent

The Southeast Asian nation has spearheaded several programmes to build up its data analytics talent pool in efforts to improve efficiency and productivity of Malaysians Continue Reading

By

• Avanti Kumar

New cloud and on-premises options for Oracle Autonomous Database

Oracle introduced new cloud and on-premises deployment options for its namesake database and automated cloud service as Oracle OpenWorld 2019 got underway. Continue Reading

By

• Sean Michael Kerner

Brexit disrupts FCA exploration into data use in wholesale banking

The extra work for banks due to Brexit preparations has caused a delay to FCA work on the use of data in the wholesale banking sector Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

Consolidating databases in Oracle systems: Methods and tips

A well-planned consolidation strategy can help overcome Oracle database sprawl. But there are different ways to consolidate your databases, each with pros and cons. Continue Reading

By

• Lindsay Moore

How to manage Oracle database upgrades and annual releases

Oracle consultants offer tips and advice on upgrading databases, including new considerations created by the annual release schedule that Oracle is now following. Continue Reading

By

• George Lawton

Melbourne researchers uncover privacy lapses in transport dataset

A team of University of Melbourne researchers has been able to re-identify individuals from a public transport dataset, raising serious privacy, safety and security issues Continue Reading

By

• Aaron Tan, TechTarget

Oracle Generation 2 cloud service to debut in Australia

The Sydney Generation 2 cloud region will be delivered from a new datacentre to meet demand for Oracle’s cloud infrastructure and autonomous database services in Australia Continue Reading

By

• Aaron Tan, TechTarget

First Bus blends Infor asset management with SAP core ERP

When First Bus decided to upgrade its asset management and maintenance systems, it avoided senior management’s first choice, SAP, which provides its main business systems, and plumped for Infor Continue Reading

By

• Lindsay Clark

London Stock Exchange agrees to acquire Refinitiv for £22bn

The London Stock Exchange has agreed to a multi-billion pound takeover of data giant Refinitiv Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered advice on how to make that happen. Continue Reading

By

• Lindsay Moore

London Stock Exchange eyes £22bn acquisition of Refinitiv to expand data capabilities

The London Stock Exchange is looking at a huge tech acquisition to provide customers access to a wealth of data services built using the latest technologies Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure. Continue Reading

By

• Michael Otey

Singapore shores up data protection capabilities

The Singapore government has developed a skills framework for data protection officers and is looking to certify organisations under a regional cross-border privacy rules system Continue Reading

By

• Aaron Tan, TechTarget

TfL launches wireless device tracking to gather Tube data

Transport for London aims to use passenger movement data to make using the London Underground a more pleasant experience Continue Reading

By

• Alex Scroxton, Security Editor

PostgreSQL database specialist EnterpriseDB gets new backing

EnterpriseDB is looking to push its database further with help from new financial backers. The deal sees Postgres originator Michael Stonebraker coming onboard as technical adviser. Continue Reading

By

• Jack Vaughan

Why database admins should embrace automation

There are certain functions in database administration, that are good candidates for automation. These are the nuts and bolts of the job - like how to partition the storage, what happens if a disk ... Continue Reading

By

• Cliff Saran, Managing Editor

ASEAN CIOs learn to navigate the data economy

A group of IT leaders in Southeast Asia will converge in Edinburgh this July to delve deeper into issues that have been holding back efforts to become better data-driven organisations Continue Reading

By

• Aaron Tan, TechTarget

Oracle results: Revenue flat, cloud progress claimed

Full-year 2018-19 results show revenue flat to slight, but executives claim cloud headway and progress on autonomous database uptake Continue Reading

By

• Brian McKenna, Senior Analyst, Business Applications

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new views in the Oracle data dictionary. Continue Reading

By

• Brian Peasland

Gartner: Blockchain lacks functionality needed by enterprise

Gartner has found there is generally a lack of understanding of how blockchain can be used in the enterprise Continue Reading

By

• Cliff Saran, Managing Editor

How Alibaba Cloud plans to win over APAC enterprises

The Chinese cloud supplier is counting on data analytics, industry-specific offerings and its knowledge of the China market to gain a foothold in the Asia-Pacific region Continue Reading

By

• Aaron Tan, TechTarget

Salesforce completes Pardot fix after 12 days’ disruption

Plug was pulled on 17 May after a data script went wrong. Most users have had full access since 18 May, but 10 services remained down Continue Reading

By

• Cliff Saran, Managing Editor

SAP extends Hana’s reach beyond enterprise applications

The benefits of Hana Cloud Services are clear to Asia-Pacific customers, although actual adoption will boil down to cost Continue Reading

By

• Aaron Tan, TechTarget

How to connect to a pluggable database in Oracle Multitenant

Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they can be used. Here's how to do that. Continue Reading

By

• Brian Peasland

Singapore proposes data portability provisions

The Personal Data Protection Commission is seeking public feedback on proposed provisions that will let consumers move their personal data across organisations Continue Reading

By

• Aaron Tan, TechTarget

CW APAC: Expert advice on data management

Data is growing exponentially, so managing it well is crucial to business success. In this handbook, Computer Weekly looks at how companies and data management experts are tackling data challenges, studies the findings of Gartner’s CDO study, and finds out how organisations are augmenting data management through artificial intelligence and machine learning. Continue Reading

Huawei debuts AI-powered database

Huawei is using reinforcement learning to deliver self-tuning and self-healing capabilities for the latest iteration of its GaussDB database Continue Reading

By

• Aaron Tan, TechTarget

Creating an Oracle Multitenant container database and PDBs

Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the Oracle Multitenant architecture. Continue Reading

By

• Brian Peasland

MongoDB buys Realm database to boost mobile chops

MongoDB is buying Realm, the maker of an open source database for cross-platform mobile applications, to boost its Atlas cloud platform and Stitch backend as a service. Continue Reading

By

• Chris Kanaracus

SQL Server performance tuning best practices for DBAs

Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading

By

• Lindsay Moore

Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading

By

• Lindsay Moore

Using data science at Sainsbury’s

In this week’s Computer Weekly, we talk to one of the UK’s leading retailers, Sainsbury’s, about its data science strategy and how it helps the firm to better understand customers. We take a detailed look at the evolution of the business intelligence market and the impact of big data. And we find out how simulated disaster management can tackle the security skills gap. Read the issue now. Continue Reading

How APAC firms can tame the data beast

Companies and data management experts across Asia-Pacific reveal how they are tackling data management challenges that have been compounded by growing cloud usage and compliance requirements Continue Reading

By

• Aaron Tan, TechTarget

What is the difference between a database engineer, architect and administrator?

Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading

By

• Michael Hillenbrand, Thermo Fisher Scientific

How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring. Continue Reading

By

• Lindsay Moore

Amadeus deploys cloud-native shopping application on Google cloud

Amadeus has moved off mainframes and is redeveloping its software to be cloud native. Its Master Pricer is the first of its core application to be deployed on Google Continue Reading

By

• Cliff Saran, Managing Editor

Australian firms grapple with business-IT gap

The growing chasm between business and IT has hit Australia more than other countries, according to a study on the state of digital transformation initiatives Continue Reading

By

• Aaron Tan, TechTarget

How D+1 keeps payroll woes at bay

The Singapore-based F&B business behind the Yolé frozen yogurt chain has consolidated its payroll data into a single database powered by Unit4’s HR management system Continue Reading

By

• Aaron Tan, TechTarget

Modernising IT at the Bank of England

In this week’s Computer Weekly, we talk to the Bank of England as it starts the modernisation programme for its core system – one that the UK economy relies on. We look at the rise of DevSecOps and how it can help deal with increasingly complex security threats. And we examine the different approaches to storage for structured and unstructured data. Read the issue now. Continue Reading

SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the top questions that auditors ask. Continue Reading

By

• Lindsay Moore

Redis Labs swaps out open source to protect against public clouds

While Redis remain open source, higher value modules are now covered by a commercial agreement which limits commercialisation of Redis-based products Continue Reading

By

• Cliff Saran, Managing Editor

Innocent people arrested following surveillance blunders, IPCO reveals

Interception of communications commissioner Adrian Fulford warns of “grave” repercussions for people wrongly identified as suspects due to errors made when government bodies access email, phone and telephone data Continue Reading

By

• Bill Goodwin, Computer Weekly

5 trends for SQL Server environments as SQL Server 2019 looms

SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users. Continue Reading

By

• Michael Otey

No-deal Brexit could lead to data issues, MPs told

Trade body TechUK is concerned smaller companies are far from ready for a no-deal scenario, while warning that leaving without a deal could lead to serious data issues for businesses Continue Reading

By

• Lis Evenstad

5 data management infrastructure technologies to evaluate

It's the start of a new year -- is your organization ready to face the data management challenges ahead? Here are five technologies to consider adopting. Continue Reading

By

• Chris Foot

Facebook’s objections to court concerns over privacy more about ‘optics’ than facts

Facebook’s challenge to a High Court ruling that raises serious concerns about data transfers between Europe and the US is more about appearance than facts, lawyers for the Irish Data Protection Commission told Dublin's Supreme Court Continue Reading

By

• Bill Goodwin, Computer Weekly

Advantages of graph databases: Easier data modeling, analytics

Graph databases are finding a place in analytics applications at organizations that need to be able to map and understand the connections in large and varied data sets. Continue Reading

By

• Jack Vaughan

AWS pushes MongoDB compatible alternative as licences change

They probably didn't see that coming... MongoDB's switch to server-side licensing may have backfired, as AWS launches an API-compatible version Continue Reading

By

• Cliff Saran, Managing Editor

Storage 101: Structured data and its storage needs

Structured data is declining as a proportion of all data but its importance to business applications and its organised nature make its storage requirements very specific Continue Reading

By

• Stephen Pritchard

Key new features coming in Oracle Database 19c

With Oracle Database 19c, Oracle is aiming to boost the stability of its flagship software's latest generation. But 19c also offers DBAs a variety of added features. Continue Reading

By

• Robert Sheldon

Ellison slates AWS Aurora as Oracle posts flat second quarter

Oracle was late to the cloud, but CTO Larry Ellison is adamant that no one will swap out Oracle for Amazon Continue Reading

By

• Cliff Saran, Managing Editor

SQL Server 2019 improves Linux, container support

The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved Linux and container support. Continue Reading

By

• Michael Otey

The real Oracle cloud strategy that may work vs. AWS and Azure

Oracle's database software is at the heart of its efforts to move users to its cloud. And that strategy might work, despite Oracle's inauspicious standing in the cloud now. Continue Reading

By

• Craig Guarente, Palisade Compliance

Why to give third-party Oracle database monitoring tools a try

Oracle DBAs can use features in Oracle Enterprise Manager under database licenses. But third-party tools may aid efforts to monitor and tune database performance. Continue Reading

By

• Brian Peasland

Tibco’s Orchestra acquisition will mean ‘faster IT integration’

Tibco’s strategic acquisition of Paris-based Orchestra networks will ‘benefit customers of both companies’ Continue Reading

By

• Bill Goodwin, Computer Weekly

Don't let blockchain complexity bog down business applications

Enterprise blockchain applications that run in a controlled environment don't require some of the components of cryptocurrency networks, explains expert David Teich. Continue Reading

By

• David A. Teich

Amazon Timestream, QLDB aim to grab more DBMS users for AWS

Built-for-purpose databases target general ones, especially in the cloud. At re:Invent 2018, AWS added time-series and transaction ledger databases to expand its line. Continue Reading

By

• Jack Vaughan

New forms of governance needed to safely and ethically unlock value of data

Despite today’s abundance of data, most of it remains locked in silos, meaning new governance structures are needed to open it up and unlock its potential value to society Continue Reading

By

• Sebastian Klovig Skelton, Data & ethics editor

CDO interview: Aidan Millar, DNB

Norwegian bank hires chief data officer to lead its data-driven transformation Continue Reading

By

• Karl Flinders, Chief reporter and senior editor EMEA

5 FAQs on SQL Server containers and how to manage them

Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them. Continue Reading

By

• Michael Otey

Azure Data Studio (formerly SQL Operations Studio)

Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems. Continue Reading

By

• Lindsay Moore

Thailand’s Democrat Party holds election with blockchain

The Zcoin blockchain was used to store file hashes of voting data and identities of voting members of Thailand’s main opposition party Continue Reading

By

• Aaron Tan, TechTarget

What the 3 versions of Oracle Cloud at Customer offer users

Oracle's Cloud at Customer service lets users run its cloud technologies in their data centers. Here's what users get in the different versions of the managed service. Continue Reading

By

• Robert Sheldon

The most useful new features in Microsoft SQL Server 2019

SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality. Continue Reading

By

• Brien Posey

Oracle OpenWorld 2018 news, trends and analysis

At its OpenWorld 2018 conference, Oracle tried to position its cloud platform as well-suited for enterprise uses. This guide compiles coverage of key developments from the event. Continue Reading

Users look to Oracle Autonomous Database to lighten IT load

Early users are kicking the tires of Autonomous Database, attracted by Oracle's pledge that the cloud technology will automate database administration chores. Continue Reading

By

• Jack Vaughan

Microsoft results show hybrid benefit to Azure growth

The software company continues to push the benefits of on-premise Windows Server infrastructure alongside Azure PaaS Continue Reading

By

• Cliff Saran, Managing Editor

Oracle bullish on growth in ASEAN

Enterprise technology juggernaut Oracle claims traction in cloud applications and growing interest in its cloud-based autonomous database service in Southeast Asia Continue Reading

By

• Aaron Tan, TechTarget

Oracle Open World 2018: CEO Mark Hurd says SAP ERP customers will defect

Oracle co-CEO Mark Hurd opined at Open World that SAP ECC6 customers will defect, in some measure, to Oracle in preference to S/4 Hana Continue Reading

By

• Brian McKenna, Senior Analyst, Business Applications

Updated Oracle Gen 2 Cloud aims to challenge cloud leaders

With enhancements to its Autonomous Database technology and cloud infrastructure security services, Oracle is trying to gain ground on Amazon and other cloud rivals. Continue Reading

By

• Jack Vaughan

6 best practices on Oracle performance monitoring and tuning

Database administrators need to effectively manage Oracle Database performance to ensure an efficient processing workflow. Let this checklist be your guide. Continue Reading

By

• Robert Sheldon

What Oracle performance tuning tools can and can't do for DBAs

Two Oracle experts discuss the tuning and monitoring capabilities of database performance management tools -- and the ongoing role that DBAs play in the process. Continue Reading

By

• Craig Stedman, Industry Editor

MarkLogic Data Hub Service aims to ease cloud use of NoSQL DBMS

MarkLogic rolled out a cloud-service version of its NoSQL database management system, a move designed to make the technology more cost-effective for cloud users. Continue Reading

By

• Craig Stedman, Industry Editor

Geospatial Commission pumps £5m into unlocking value of location data

Commission wants to unlock the value of location data held by its partners through the use of emerging technologies Continue Reading

By

• Lis Evenstad

CIO interview: Marcella Flood, head of digital transformation, Allianz Care

Insurance giant’s international healthcare division is dealing with legacy systems while working on a data-led transformation that is underpinned by standards Continue Reading

By

• Angelica Mari

Snowflake making headway in Australia

Cloud data warehouse supplier Snowflake has nabbed several Australian customers and is looking at delivering its software via the Azure cloud service next year Continue Reading

By

• Beverley Head

SQL Server high availability best practices in the cloud

The cloud isn't immune to system failures. You can increase database uptime and prevent data losses with these high availability best practices for SQL Server in the cloud. Continue Reading

By

• Lindsay Moore

Open source RDBMS uses spurred by lower costs, cloud options

Open source technologies have become more capable alternatives to mainstream relational databases for cost-conscious users -- and the cloud makes them more accessible. Continue Reading

By

• Jack Vaughan

2 ways to attach SQL Server database files to Linux containers

SQL Server files can be stored outside of Docker containers in host directories or volumes. Here's how to set up SQL Server on Linux databases and attach them to containers. Continue Reading

By

• Michael Otey

Digital projects failing because of poor databases

Legacy databases are unsuitable to run modern digitisation initiatives. Teams risk losing their jobs if their projects fail, warns Couchbase Continue Reading

By

• Cliff Saran, Managing Editor

Oracle Autonomous Database Cloud gets transaction processing

Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and management of Oracle databases. Continue Reading

By

• Craig Stedman, Industry Editor

Open source DBMS software gains foothold in enterprise IT

Open source databases are increasingly making their way into corporate IT environments, says Gartner analyst Merv Adrian in a Q&A. But some care is required. Continue Reading

By

• Craig Stedman, Industry Editor

GDPR harmonised with local laws in Nordic EU states

Sweden provides an interesting challenge for the European Union’s data protection regulation due to its laws around freedom of press and free speech Continue Reading

By

• Gerard O'Dwyer

What machine learning practitioners can learn from data warehousing

Cloudera’s head of emerging business shares lessons that machine learning practitioners can learn from their cousins in data warehousing Continue Reading

By

• Aaron Tan, TechTarget

How to attach databases to custom SQL Server containers

Deploying SQL Server in Docker containers for production applications typically requires custom containers. Here are guidelines on how to attach databases to them. Continue Reading

By

• Michael Otey

How Splunk is ‘splunking’ data for APAC enterprises

Splunk’s regional vice-president talks up the company’s business strategy and how its customers are using big data analytics in security and IT operations Continue Reading

By

• Aaron Tan, TechTarget