Featured IT News

Dedicated online platforms for job seekers could help address skills shortage: recruiter

26 August 2019 in Recruitment

Implementing online platforms where job seekers can input their experience and allow tracking of former projects through specialised systems could…

9Spokes inks agreement with Bank of America

26 August 2019 in Deals

Australian-listed New Zealand company 9 Spokes has entered into a formal contract with Bank of America to provide the US…

Satellite positioning tech could be worth $6 billion-plus to economy

26 August 2019 in Space

Trials of ‘world first’ satellite positioning technology have proven more than $6 billion could be delivered to the Australian economy…

Electric vehicle adoption gets $15 million funding boost from ARENA

26 August 2019 in Energy

The Australian Renewable Energy Agency (ARENA) has given a boost to the adoption of electric vehicles by providing $15 million…

Governments back Netflix Clickbait mini-series production in Melbourne

26 August 2019 in Strategy

The Federal Government is providing $4.9 million to jointly fund with the Victorian Government the production of the Netflix mini-series…

Splunk says US$1.05b deal to buy SignalFx will give it leadership of monitoring market

26 August 2019 in Deals

Big data analytics company Splunk’s agreement to acquire SaaS real-time monitoring and metrics for cloud infrastructure vendor SignalFx puts the…

Warning on emergence of new SMS phishing scam

25 August 2019 in Security

Security firm Proofpoint says that retailer Kmart’s recent warning of a new attack by a sophisticated SMS scam means that…

Spacetalk sales soar as MGM hits record high, tackles UK, European markets

25 August 2019 in Listed Tech

MGM Wireless, the makers of the SPACETALK all-in-one  children’s smartphone, watch and GPS device, have grown total revenue by 161%…

INVITATION: Celebrate 30 years of the Internet in Australia with a special Gala Dinner on October 31 in Sydney

25 August 2019 in Development

On 31 October, over 400 industry leaders, pioneers, technologists, entrepreneurs, decision makers, executives and policy makers will gather to remember…

Global 5G network infrastructure forecast to reach US$4.2 billion in 2020

23 August 2019 in Telecoms & NBN

Worldwide 5G wireless network infrastructure revenue will reach US$4.2 billion in 2020 - an 89% increase from 2019 revenue of…

Macquarie Telecom to deploy Apple devices to Australian mid-market

23 August 2019 in Business Telecommunications

Telecommunications and data centre provider Macquarie Telecom is set to deploy mobility solutions for Apple devices to mid-market enterprises in…

Unfair contract terms in small business sector under scrutiny by ACCC

22 August 2019 in Strategy

Australia’s competition regulator the ACCC says unfair contract terms are a big focus as it takes action and moves to…

NextDC’s M2 Melbourne data centre gains Uptime gold certification for sustainability

22 August 2019 in Data Centres

Data centre operator NextDC’s M2 Melbourne data centre has achieved Uptime Institute’s Tier IV Gold Certification for Operational Sustainability.

Deliveroo appoints new CEO for Australia

22 August 2019 in People Moves

Online food delivery service Deliveroo has appointed current CEO at Meridian Energy and Powershop Australia, Ed McManus, as CEO of…

Experian acquires Australian fintech startup Look Who’s Charging

22 August 2019 in Deals

The Australian and New Zealand arm of global credit bureau services provider Experian has acquired Australian fintech startup Look Who’s…

Blue Prism, Wipro partner to launch Melbourne Automation Lab

22 August 2019 in Strategy

UK-headquartered robotic process automation software company Blue Prism has partnered with India's second largest outsourcing company, Wipro, to launch the…

NetApp taps Rohatgi for regional role

22 August 2019 in People Moves

Hybrid cloud vendor NetApp has appointed Sanjay Rohatgi as senior vice president and general manager for Asia Pacific.

Commonwealth Bank, BioDiversity Solutions collaborate to develop Blockchain ‘BioTokens’

22 August 2019 in Development

A new blockchain prototype has the potential to boost sustainable development while enabling investment opportunities for landowners, environmental groups, developers…

Breaking IT News

Will Circles.Life become the new King of the MVNO jungle?

26 August 2019 in Telecoms & NBN

In the circle of life, your uncle murders your father but you end up beating the hyenas, becoming King and…

Deliveroo claims rapid growth of restaurant partner network

26 August 2019 in Market

Online food delivery service Deliveroo says it now has more than 1,000 partner restaurants through its Marketplace+ service that allows…

Nokia appoints Styf Sjöman as chief strategy officer

26 August 2019 in People Moves

Finnish telecommunications equipment vendor Nokia has appointed ‘former Telia Company executive Gabriela Styf Sjöman as chief strategy officer and a…

Nokia will roll out Android 10 'starting Q4 2019'

24 August 2019 in Phones

Starting in Q4 2019, Nokia smartphone fans can get their hands on the Android 10 software upgrade and start enjoying…

Quantify, 8Digital deal on Queensland distribution

23 August 2019 in Market

Perth-based home automation company, Quantify Technology has sealed a distribution agreement with 8Digital for the distribution of its products in…

Kleos raises $3 million in extra funds for second cluster of satellites

22 August 2019 in Space

Space technology operator Kleos Space has secured $3 million in funding for its second cluster of satellites.

Hitachi Vantara hires Johnson as ANZ leader

22 August 2019 in People Moves

Data specialist Hitachi Vantara has appointed Adrian Johnson as vice president and managing director for Australia and New Zealand.

Hear, hear: Deaf Australia sees true value in Huawei StorySign AI app

21 August 2019 in Apps

In an address to the National Press Club in Australia, Deaf Australia CEO Kyle Miers hailed the success of the…

MYOB scores Bunnings exclusive, launches rewards program

21 August 2019 in Accounting Software

Accounting software provider MYOB has announced a deal with Bunnings that will simplify bill processing for their mutual customers, plus…

VIDEO Interview: James Robinson of HMD Global Australia talks upgradeable tech as Nokia launches 2.2 model with removable battery

21 August 2019 in Phones

HMD Global is the home of Android-powered Nokias, and I spoke to A/NZ Country Manager James Robinson about consumers investing…

Westpac opens $50,000 innovation challenge

21 August 2019 in Strategy

Fifty thousand dollars is on offer in the 2019 Westpac Innovation Challenge which gives start-ups, scale-ups and entrepreneurs the chance…

Book Review: "We the People" by Peter S. Temes and Florin Rotar

21 August 2019 in Books

Big Data can tease out all manner of analyses and conclusions from our very digital world, but how can it…

CBL Markets, Xpansiv complete merger

21 August 2019 in Strategy

CBL Markets (CBL) and Xpansiv have completed a merger to form Xpansiv CBL Holding Group (XCHG), a “first-of-its-kind platform” that…

Synacor expands with Zimbra deals in Q2

21 August 2019 in Deals

Global US-based technology and services company Synacor has announced its Zimbra email and collaboration platform added more than 100 new…

Booming North American wearables market hits US$2 billion for quarter

21 August 2019 in Market

The value of the North American wearables market reached US2.0 billion in Q2 2019, with shipments up 38% at 7.7…

Siyata Mobile gets US400k purchase order to equip first responders with Push-to-Talk devices

21 August 2019 in Mobility

Canadian global cellular communications systems provider Siyata Mobile has received a US$400,000 purchase order to equip first responders in the…

Sahakian leads channel for Snowflake

20 August 2019 in People Moves

Cloud data warehouse vendor Snowflake has appointed Alana Sahakian as channel and alliances manager for Australia and New Zealand.

Study finds inadequate education, leadership, funding major barriers to Australia’s cyber security preparedness

20 August 2019 in Security

The success of an organisation’s cybersecurity investment lies in more than buying technology, with corporate culture, employee education and path-to-purchase…

NextDC opens Perth microsite

20 August 2019 in Data Centres

Data centre operator NextDC has launched its first micro data centre, located in Perth's CBD.

SUSE appoints tech industry veteran Yates to head Australia, NZ business

20 August 2019 in People Moves

Germany-based open source company SUSE has appointed 15 year ICT industry veteran Charlie Yates as country director for the Australia…

Drayton to lead Intuit in Australia

20 August 2019 in People Moves

Intuit, the company behind the well-known QuickBooks cloud accounting system, has appointed Natira Drayton as its country manager and vice…

 

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.