Featured IT News

Missed NBN appointments costing Australians $15 million a year in ‘lost time’: ACCAN

13 November 2019 in Telecoms & NBN

Missed NBN appointments are costing Australians over $15 million per year in lost time, according to a report from the…

Equinix opens eighth Sydney data centre

13 November 2019 in Data Centres

Data centre operator Equinix continues its Australian expansion with the opening of its eighth International Business Exchange (IBX) data centre…

Telstra partners with Inseego to launch new locator tag

13 November 2019 in Market

Telstra has announced the latest addition to its locator product range, launching a new tag developed in partnership with 5G…

Online delivery eating the lunch of restaurants and cafes

13 November 2019 in Entertainment

Hands up those of us who enjoy eating out at restaurants and having a night out at the movies. Both…

Macquarie Telecom inks deal with Open Minds

13 November 2019 in Health

Macquarie Telecom has signed a deal to provide mental health and disability support services provider Open Minds with critical mobile,…

Aust firm offering ransomware 'recovery' at second domain as well

13 November 2019 in Security

Australian firm Fast Data Recovery, which has been claiming to be able to decrypt files encrypted by the Windows Dharma…

Dell enters autonomous infrastructure market with PowerOne

13 November 2019 in Hardware

Dell EMC PowerOne autonomous infrastructure combines various families from the Dell portfolio with an intelligence engine to automate previously manual…

Nokia, Japan’s Sendai City test effectiveness of drones for tsunami evacuation alerts

13 November 2019 in Strategy

Sendai City in the Tohoku Region of Japan and Nokia have successfully conducted a test flight of a Nokia drone…

Payment security compliance in decline, says Verizon

13 November 2019 in Security

Payment security compliance has declined for the second year in a row, with organisations based in the Americas lagging behind…

Optus, Ericsson complete first 5G teleoperated drone flight

12 November 2019 in Business Telecommunications

Optus and Ericsson have delivered Australia’s first 5G teleoperated drone controlled over a live 5G network.

Ericsson, Swisscom, Qualcomm take major step towards 5G coverage in Switzerland

12 November 2019 in Business Telecommunications

Qualcomm and Ericsson have taken a step forward in the large-scale rollout of 5G across Switzerland with a claimed first…

Aust firm promises data decryption after Dharma ransomware attack

12 November 2019 in Security

Australia data firm Fast Data Recovery reportedly offered to decrypt files that had been encrypted by the Dharma ransomware for…

NBN Co lost another $1.1b in 1Q 2020, ARPU still at $45

12 November 2019 in Telecoms & NBN

Another day, another set of quarterly results from the NBN Co, the company rolling out Australia's broadband network, but little…

APAC to record highest growth in global telecom, pay-TV market

11 November 2019 in Telecoms & NBN

The Asia-Pacific (APAC) region is poised to witness the highest growth in the global telecom and pay-TV market between 2019…

Myriota seals South Australian space industry manufacturing deal with Motherson

11 November 2019 in Space

Adelaide-based nanosatellite Internet of Things connectivity vendor Myriota has entered a partnership deal with global manufacturer Motherson to produce its…

Researchers reported to find backdoor in Siemens PLCs

11 November 2019 in Security

According to unconfirmed reports, there is a hidden access 'backdoor' in the Siemens SIMATIC S7-1200 PLC (programmable logic controller) which…

GitLab yet to decide on banning Russians, Chinese from its staff

11 November 2019 in Technology Regulation

Software development and operations outfit GitLab is yet to make any announcement about a proposal it had floated recently, to…

ACMA gets tougher powers to block illegal offshore gambling websites

11 November 2019 in Technology Regulation

Australian Internet Service Providers are set to begin blocking illegal offshore gambling websites under tough new powers mandated for the…

Breaking IT News

Blinker makes Titan DMS first Australian distributor

13 November 2019 in Market

Australian car subscription software provider Blinker has appointed global dealer management solutions provider Titan DMS as the first distributor for…

AMD rules desktop world with 'world's most powerful 16-core consumer desktop processor'

13 November 2019 in Home Tech

AMD specialises in delighting customers with cutting edge technology that pushes the boundaries, delivering what its competitors wouldn't in a…

Broadcast Australia rebrands as BAI Communications Australia

13 November 2019 in Strategy

Broadcast transmission service Broadcast Australia has officially launched its rebranding to BAI Communications Australia as part of a strategy to…

More than half of Australians under 40 will buy cryptocurrencies: claim

13 November 2019 in Enterprise Solutions

Cryptocurrency exchange Independent Reserve claims that as many Australians (17%) as own more than one investment property also own digital…

Hawaiki signs deal with Australia's Anycast

13 November 2019 in Telecoms & NBN

New Zealand submarine cable system operator Hawaiki Submarine Cable has signed a deal with Australian wholesale network provider Anycast Networks…

NTT Pro Cycling 'most technically advanced team in the WorldTour'

13 November 2019 in Strategy

NTT Pro Cycling's 2020 lineup was selected with the assistance of an analytics system co-created by sponsor NTT and the…

Deliveroo launches new ‘Pick up’ service

13 November 2019 in Apps

Online food delivery service Deliveroo has launched “Pick Up”, its new click and collect service, in the Australian market.

Monash Uni researchers to explore automated decision-making technologies

12 November 2019 in Education

Monash University researchers will play a key role in a new Australian Research Council (ARC) centre examining the use of…

Wipro deploys solution for Sydney Water billing, customer services system

12 November 2019 in Deals

India's second largest outsourcing company Wipro has successfully deployed SAP S/4HANA software for Sydney Water’s billing and customer services systems.

Uber launches customer loyalty program

12 November 2019 in Market

Uber Australia has launched a customer loyalty program to reward people for riding with the ride share company and dining…

Digital bank 86 400 takes step into home-loan market

12 November 2019 in Strategy

Five months after it obtained a deposit-taking licence from the regulator APRA, the Australian digital bank 86 400 has started…

Verrency appoints Dickson Chu to advisory board

12 November 2019 in People Moves

Global payment company Verrency has appointed former Paypal executive Dickson Chu to its global advisory board.

Redflow secures deal with NZ Rural Connectivity Group

12 November 2019 in Deals

Australian-listed energy storage technology company Redflow has been chosen by the New Zealand Rural Connectivity Group (RCG) to provide zinc-bromine…

GitHub State of the Octoverse 2019 - Python popular, data science apps on the rise

11 November 2019 in Open Source

Global open-source software lifecycle and collaboration platform, GitHub, has released its annual State of the Octoverse report for 2019, revealing…

Aljuboury awarded MacGov cybersecurity scholarship

12 November 2019 in Education

Macquarie Government has awarded this year's cyber security scholarship to Adel Aljuboury, a computer science student at Western Sydney University.

Bootcamps to focus on challenges posed by regional cyber security

11 November 2019 in Security

Government officials from ASEAN and Pacific countries are to receive practical expert advice and skills training in dealing with cybersecurity…

Senec simplifies home solar batteries

11 November 2019 in Home Tech

Vertically integrated energy company Senec has launched a new hybrid solar battery that it says can make households up to…

Zoom2U raises $4.2 million

11 November 2019 in Development

On-demand courier company Zoom2U has secured another $4.2M in funding.

Leal's the new lead at Delta Electronics

11 November 2019 in People Moves

Power and thermal management specialist Delta Electronics has appointed David Leal to the role of country manager for Delta Electronics…

Next Telecom, SonicWall partner with Australian market offering

11 November 2019 in Market

Australian company Next Telecom is offering technology from global cybersecurity provider SonicWall in its Security In a Box bundle for…

Real Time Agent finds new home at Domain

11 November 2019 in Deals

Property website Domain has agreed to acquire real estate digitisation vendor Real Time Agent.

 

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

BUSINESS WORKS BETTER WITH WINDOWS 1O. MAKE THE SHIFT

You cannot afford to miss this Dell Webinar.

With Windows 7 support ending 14th January 2020, its time to start looking at your options.

This can have significant impacts on your organisation but also presents organisations with an opportunity to fundamentally rethink the way users work.

The Details

When: Thursday, September 26, 2019
Presenter: Dell Technologies
Location: Your Computer

Timezones

QLD, VIC, NSW, ACT & TAS: 11:00 am
SA, NT: 10:30 am
WA: 9:00 am NZ: 1:00 pm

Register and find out all the details you need to know below.

REGISTER!

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.