Microsoft rolls out red carpet to hybrid Azure SQL databases

Redmond pitches tools for cloud byte-silo moves

On Wednesday, Microsoft showed off a series of new tools and services aimed at helping companies bridge gap between their on-premise SQL databases and its Azure cloud database offerings.

The tools, shown off at the PASS Summit in Seattle, are designed to help companies manage Azure cloud databases, SQL Server 2017 databases, and combinations of the two in hybrid setups, as well an update to the Power BI data analysis tool.

The aim of the updates, says Microsoft Database Systems Engineering general manager Rohan Kumar, is a familiar refrain among cloud database vendors: create a powerful cloud-only service while also maintaining support for companies that want to stick with their on-premises systems, either partially or entirely.

Among the new tools are two services Microsoft is testing in private previews, a 'lift and shift tool' called Azure Database Migration Service that, as its name implies, helps move on-prem SQL, MySQL and Oracle Database servers into Azure instances. Also in private preview is Managed Azure SQL database, a cloud instance designed to be managed closely with on-premise SQL.

Redmond also gave a short preview of Microsoft SQL Operations Studio, a tool out in the next few weeks for making databases using SQL Server, Azure SQL Database, and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Kumar told The Register that in addition to the technical hurdles for managing cloud, on-prem and hybrid systems, Microsoft has also found a challenge in convincing companies and developers who have grown familiar with SQL server to embrace new features, such as integration with machine-learning tools, that have been offered in Azure and hybrid databases.

"We are going from static queries to machine learning and AI, how do you make that seamless to the developers" Kumar said. "How do you make that journey where what you have to learn is close to minimal?"

To help integrate some of those tools, Microsoft said it put features like integration with Python and R scripts into SQL Server 2017.

This, it is hoped, will simplify the process of integrating machine learning libraries with SQL and also allow developers and researchers to work directly in SQL Server, rather than force them to migrate, while also letting SQL Server take advantage of the GPU processing many Python-based AI scripts employ. ®

Other stories you might like

  • Will this be one of the world's first RISC-V laptops?
    A sneak peek at a notebook that could be revealed this year

    Pic As Apple and Qualcomm push for more Arm adoption in the notebook space, we have come across a photo of what could become one of the world's first laptops to use the open-source RISC-V instruction set architecture.

    In an interview with The Register, Calista Redmond, CEO of RISC-V International, signaled we will see a RISC-V laptop revealed sometime this year as the ISA's governing body works to garner more financial and development support from large companies.

    It turns out Philipp Tomsich, chair of RISC-V International's software committee, dangled a photo of what could likely be the laptop in question earlier this month in front of RISC-V Week attendees in Paris.

    Continue reading
  • Did hoodwink Americans with IRS facial-recognition tech, senators ask
    Biz tells us: Won't someone please think of the ... fraud we've stopped

    Democrat senators want the FTC to investigate "evidence of deceptive statements" made by regarding the facial-recognition technology it controversially built for Uncle Sam. made headlines this year when the IRS said US taxpayers would have to enroll in the startup's facial-recognition system to access their tax records in the future. After a public backlash, the IRS reconsidered its plans, and said taxpayers could choose non-biometric methods to verify their identity with the agency online.

    Just before the IRS controversy, said it uses one-to-one face comparisons. "Our one-to-one face match is comparable to taking a selfie to unlock a smartphone. does not use one-to-many facial recognition, which is more complex and problematic. Further, privacy is core to our mission and we do not sell the personal information of our users," it said in January.

    Continue reading
  • Meet Wizard Spider, the multimillion-dollar gang behind Conti, Ryuk malware
    Russia-linked crime-as-a-service crew is rich, professional – and investing in R&D

    Analysis Wizard Spider, the Russia-linked crew behind high-profile malware Conti, Ryuk and Trickbot, has grown over the past five years into a multimillion-dollar organization that has built a corporate-like operating model, a year-long study has found.

    In a technical report this week, the folks at Prodaft, which has been tracking the cybercrime gang since 2021, outlined its own findings on Wizard Spider, supplemented by info that leaked about the Conti operation in February after the crooks publicly sided with Russia during the illegal invasion of Ukraine.

    What Prodaft found was a gang sitting on assets worth hundreds of millions of dollars funneled from multiple sophisticated malware variants. Wizard Spider, we're told, runs as a business with a complex network of subgroups and teams that target specific types of software, and has associations with other well-known miscreants, including those behind REvil and Qbot (also known as Qakbot or Pinkslipbot).

    Continue reading

Biting the hand that feeds IT © 1998–2022