The team spends some time with Srdan Bozovic to learn about SQL Managed Instances (SQL MI). 

Media file: https://azpodcast.blob.core.windows.net/episodes/Episode392.mp3

YouTube: https://youtu.be/yJKDdZf4pQw

Resources:

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

https://docs.microsoft.com/en-us/azure/azure-sql/database/security-best-practice

Media file: https://azpodcast.blob.core.windows.net/episodes/Episode369.mp3

Resources:

https://aka.ms/azuresqlyt --> Data Exposed / Data Exposed Live / Azure SQL 61 video series
https://aka.ms/azuresqlbook --> Azure SQL Revealed
https://aka.ms/azuresqlfordevelopers --> Practical Azure SQL Database for Modern Developers
https://aka.ms/learnliveazuresqlfundamentals --> Learn Live Azure SQL Fundamentals (6 week live series)
https://aka.ms/azuresqlfundamentals --> Learning Path on Microsoft Learn with free hands on exercises

YouTube Video: https://youtu.be/I42ikJ1IfU8

Other updates:

Our commitment to expand Azure Availability Zones to more regions (https://azure.microsoft.com/en-gb/blog/our-commitment-to-expand-azure-availability-zones-to-more-regions/)

Limited-time free quantities offer for Azure Synapse Analytics
https://azure.microsoft.com/en-us/blog/limited-time-free-quantities-offer-for-azure-synapse-analytics/
Do more for the National Security mission with Azure
https://azure.microsoft.com/en-us/blog/do-more-for-the-national-security-mission-with-azure/

Principal Architect Bob Ward makes another appearance to give us the latest technical details on the advances in SQL 2019 Big Data Clusters on Azure.

Media file: https://azpodcast.blob.core.windows.net/episodes/Episode313.mp3

Transcript: https://eus2.videoindexer.ai/accounts/e0eee289-7730-4999-978b-eb7f63be8cb5/videos/7984c7be05/?location=EUS2

Episode 200! We made it!

For this special landmark, Bob Ward, Principal Architect on the SQL Server Team, joins us again to talk about a topic we never thought we'd hear - the release of SQL Server on Linux - available in Azure and on-premises.

Media file: http://azpodcast.blob.core.windows.net/episodes/Episode200.mp3

http://aka.ms/sqldev

https://blogs.msdn.microsoft.com/bobsql

Indexed video: https://www.videoindexer.ai/media/b52d5370d4/

Other resources:

New Log Analytics query language
The new Log Analytics query language is available, and you can upgrade your workspace to take advantage of it with the following benefits:

✔ More extensive piping capabilities than the legacy language
✔ Advanced runtime calculated fields
✔ Advanced joins, including the ability to join tables on multiple fields, use inner and outer joins, and join on extended fields
✔ Advanced date/time functions

Azure Data Lake Tools for Visual Studio Code (VSCode) October Updates
https://azure.microsoft.com/en-us/blog/azure-data-lake-tools-for-visual-studio-code-vscode-october-updates/

Microsoft Cosmos DB in Azure Storage Explorer – public preview
https://azure.microsoft.com/en-us/blog/microsoft-cosmos-db-in-azure-storage-explorer-preview/

Announcing new Azure Government capabilities for classified mission-critical workloads
https://azure.microsoft.com/en-us/blog/announcing-new-azure-government-capabilities-for-classified-mission-critical-workloads/

The guys talk to Tara Raj, a PM in the SQL for Linux team about an open source tool called MSSQL Scripter that allows easy scripting of SQL and SQL Azure databases from any platform and integrates it into your DevOps flow.

Media file: http://azpodcast.blob.core.windows.net/episodes/Episode190.mp3

Indexed file: https://www.videoindexer.ai/media/306174b9d0 

You can now use mssql-scripter, an open-source command-line interface, to generate database scripts. Mssql-scripter is a multi-OS command-line equivalent of the widely used Generate and Publish Scripts Wizard experience in SQL Server Management Studio.
You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server (running anywhere), Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard *nix tools (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control. Then, you can execute the script in your existing SQL Database or SQL Data Warehouse deployment processes and DevOps pipelines with standard multiplatform SQL command-line tools such as sqlcmd.
Mssql-scripter is built using Python and incorporates the usability principles of the new Azure CLI 2.0 tools. The source code is on GitHub, and we welcome your contributions and pull requests. An installation and quick start guide is available.

https://azure.microsoft.com/en-us/updates/mssqlscripter

http://www.github.com/Microsoft/sql-xplat-cli

Other updates:

Introducing Enterprise Smart Contracts
https://azure.microsoft.com/en-us/blog/introducing-enterprise-smart-contracts/

Announcing the preview of App Service domain

More resource policy aliases

Azure Backup has expanded its service to cover all Azure Government regions.

What it is about:
Azure has a lot of VM families (A, D, E, F, G, … v1/v2/v3, etc). They all launched with a given set of purpose. Though in the end we have a lot of options to choose from. As I got the question to “Find the appropriate VM size” on a regular basis, I decided to write a small tool for this that could assist anyone with finding the cheapest & matching VM t-shirt size!
 Azure VM Chooser
 https://aka.ms/VMchooser

Instant recovery of files from Azure VM backups is generally available.
Protect your Azure VM with Azure Backup and recover files, disks, VMs from a recovery point. With instant restore, immediately validate your backups or mount application files to your application to retrieve items without having to download the entire data.
For more information, see the Azure documentation and the Azure VM file recovery blog.

https://azure.microsoft.com/en-us/updates/general-availability-instant-file-recovery-from-azure-vm-backups/

The guys have a great chat with Matt Usher, a Senior PM in the Azure team, on the Azure SQL Data Warehouse. Matt gives us the low-down on the  service and also provides some deep insights into the MPP technology used in the service. 

Azure SQL Data Warehouse Overview: http://aka.ms/sqldw
Create a new SQL Data Warehouse: http://aka.ms/newsqldw
Matt's Twitter: http://twitter.com/two_under

Media file: http://azpodcast.blob.core.windows.net/episodes/Episode115.mp3

Other updates for the week:

New Storage Explorer http://storageexplorer.com - cross platform tool and actively maintained.

Announcing more open options and choice on Microsoft Azure
https://azure.microsoft.com/en-us/blog/more-open-source-innovation-azure/

Build an Azure App Service to record Raspberry Pi Sensor Data
https://azure.microsoft.com/en-us/blog/build-an-azure-app-service-to-record-raspberry-pi-sensor-data/

Guidance for enterprises looking to take their application portfolio to the cloud
https://azure.microsoft.com/en-us/blog/guidance-for-enterprises-looking-to-take-their-application-portfolio-to-the-cloud/

Azure welcomes Parse developers
https://azure.microsoft.com/en-us/blog/azure-welcomes-parse-developers/

https://azure.microsoft.com/en-us/updates/ssl-connection-pricing-changes/
https://azure.microsoft.com/en-us/updates/swagger-support-for-azure-mobile-apps-net-server-sdk/

As part of our Engineer Series, the guys talk to Tomas Talius who is an architect in the Azure SQL team and gives us some insight into the product.

Media file: http://azpodcast.blob.core.windows.net/episodes/Episode92.mp3

Updates: 

Announcing the GS-Series: Adding Premium Storage Support to the Largest VMs in the Public Cloud

http://azure.microsoft.com/en-us/blog/azure-has-the-most-powerful-vms-in-the-public-cloud/

 http://azure.microsoft.com/en-us/updates/logic-apps-net-sdk-available/

where you can download the SDK and check out this week’s Logic Apps video https://youtu.be/N-ZDaKsH6BY?list=PLfyqq4V4zxGGkBHcts3vpPohtyKYZ7UiQ

You can use the following script to convert an Active Directory object GUID to an Azure Active Directory Immutable ID….  

Convert DirSync/MS Online Directory Immutable ID to AD GUID (and vice versa)

https://gallery.technet.microsoft.com/Covert-DirSyncMS-Online-5f3563b1

The guys talk with Rama Ramani (Azure CAT team) about a White Paper that he and his team recently published on upgrading cloud apps with minimal disruption.

White Paper: http://msdn.microsoft.com/en-us/library/dn790385.aspx

Media file: http://azpodcast.blob.core.windows.net/episodes/Episode41.mp3