Featured IT News

Viettel, Nokia team up on Vietnam’s first 5G broadcast

20 September 2019 in Business Telecommunications

Vietnam’s largest mobile network operator Viettel and Nokia have broadcast the first end-to-end 5G network in Ho Chi Minh City…

Kyckr completes $5.2 million capital raise via share placement

20 September 2019 in Listed Tech

Australian-listed technology regulation company Kyckr has completed a $5.2 million capital raising led by investor and founder and CEO of…

ACMA acts against telco Infinity Telecom over industry rules breach

20 September 2019 in Telecoms & NBN

The Australian Communications and Media Authority (ACMA) has taken action against Sydney-based telco Infinity Telecom for breaching industry rules requiring…

Sites hit by card-skimming being re-used for malicious activity

20 September 2019 in Security

Sites that have been decommissioned due to attacks by the card-skimming attack group Magecart are being hijacked and re-used for…

Traffic, transport infrastructure get green light for NBN connection

19 September 2019 in Telecoms & NBN

Operators of traffic signals, automatic teller machines and a range of other specialised devices can now connect to select services…

Regulatory ‘certainty’ a must to attract Asian investors to Australia: Huawei chairman

19 September 2019 in Business Telecommunications

Huawei Australia chairman John Lord says that Australia cannot turn its back on Asia’s fast growing technological innovation, but warned…

Simjacker – Australians are safe

19 September 2019 in Security

All three Australian telcos have confirmed that Simjacker cannot hurt their customers.

US sues Snowden over not getting book vetted by CIA, NSA

18 September 2019 in Government Tech Policy

The US Government has filed a case against whistleblower Edward Snowden for publishing a book without first submitting it to…

Oracle sets sights on cloud domination

18 September 2019 in Enterprise Cloud

Global enterprise database and application provider, Oracle, has unleashed its vision to build the autonomous cloud, signalling an underlying ambition…

Ericsson China 'smart' factory now operational

18 September 2019 in Manufacturing Technology

Swedish tech giant Ericsson says it has completed a 500 million kroner (US $51.5 million) transformation of its “smart” manufacturing…

Online spending on digital, physical goods forecast to pass US$6 trillion by 2024

18 September 2019 in Market

The total global transaction value of online payments for digital and physical goods will exceed US$6 trillion by 2024 –…

5G ‘unlikely’ significant threat to NBN Co business, privatisation talk 'premature': minister

17 September 2019 in Business Telecommunications

The minister responsible for delivery of the national broadband network says the introduction of 5G services in Australia is unlikely…

NBN price cuts for wholesale NBN services good news for ‘budget conscious’ households, says minister

17 September 2019 in Telecoms & NBN

NBN Co’s flagging of proposed lower wholesaler pricing for some broadband network entry level product bundles is good news for…

Ola integrates Apple Pay in rideshare platform for Australia, NZ

17 September 2019 in Market

Rideshare platform Ola has integrated Apple Pay as a payment method in Australia and New Zealand in what it says…

NBN Co proposes discounts to broadband network wholesale prices

17 September 2019 in Telecoms & NBN

Australia's national broadband network builder and operator NBN Co is proposing to introduce significant discounts and extra capacity inclusions across…

Contracting in the ascendancy as tech skills shortage takes hold, says recruiter

17 September 2019 in Recruitment

Australian businesses are being held back by the country’s tech skills shortage, with many businesses now looking to skilled migration…

Vic drivers' licence data to be used for facial recognition

17 September 2019 in Technology Regulation

Data from drivers' licences issued in Victoria will be uploaded to the Federal Government's National Driver Licence Facial Recognition Solution,…

Mimecast aims to capitalise on Symantec sale and grab customers

17 September 2019 in Enterprise Solutions

Email security provider Mimecast has gone in hard in a bid to capitalise on the proposed sale of Symantec's enterprise…

Breaking IT News

30iGala - Remembering Internet history: Peter Coroneos video interviews Alex Zaharov-Reutt

20 September 2019 in Development

In a role reversal, the organiser of the 30th Anniversary of the Internet Gala Dinner on October 31, Peter Coroneos,…

ARENA allocates $460.5k to Alliance for Energy Productivity

20 September 2019 in Energy

The Australian Renewable Energy Agency (ARENA) has allocated $460,500 in funding to the Australian Alliance for Energy Productivity (A2EP) to…

ownCloud, Securosys enable encryption through hardware security modules

20 September 2019 in Cloud

Open-source file syncing and sharing software company ownCloud has tied up with Swiss IT security vendor Securosys SA to offer…

Barracuda launches MSP business in Australia, NZ

20 September 2019 in Strategy

Cloud security and data protection solutions vendor Barracuda Networks has launched its managed service provider (MSP) business into Australia and…

New group using Windows malware to attack Saudi targets: claim

20 September 2019 in Security

A hitherto unknown group that has been dubbed Tortoiseshell is using both customised and common Windows malware to target IT…

Switkowski reappointed as chair of NBN Co

19 September 2019 in People Moves

Telecommunications executive Dr Ziggy Switkowski has been reappointed for another three years as Chair of NBN Co, the builders and…

Your employer may neglect training, but you can't: analyst

19 September 2019 in Education

IT workers need to develop cloud-related skills — on their own time if necessary — if they are to remain…

Windows ransomware WannaCry still spreading, but the kick has gone

19 September 2019 in Security

The infamous ransomware WannaCry, which burst on to the world stage in May 2017, is still very much alive and…

Bloomberg reporter who wrote Supermicro supply chain yarn promoted

19 September 2019 in Security

The American news agency Bloomberg has promoted one of the two journalists who wrote a story last year claiming that…

Pure Storage moves up and down market

19 September 2019 in Storage & Cloud Storage

New products from Pure Storage variously address customers' diverse requirements for higher performance and lower cost storage.

OPPO unveils new wired, wireless charging technologies

19 September 2019 in Mobility

Smartphone maker OPPO claims its next generation of flash charge technologies — 65W SuperVOOC Fast Charge 2.0 and 30W Wireless…

Tableau 2019.3 explains itself

18 September 2019 in Business Software

New features in the 2019.3 release of the Tableau analytics software include the ability to explain the value of a…

Equinix extends Oracle Cloud Infrastructure global reach, spanning five continents

18 September 2019 in Deals

Global interconnection and data centre provider, Equinix, today announced its role in enabling enterprises across five continents to privately connect…

Automation Anywhere appoints industry veteran as first chief strategy officer

18 September 2019 in People Moves

Robotic process automation (RPA) company Automation Anywhere has appointed industry veteran Stephen DeWitt as its first chief strategy officer.

Non-cash payments market boom, but banks ‘reluctant’ to embrace open banking

18 September 2019 in Market

The global transaction volume of non-cash payments is growing rapidly, including in Australia, with non-cash transactions booming and competition flourishing,…

Huawei donates funds to Deaf Australia

18 September 2019 in Strategy

Huawei Australia is donating over $34,000 to Deaf Australia following its partnership with the charity and the Canberra Raiders in…

Swinburne gains Adobe Creative Campus status

18 September 2019 in Education

Swinburne University of Technology has become the first university in Australia to achieve Adobe Creative Campus status as part of…

VIDEO INTERVIEW: Zebra execs talk blockchain, automation, AR/VR and more at APPFORUM 2019

18 September 2019 in Enterprise Solutions

At Zebra's AppForum events around the world, the company shares how its customers are, and can, gain an "intelligent edge…

Stallman quits FSF, MIT over comments on sexual assault

18 September 2019 in Open Source

The founder of the free software movement, Richard Stallman, has resigned both from his position at the Massachusetts Institute of…

Woman held over alleged ID fraud after AFP, ASIC investigation

18 September 2019 in Security

A Melbourne woman aged 21 has been arrested in connection with a fraud and identity theft syndicate which allegedly stole…

Satellite operator Kleos signs first South American contract

18 September 2019 in Space

Australian-listed space technology operator Kleos Space has signed its first South American order, with an order by a Brazillian-based integrator.

 

Popular News

 

Telecommunications

Subscribe to Newsletter

*  Enter the security code shown:

VENDOR NEWS & EVENTS

REVIEWS

Recent Comments

Sunday, 07 April 2019 19:36

Microsoft SQL Server 2019 set to ease ETL pains with data virtualisation Featured

By

Global software house Microsoft is making big data the focus of SQL Server 2019, set for release later this year. A key part is data virtualisation, eliminating complex ETL processes. 

Microsoft says its flagship database product, SQL Server 2019, will make it a lot easier to manage a big data environment. In fact, the product supports a rich variety of environments like Hadoop Distributed File System (HDFS), Spark, analytics tools, and even Kubernetes-managed Linux containers.

Previously, Microsoft allowed T-SQL queries inside SQL Server 2016 to pull data from Hadoop and return it in a structured way without moving or copying the data. In the 2019 release, this concept of data virtualisation is widely expanded to data sources including Oracle, MongoDB, even CSV files.

Data virtualisation means database administrators can virtualise external data in a SQL Server instance, regardless of source, location, and format, so it can be queried like any other set of tables within your SQL Server instance.

Data virtualisation helps you create a single “virtual” layer of data from these disparate sources providing unified data services to support multiple applications and users.

ads external table wizard summary

This sounds like a data lake, but unlike a typical data lake there is no need to move data from where it lives when using data virtualisation, and this is a huge advantage over traditional ETL (extract, transform, load) processes that by necessity require delays, extra storage, additional security, and an amount of engineering to setup and maintain.

For database administrators, software developers, data scientists and others this new capability is transformative and powerful in its simplicity.

Quite literally, Microsoft has enabled your SQL Server 2019 databases to hold virtual tables which come from some other place on the Internet - whether it is a SQL Server database or otherwise, whether it’s local or far - and query and join and work with these tables just as if they were native to your database. All complex ETL processes are gone.

In this writer’s own experience, there are numerous situations where this delivers tremendous time and functionality savings.

For instance, you make a dashboard showing your company’s revenues by period, office and client out of your main line-of-business app’s database. Management then asks for budgeted sales figures to be included so the dashboards contrast actuals against the budget. However, these aren’t included in your main app but instead held in an Excel spreadsheet. Traditionally, the solution is to manually or periodically upload the spreadsheet into a new table created for this purpose, which your dashboard then queries against.

Or, if you’re using SQL Server 2019, you merely save the budget figures as a CSV file on the Finance team’s file share and add this as a virtual table in your app’s database. The budget figures appear, and can be queried against, and reported on as if they were always in the database.

ads external table csv preview

Another case: the company needs sales figures to move from its main application into the back-office ERP platform. Typically, this is achieved by exporting and importing the data between the disparate products.

Or, if you’re using SQL Server 2019 you include relevant tables from the ERP system as virtual tables in the main application’s database, and directly move data via a scheduled stored procedure. The ERP doesn’t even have to be an SQL Server database, so long as it is accessible.

SQL Server 2019’s data virtualisation supports Cosmos DB, SQL Server, Azure SQL, Oracle, HDFS and DB2.

Other SQL Server 2019 features include

  • transformational insights over structured and unstructured data supporting Hadoop and Spark;
  • scalable compute and storage clusters;
  • a complete AI platform to train and operationalise R and Python models in SQL Server Machine Learning Services or Spark ML using Azure Data Studio notebooks;
  • the choice of programming language and platforms like .NET, PHP, Node.JS, Java, Python, Ruby and more, and deploy the application on Windows, Linux or containers both on-premise and in the cloud;
  • real-time analytics on operational data using Hybrid Transactional and Analytical Processing; and
  • intelligent query processing features that improve scaling of queries- security enhancements including Always Encrypted secure enclaves, and Data Discovery and Classification labelling for GDPR.

SQL Server 2019 is in a community tech preview stage, and the final release is anticipated in the second half of 2019. Interested parties can sign up for early adoption now

LEARN HOW TO REDUCE YOUR RISK OF A CYBER ATTACK

Australia is a cyber espionage hot spot.

As we automate, script and move to the cloud, more and more businesses are reliant on infrastructure that has high potential to be exposed to risk.

It only takes one awry email to expose an accounts payable process, and for cyber attackers to cost a business thousands of dollars.

In the free white paper ‘6 steps to improve your Business Cyber Security’ you will learn some simple steps you should be taking to prevent devastating malicious cyber attacks from destroying your business.

Cyber security can no longer be ignored, in this white paper you will learn:

· How does business security get breached?
· What can it cost to get it wrong?
· 6 actionable tips

DOWNLOAD NOW!

ADVERTISE ON ITWIRE NEWS SITE & NEWSLETTER

iTWire can help you promote your company, services, and products.

Get more LEADS & MORE SALES

Advertise on the iTWire News Site / Website

Advertise in the iTWire UPDATE / Newsletter

Promote your message via iTWire Sponsored Content/News

Guest Opinion for Home Page exposure

Contact Andrew on 0412 390 000 or email [email protected]

OR CLICK HERE!

David M Williams

David has been computing since 1984 where he instantly gravitated to the family Commodore 64. He completed a Bachelor of Computer Science degree from 1990 to 1992, commencing full-time employment as a systems analyst at the end of that year. David subsequently worked as a UNIX Systems Manager, Asia-Pacific technical specialist for an international software company, Business Analyst, IT Manager, and other roles. David has been the Chief Information Officer for national public companies since 2007, delivering IT knowledge and business acumen, seeking to transform the industries within which he works. David is also involved in the user group community, the Australian Computer Society technical advisory boards, and education.