Select Page
Example of invoking the AutoMLTrain procedure.

Automated machine learning from SQL Server with Azure Machine Learning

This post was co-authored by Jeff Shepherd, Deepak Mukunthu, and Vijay Aski. Recently, we blogged about performing automated machine learning on SQL Server 2019 big data clusters. In todays post, we will present a complementary automated machine learning approach leveraging ... continue reading
3 ways to gain insights with SQL Server 2019 big data clusters

3 ways to gain insights with SQL Server 2019 big data clusters

Businesses today are faced with the challenge of staying profitable and investing in future innovations. Speed and flexibility are the name of the game, and effective data-scaling techniques are highly sought after. Yet exploding data volumes, diverse data types, and ... continue reading
Link to SQL Server Big Data Cluster.

How to develop and submit Spark jobs to SQL Server Big Data Clusters in IntelliJ

Were delighted to release the Azure Toolkit for IntelliJ support for SQL Server Big Data Cluster Spark job development and submission. For first-time Spark developers, it can often be hard to get started and build their first application, with long ... continue reading

The Cloud Database Administrator—Tech success at scale

As a database administrator (DBA), Ive always known what the role involved. Developers swing by my desk requesting a new database, a data refresh, or help with challenges theyre facing. They sometimes get frustrated with me when their database or ... continue reading
Back up SQL Server in Azure VM using Azure Backup.

Enterprise-scale Backup for SQL Server Databases

More and more organizations are moving to the cloud to leverage the key benefits of agility and reduce overall cost. Its likely that at some point in time, your SQL Server will manifest as either of the three implementations in ... continue reading
Identify log write limits on Azure SQL Managed Instance using QPI library

Identify log write limits on Azure SQL Managed Instance using QPI library

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify ... continue reading
Running Azure CosmosDB queries from SQL Server using ODBC driver

Running Azure CosmosDB queries from SQL Server using ODBC driver

Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql. Why querying CosmosDB from SQL Server? Cosmos DB enables ... continue reading
Monitor local storage usage on General Purpose Azure SQL Managed Instance

Monitor local storage usage on General Purpose Azure SQL Managed Instance

Azure SQL Managed Instance has predefined storage space that depends on the values of reserved storage and vCores that you choose when you provision the instance. In this post you will see how to monitor storage space on the Managed ... continue reading

Free cloud data services training roundup

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free data and artificial intelligence (AI) trainings in one convenient post. SQL Server and Windows Server 2008 end of support End ... continue reading
Sending resource alerts on Managed Instance using db_mail

Sending resource alerts on Managed Instance using db_mail

One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don’t have enough CPU. In this case you would need to get the bigger instance; however, this is not ... continue reading