One of the Azure SQL-related announcements that did not get a lot of publicity at May's Microsoft Build conference was the Azure SQL Database local database experience. With all the hype around SQL ...

About 5,500 of the SQL Server faithful came out for the PASS Summit 2018 in Seattle last November. As usual, the event had the feel of a great big family reunion. It’s always a fun time, with lots of ...

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...

Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks. While the embrace of big data, machine learning, and IoT by business enterprises everywhere may ...

Microsoft offers two paths for running enterprise databases: SQL Server, which you install and manage yourself, and Azure SQL, which Microsoft runs for you as a managed service. Both use the same ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Get ready to scale out SQL Azure databases beyond today's 50GB limit with the Transact-SQL and ADO.NET elastic sharding features, which are coming in the 2011 SQL Azure Federation Community Technology ...

With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...

One of the first things Microsoft Corporate Vice President Scott Guthrie did when he moved to the Azure team was to hold an offsite. He asked his team members to try building an Azure app using ...