Featured IT News

‘Standalone’ 5G offers opportunities for market differentiation, says analyst firm

22 January 2020 in Business Telecommunications

Standalone 5G is coming in 2020 as a fully virtualised, cloud-native architecture that will enable ultra-low latency services and faster…

Retail, restaurant POS software spend to surpass US$1.7 billion in 2024

22 January 2020 in Market

Global spending on point of sale (POS) software by retail and restaurant businesses is forecast to grow to US$1.7 billion…

Downloads soar as Australians ‘binge’ on streaming, says ACCC

21 January 2020 in Business Telecommunications

Australians are spending less time talking on their mobile phones and downloading substantially more data than they were even a…

Next Telecom expands business with telco acquisitions

21 January 2020 in Telecoms & NBN

Telecommunications service provider Next Telecom has ramped up its business with the acquisition of four Melbourne-based telcos - Next Business…

Edith Cowan Uni reduces IT costs with migration to Microsoft Azure

21 January 2020 in Strategy

Western Australia’s Edith Cowan University’s (ECU) has successfully completed the first phase of a digital transformation that has seen the…

DDLS launches (ISC)² certified cloud security professional certification training

21 January 2020 in Security

Corporate IT and process training provider DDLS is now offering the Certified Cloud Security Professional (CCSP) certification training from (ISC)²…

RTI selects Equinix to connect new submarine cable system in Australia, Japan

21 January 2020 in Data Centres

Singapore-headquartered undersea cable owner RTI Connectivity has selected data centre operator Equinix to extend its connectivity solutions in Sydney and…

Australia broadband cost down, but country ranks 113th out of 206 nations

21 January 2020 in Telecoms & NBN

A British website that regularly surveys broadband packages globally has ranked Australia 113th out of 206 countries that it looked…

2020 a year for enterprise ‘digital transformation’: Verizon

20 January 2020 in Strategy

2020 is all about executing on enterprise digital transformation, according to US telco giant Verizon, which says that early digital…

Cisco recalls 87 different WiFi access point models

20 January 2020 in Wi-Fi

Cisco has announced that several of its WiFi devices are so "broken" that the company's remedy is "replace on failure".

Kogan buoyant on first half sales boost

20 January 2020 in Listed Tech

Online retailer Kogan has had a sales boost in the first half of the 2020 financial year, with gross sales…

Gwilym Funnell takes APAC top job for Genesys

20 January 2020 in People Moves

Customer relationship management software provider Genesys has promoted Gwilym Funnell to senior vice president of Asia-Pacific after five years as…

Volt Bank closes ‘oversubscribed’ $70 million funding round

20 January 2020 in Market

Branchless digital bank Volt Bank has closed a $70 million Series C equity funding round, which was oversubscribed by $10…

Dire warning that Huawei 5G Australia ban could cost economy US$8.2b in lost GDP

20 January 2020 in Telecoms & NBN

Up to 3 million Australians – mostly in rural and regional Australia - will miss out on getting access to…

Venture capital funding in digital health declining

19 January 2020 in Health

Global venture capital (VC) funding in digital health, including private equity and corporate venture capital, declined in 2019 with US$8.9…

Talend appoints Christal Bemont as new CEO

19 January 2020 in People Moves

Global cloud data integration and data integrity vendor Talend has appointed Christal Bemont, former chief revenue officer at SAP Concur,…

SA Power Networks teams with Microsoft to develop digital strategy

19 January 2020 in Energy

South Australian electricity distributor SA Power Networks has developed a digital strategy program that incorporates the Microsoft 365 productivity cloud…

The biggest downloading suburb in 2019? Telstra says Coomera

19 January 2020 in Home Tech

In a year where Fortnite dominated the data channels, Coomera on the Gold Coast was king of the downloads.

Breaking IT News

Telco Circles.life donating data boost proceeds to bushfire disaster relief fund

22 January 2020 in Not For Profit

Circles.life, the Singapore-based telco that promises a “more likeable than hateable experience” - and which launched in the Australian market…

Trivago misled consumers, says Federal Court

21 January 2020 in Listed Tech

Hotel booking meta-comparison site Trivago breached the Australian Consumer Law by misleading consumers into it would help them find the…

Epson simplifies industrial robot management

21 January 2020 in Manufacturing Technology

Multiple industrial robots can be simultaneously managed via new software from Epson.

Genetec grabs Papalia for regional sales role

21 January 2020 in People Moves

Security, operations and BI vendor Genetec has appointed Dominic Papalia as ANZ regional sales manger.

Huawei signs deal with TomTom for use of maps on phones

21 January 2020 in Mobility

Chinese telecommunications equipment provider Huawei Technology has signed a deal with Dutch navigation and digital mapping firm TomTom to use…

Eaton powers up ANZ region leadership team with new appointments

21 January 2020 in People Moves

Power management company, Eaton has expanded its its senior leadership team in Australia and New Zealand (ANZ) with two new…

FULL VIDEOS: 24 Australian Uni students successfully complete Huawei's Seeds for the Future program

21 January 2020 in Development

Late last year, in December 2019, a specially selected set of students from top Australian universities became the seventh set…

Training in cybersecurity a ‘hot topic’ in Australia

21 January 2020 in Security

John Lang, CEO of DDLS SPONSORED NEWS: DDLS is one of Australia’s pre-eminent IT training companies, and we are currently…

Hybrid IT will take centre stage in 2020

20 January 2020 in Strategy

By Stephen Sims, CEO, Brennan IT SPONSORED NEWS. With more options for the technology stack than ever before, each allegedly…

Global PC market returned to growth in 2019: Canalys

20 January 2020 in Hardware

After eight years of falls, the global PC market recorded its first full year of growth in 2019, with shipments…

Review: Brother Inkvestment A3 Inkjet Multi-Function Printer MFC-J6545DW

20 January 2020 in Computers & peripherals

Brother's MFC-J6545DW multifunction delivers full A3 capabilities with low running costs.

ACMA seeks feedback on ways that businesses influence broadcast news

20 January 2020 in Technology Regulation

The Australian Communications and Media Authority is examining changes that have come about in commercial news broadcasts due to digital…

German firms IONOS, Nextcloud team up to offer data sovereignty

20 January 2020 in Data

Germany's biggest cloud and hosting provider IONOS has teamed up with open source collaboration platform provider Nextcloud to offer users…

Icon Group selects InterSystems

20 January 2020 in Deals

Australia's largest dedicated cancer care provider is adopting InterSystems HealthShare Health Connect.

China to dominate Asia Pacific cloud market by 2023

19 January 2020 in Cloud

China will account for one-third of the Asia Pacific cloud computing market by 2023, according to a new report which…

VIDEOS: Samsung's business ready Galaxy XCover Pro with removable 4050 mAh battery and plenty more

19 January 2020 in Enterprise Solutions

Coming to Australia soon is Samsung's enterprise enhanced business smartphone, with Microsoft Teams "walkie-talkie" capability, a rugged design, programmable buttons,…

Tranya Rimor True Wireless earbuds

14 January 2020 in Computers & peripherals

Emerging audio products brand, Tranya, has released its newest Bluetooth 5.0 true wireless earbuds, named the Rimor.

Windows 7 users warned as Microsoft support for system ends

14 January 2020 in Security

Security firm Tenable has warned individuals and businesses who are using Windows 7 to ensure that their systems are patched…

Equinix promotes Guy Danskine to top job in Australia

13 January 2020 in People Moves

Data centre operator Equinix has appointed nine-year company veteran Guy Danskine as managing director for Australia.

EVs will need to become the norm if we don't want to burn the planet

13 January 2020 in Open Sauce

If the ongoing bushfire crisis has taught Australians one thing, it is that the use of petrol and diesel vehicles…

ZFS? Simple, don't use it, says Linus Torvalds

13 January 2020 in Open Source

The merging of the ZFS filesystem into the Linux kernel codebase in the near future appears to be unlikely, after…

 

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

CHIEF DATA & ANALYTICS OFFICER BRISBANE 2020

26-27 February 2020 | Hilton Brisbane

Connecting the region’s leading data analytics professionals to drive and inspire your future strategy

Leading the data analytics division has never been easy, but now the challenge is on to remain ahead of the competition and reap the massive rewards as a strategic executive.

Do you want to leverage data governance as an enabler?Are you working at driving AI/ML implementation?

Want to stay abreast of data privacy and AI ethics requirements? Are you working hard to push predictive analytics to the limits?

With so much to keep on top of in such a rapidly changing technology space, collaboration is key to success. You don't need to struggle alone, network and share your struggles as well as your tips for success at CDAO Brisbane.

Discover how your peers have tackled the very same issues you face daily. Network with over 140 of your peers and hear from the leading professionals in your industry. Leverage this community of data and analytics enthusiasts to advance your strategy to the next level.

Download the Agenda to find out more

DOWNLOAD NOW!

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.