Build There was SQL Edge and Azure Synapse news at Microsoft's reimagined Build gathering this week, so The Register had a chat with corporate vice president Rohan Kumar about the company's database ambitions.
Having lurked in limited preview for a while, Azure SQL Edge has been pushed out to a broader audience as the platform creeps toward general availability. Running on x64 or ARM, with Windows or Linux doing OS duty, Azure SQL Edge is all about shunting the smarts of its bigger SQL Server brother to edge devices for more local processing and storage rather than maintain a constant, and potentially laggardly and expensive, connection to the mothership.
Kumar cited AI training as an example use case for the technology. "[We] see a lot of customers using our big data analytics in the cloud to train and run their machine learning models," he said, "and once they come up with a model that they believe is meeting the requirements, then they mass deploy onto the SQL Edge devices."
Those devices can then run in environments that are online, occasionally connected or fully offline.
"A lot of decisions can then be made very close to where the data originates," he added.
Kumar told us that the content of the wider public preview was pretty much what would go on to hit general availability, although the gang still had a way to go in order to reduce the current 500MB footprint down to 300MB. The limited capacity of Edge devices, such as the popular Raspberry Pi, makes the bloat loss essential.
"This is not the SQL Server of 15 or 20 years ago," laughed Kumar. "It runs everywhere." Indeed, the first SQL Server this writer used was version 4.21 and it ran happily enough under NT with a massive 64 megabytes of memory. Still, it is heartening to see the footprint being reduced while other products continue to pile on the pounds.
Also hitting public preview, and some way from the grungy edge shenanigans of SQL Edge, was Azure Synapse Link, a "cloud native implementation of hybrid transactional analytical processing (HTAP)", according to Microsoft.
Kumar had previously shown off Azure Synapse, a revved-up and rebranded of Azure SQL Data Warehouse (or "evolution", as Microsoft would have it), and its analytical capabilities at last year's Ignite event.
Synapse also gained some new toys in Public Preview at Build (something Kumar described as a "milestone"). The analytics service added new Synapse SQL features and, inevitably, built-in Power BI authoring. The widening of the preview also means that more users can check out if the team's performance and ease of use claims cut the mustard.
However, getting data from operational systems into analytical services has traditionally been a bit of pain. The new Link functionality allows customers to hit that real-time transactional data in Azure without adding a burden to operational systems.
There are, of course, gotchas.
It is undoubtedly neat if you're in the Microsoft ecosystem, but right now Azure Synapse Link only supports Azure CosmosDB in the preview. Other Azure databases such as PostgreSQL, MySQL or even Azure SQL are still in the "coming soon" bucket, which is a little disappointing.
Kumar assured us that the gang were "actively working on both SQL and Postgres", but that "there is a certain set of priorities that every team works through" and CosmosDB came out ahead.
A frequent complaint levelled at Microsoft is that much of the new stuff depends on the Azure cloud while many customers still prefer to keep their data close at hand. Azure Stack is an oft-touted solution to the problem, but Kumar pointed to Microsoft's crack at multi-cloud, Azure Arc, for an indication of where Synapse might go next.
"That could be the next step in the journey," he said, "if a customer is willing to maintain connectivity with Azure, where we're able to get a certain amount of telemetry, then progressively we can add more and more capabilities."
The cloud-versus-on-premises argument continues to rage concerning SQL Server 2019. Could that be the last major on-premises release of the former flagship? "No, absolutely not," stated Kumar. However, he added: "Here's the thing: if you look at the kind of investments we are making in SQL Server, even on-prem, it's essentially not just to support the customers, but to prepare them for the transition to the cloud."
That transition continues to rumble on as Microsoft attempts to persuade those still on the elderly 2008 and 2008 R2 platforms to move to something more modern (faced with the IT curse that those boxes simply work, and most admins know that if something works, it is best not to go fiddling with it).
And the on-premises versus cloud balance? At present it stands at around half and half. There are an awful lot of SQL Servers still alive and well in data centres around the world.
Sponsored: Webcast: Simplify data protection on AWS
- EDA moves to the cloud - eeNews Europe - December 29th, 2020
- One Option You Shouldnt Overlook When Setting Up a Security Camera - The New York Times - December 29th, 2020
- This is the best Google Cloud Print alternative - Android Police - December 29th, 2020
- Finding the balance between edge AI vs. cloud AI - TechTarget - December 29th, 2020
- Cybercriminals to focus on remote and cloud-based systems in UAE next year - Gulf Business - December 29th, 2020
- Top 10 Hyperconverged Infrastructure (HCI) Solutions - Datamation - December 29th, 2020
- The Diminishing Role of Operating Systems | IT Pro - ITPro Today - December 29th, 2020
- Building a Better U.S. Approach to TikTok and Beyond - Lawfare - December 29th, 2020
- Legacy IT: The hidden problem of digital transformation - SC Magazine - December 29th, 2020
- TGen Leverages phoenixNAP's Hardware-as-a-Service Powered by Intel to Empower COVID-19 Research - PR Web - December 29th, 2020
- Global Cloud Server Market Share, Competition Analysis, COVID-19 Impact Analysis & Projected Recovery, and Market Sizing & Forecast to 2026 -... - December 29th, 2020
- Private Cloud Server Market Report, History And Forecast 2020-2025, Breakdown Data By Manufacturers, Key Regions, Types And Application - The Monitor - December 29th, 2020
- Bare Metal Cloud Market Poised to Expand at a Robust Pace Over 2025 - Farming Sector - December 29th, 2020
- 4 reasons your business needs to switch to cloud servers - TechEngage - December 19th, 2020
- Microsoft is designing its own ARM-based processor for Surface and cloud servers - Digital Trends - December 19th, 2020
- Dedicated server or cloud server: which one to choose? - Business MattersBusiness Matters - December 19th, 2020
- Cybersecurity expert: After Russian hack, common security tools, including cloud-based multi-factor systems, shown to be less effective in preventing... - December 19th, 2020
- Remote and cloud-based systems to be ruthlessly targeted next year - Help Net Security - December 19th, 2020
- The ROI of Cloud-Based Email - TechDecisions - December 19th, 2020
- The Advantages of Running your ERP Off-Premise During the COVID-19 Era - BBN Times - December 19th, 2020
- The balkanization of the cloud is bad for everyone - MIT Technology Review - December 19th, 2020
- When Is a Good Time For SMBs To Move Their IT Infrastructure To the Cloud? - Entrepreneur - December 19th, 2020
- AWS reveals array of new cloud observability and other new tools at re:Invent - SiliconANGLE News - December 19th, 2020
- TaxBandits Offers Cloud Based Solution For E-filing Forms W-2, 1099, 94x Series, and ACA 1095 for 2020 Tax Year. - CPAPracticeAdvisor.com - December 19th, 2020
- Programmable NICs Will Empower the Future of the Network - CEOWORLD magazine - December 19th, 2020
- Amazon's weird Halo band is now available if you want to pay $4/month for fitness tracking - Android Police - December 19th, 2020
- Microsoft Says Its Systems Were Exposed to SolarWinds Hack - Data Center Knowledge - December 19th, 2020
- Holiday-proof your Business with Cloud Solutions - The Edge Markets MY - December 19th, 2020
- Gurucul Cloud-native Analytics-driven XDR Platform Sets New Standard for Real-Time Threat Detection and Incident Response - Business Wire - December 19th, 2020
- Run Kubernetes at the edge with these K8s distributions - TechTarget - December 19th, 2020
- How Technology Is Revolutionizing the Unorganized Parking Sector in India and the Road Ahead - News18 - December 19th, 2020
- Cloud Server: The advantages and why Kronos Cloud is worth trying - Programming Insider - December 6th, 2020
- Amazon details cause of AWS outage that hobbled thousands of online sites and services - GeekWire - December 6th, 2020
- Can we really trust the Cloud with our data? - The Next Web - December 6th, 2020
- An Introduction to Cloud Computing | Ethical Hacking | EC-Council Blog - EC-Council Blog - December 6th, 2020
- Google Cloud Will Not Be Able To Overtake Microsoft Azure - Forbes - December 6th, 2020
- Google builds out Cloud with Actifio acquisition Blocks and Files - Blocks and Files - December 6th, 2020
- 5 advantages of a cloud disaster recovery plan - BAI Banking Strategies - December 6th, 2020
- Your Digital Transformation Will Be as Successful as the Foundation Its Built On - CMSWire - December 6th, 2020
- Kubernetes: What You Need To Know - Forbes - December 6th, 2020
- 3 cloud computing trends to watch in 2021 - TechHQ - December 6th, 2020
- Amazon Web Service Explains Its Major OutageAnd Other Small Business Tech News - Forbes - December 6th, 2020
- How AWS is computing the future of the cloud - SiliconANGLE News - December 6th, 2020
- ONF Announces Aether 5G Connected Edge Cloud Platform Being Used as the Software Platform for Pronto Project - sUAS News - December 6th, 2020
- International health IT week in review: December 6 - Pulse+IT - December 6th, 2020
- Lenovo boosts low end all-flash array with end-to-end NVMe - Blocks and Files - December 6th, 2020
- Bull of the Day: Baidu (BIDU) - Yahoo Finance - December 6th, 2020
- A re:Invent like no other shows an AWS capitalizing on 2020 chaos - Diginomica - December 6th, 2020
- The Mystery Behind the Aarogya Setu App - TheLeaflet - The Leaflet - December 6th, 2020
- People Cant Vacuum Or Use Their Doorbell Because Amazons Cloud Servers Are Down - Gizmodo Australia - November 26th, 2020
- Inside Innovation: 'In the cloud we trust' doesn't hack it for ransomware protection - Daily Commercial News - November 26th, 2020
- Will edge computing become the new cloud in 2021? - TechRepublic - November 26th, 2020
- Cloud Server Market ? What Factors Will Drive The Market In Upcoming Years And How It Is Going To Impact On Global Industry | (2020-2026) - The... - November 26th, 2020
- IP surveillance: The storage it needs, on-premise and in the cloud - ComputerWeekly.com - November 26th, 2020
- Does AD CS Work in the Cloud? - Security Boulevard - November 26th, 2020
- SKT Unveils its AI Chip and New Plans for AI Semiconductor Business - HPCwire - November 26th, 2020
- Calculating the Total Cost of Hybrid Cloud - Data Center Knowledge - November 26th, 2020
- Cloud Server Market Research Report: Overview With Geographical Segmentation By Revenue With Forecast 2026 - Cheshire Media - November 26th, 2020
- Cryptomining Worm Uses Third-Party Software to Target Cloud - Security Intelligence - November 26th, 2020
- SKT new AI chip changes the company's AI semiconductor bu... - evertiq.com - November 26th, 2020
- Should IT Support Always Be Handled In-House? Are There Other Options? - ABCmoney.co.uk - November 26th, 2020
- Home Automation System Market worth $63.2 billion by 2025 - Exclusive Report by MarketsandMarkets - PRNewswire - November 26th, 2020
- Global Managed Servers Industry Market Growth Graph To Demonstrate Inclination Towards Positive Axis By 2026 - The Courier - November 26th, 2020
- Everett Police will put body cameras on all its officers - Snohomish County Tribune - November 26th, 2020
- NetRange moves browser to the cloud in new smart TV range - Broadband TV News - November 26th, 2020
- Hackers steal and save Spotify login information - Somag News - November 26th, 2020
- Three Reasons Why You Should Invest in Cloud-based Email - My TechDecisions - TechDecisions - November 4th, 2020
- No way to go but up as cloud solutions shape the future of business - CNN Philippines - November 4th, 2020
- The global cyber insurance market is expected to reach a value of $70,671.9 million by 2030, from $5,573.2 million in 2019 - Yahoo Finance - November 4th, 2020
- Moving to cloud-native applications and data with Kubernetes and Apache Cassandra - JAXenter - November 4th, 2020
- How Digital Twins Accelerate the Growth of IoT - IoT For All - November 4th, 2020
- Bluebeam expands its global Studio data infrastructure - Planning, BIM & Construction Today - November 4th, 2020
- The journey to a cloud BSS - Ericsson - November 4th, 2020
- Edge computing strategies will determine the next cloud frontier - TechTarget - November 4th, 2020
- How do we protect the hybrid workplace? - TechHQ - November 4th, 2020
- Evolution of File Sharing and its method - InfotechLead.com - November 4th, 2020
- Amazon: The Coming Graviton3 - Seeking Alpha - November 4th, 2020
- Windows Admin Center is Coming to the Azure Portal - Petri.com - November 4th, 2020
- Sophos Uncovers Attackers Targeting Non-Governmental Organizations in Myanmar With New 'KilllSomeOne' Backdoor - GlobeNewswire - November 4th, 2020
- IBM Delivered An RDi Update, Too - IT Jungle - November 4th, 2020