Showing tag results for azuresql

Jan 21, 2021
Post comments count3
Post likes count0

Solving the River Crossing problem with SQL Graph

Arvind Shyamsundar
Arvind Shyamsundar

Graph theory and associated techniques are extremely powerful. Azure SQL allows native representation of graphs as node and edge tables, and provides breadth-first-search traversal for native path finding. This blog post demonstrates the ease of use, and great power of, these features by using them to solve the classic river crossing riddle!

Azure SQL
Dec 11, 2020
Post comments count1
Post likes count4

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser

Arvind Shyamsundar
Arvind Shyamsundar

Azure SQL developers have access to a full-fidelity, highly accurate, and easy-to-use client-side parser for T-SQL statements: the TransactSql.ScriptDom parser. This blog post walks through basic usage, and links to a number of resources for digging deeper.

Azure SQLDevOps.NET
Dec 10, 2020
Post comments count2
Post likes count0

Azure SQL can read Azure Data Lake storage files using Synapse SQL external tables

Jovan Popovic
Jovan Popovic

Serverless Synapse SQL pool in Azure Synapse Analytics is a T-SQL query engine that enables you to read the files placed on Azure storage. You can easily integrate your Azure SQL engine with Synapse SQL to delegate big data analytics and analyze large amounts of data placed on Azure.

Azure SQLBig Data
Oct 20, 2020
Post comments count4
Post likes count0

Testing performance of Azure SQL Database as a key-value store

Dimitri Furman
Dimitri Furman

Executive summary Our testing shows that Azure SQL Database can be used as a highly scalable low latency key-value store. Starting with a cost-efficient 4-core General Purpose database, we see an order of magnitude increase in workload throughput as we increase dataset size by 100x and scale across the spectrum of database SKUs to a Business Criti...

Azure SQL
Oct 8, 2020
Post comments count0
Post likes count0

Running 1M databases on Azure SQL for a large SaaS provider: Microsoft Dynamics 365 and Power Platform.

Silvano Coriani
Silvano Coriani

  Thriving on Azure SQL   Many thanks to our colleagues Mahesh Sreenivas, Pranab Mazumdar, Karthick Pakirisamy Krishnamurthy, Mayank Mehta and Shovan Kar from Microsoft Dynamics team for their contribution to this article.   Overview Dynamics 365 is a set of intelligent SaaS business applications that helps companies of a...

Azure SQL