For today’s post, I would like to share a video from “Microsoft Developer,”  YouTube Channel. Talking about working with Azure SQL optimizing  for Virtual Machine storage, is a critical areas to focus on when architecting for performance with SQL Server, on a  Azure Virtual Machines.

Virtual machines have input/output operations per second and throughput performance limits based on the virtual machine type and storage limits. This is part one of this seven-part VM series, that cover how capping occurs at the virtual machine and storage levels and how caching can help remove the impact of  these performance limits, link below to the video.

Click here for the video.

Information about Drupal 10, has a release around June 2022. Link below to a blog by Dries Buytaert, talking about what is new to Drupal 10, what is going to happen with Drupal 9, has an end-of-life date in November 2023

Click her for the blog.

 

 

For this post, I going to talk about a new service from Microsoft Azure Cloud, called Bicep, currently in preview. Bicep is a language for deploying Azure resources. You can use Bicep instead of JSON for developing your Azure Resource Manager templates (ARM templates).  Example of the differences from Bicep to JSON is below, when it comes to author a expressions, also declares a variables in Bicep.

To author an expression, and declare a variables in Microsoft Bicep:

 

                Bicep, you would write “func()”

                JSON, you would write "[func()]"

 

                Bicep, to declare a variable you would write “var demoVar = 'example value'

                JSON, to declare a variable you would write "variables": {"demoVar": "example value"},

 

Remember Bicep simplifies the coding experience by providing concise syntax, better support for code reuse, and improved type safety. Also Bicep is a domain-specific language (DSL), which means it's designed for a particular scenario or domain. Three link below with more information about s Microsoft Azure Cloud, Bicep

 

Information on Microsoft Azure Cloud Bicep language, link below.

  Click here for the website

Website comparing JSON and Bicep for templates, link below.

  Click here for the website

Azure Bicep demo, from October 2020, link below to a video.

  Click here for a video

 

 

 

 

Information on how to run SQL assessment checks in Azure SQL. SQL Assessment API provides a mechanism to evaluate the configuration of your SQL Server for best practices. The API is delivered with a rule set containing best practice rules suggested by SQL Server Team. The rules are designed for customization and extensible. Microsoft's rule set is designed to work for most environments. Users can write their own JSON files and customize existing rules or add new ones. link below.

 

Link below to a website, with a video.

Click here for the link.