Monsters Weekly 191 - C# 9 Pattern Matching

C# 9 brings pattern matching to a fantastic place allowing you to express complex patterns cleanly. In this episode we’ll play with some of the patterns you can use to make your code cleaner and leaner.

Running Stored Procedures Across Databases in Azure

In a previous article I talked about how to run queries across database instances on Azure using ElasticQuery. One of the limitations I talked about was the in ability to update data in the source database. Well that isn’t entirely accurate. You can do it if you make use of stored procedures.

Monsters Weekly 190 - Using Elastic Query on SQL Azure

SQL Azure doesn’t let you run queries between database instances. But if you’re migrating off on premise databases where you’ve been able to do that you probably don’t want to rewrite a bunch of code. Turns out there is a way around that using SQL Azure Elastic Query.

Links
Documentation - https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview

Azure Processor Limits

Originally posted to: https://blog.simontimms.com/2020/11/05/2020-11-05-processor-limits/

Ran into a fun little quirk in Azure today. We wanted to allocate a pretty beefy machine, an M32ms. Problem was that for the region we were looking at it wasn’t showing up on our list of VM sizes. We checked and there were certainly VMs of that size available in the region we just couldn’t see them. So we ran the command

az vm list-usage --location "westus" --output table

And that returned a bunch of information about the quota limits we had in place. Sure enough in there we had

Name                               Current Value   Limit
Standard MS Family vCPUs 0 0

We opened a support request to increase the quota on that CPU. We also had a weirdly low limit on CPUs in the region

Total Regional vCPUs               0               10

Which support fixed for us too and we were then able to create the VM we were looking for.

Querying Across Databases In SQL Azure

I seem to be picking up a few projects lately which require migrating data up to Azure SQL from an on premise database. One of the things that people tend to do when they have on premise databases is query across databases or link servers together. It is a really tempting prospect to be able to query the orders database from the customers database. There are, of course, numerous problems with taking this approach not the least of which is making it very difficult to change database schema. We have all heard that it is madness to integrate applications at the database level and that’s one of the reasons.

Monsters Weekly 189 - New Features in Playwright 1.5

We continue our series on browser automation using Playwright, taking a look at a couple of new features: video recordings and playwright-test.

Previous Episode:
#188: Intercepting Network Requests with Playwright - https://youtu.be/PiIHeG3vEPs
#183: Cross Browser Automation with Playwright - https://youtu.be/75dzhaDkTxs

Playwright Video Verification: https://playwright.dev/#path=docs%2Fverification.md&q=videos
Playwright-test: https://github.com/microsoft/playwright-test

Monsters Weekly 188 - Intercepting Network Requests with Playwright

Browser automation is great for testing your application but sometimes it is difficult to test specific scenarios. For example, testing a scenario when your backend service returns a specific set of data or maybe an error code. Fortunately, Playwright makes this easy by providing a simple mechanism for intercepting network requests.

Previous Episode:
#183: Cross Browser Automation with Playwright - https://youtu.be/75dzhaDkTxs

Playwright Network APIs: https://playwright.dev/#version=v1.4.0&path=docs%2Fnetwork.md&q=

Monsters Weekly 187 - Windows Terminal with Kayla Cinnamon

In this episode we’re pleased to have Kayla Cinnamon (https://twitter.com/cinnamon_msft), PM of the Windows Terminal Team on chatting about the multi-shell terminal management tool from Microsoft. It slides easily into your development tool chain and makes it easy to customize your experience for not only which shell you’re using, but also the behaviours and look-and-feel of the shell.

Install the tooling:
choco install powershell-core
choco install gh
choco install poshgit
choco install microsoft-windows-terminal

Adjust profile settings:
https://docs.microsoft.com/en-us/windows/terminal/customize-settings/profile-settings

Learn and customize bindings:
https://docs.microsoft.com/en-us/windows/terminal/customize-settings/actions

Stay connected with update from Kayla on her blog
https://devblogs.microsoft.com/commandline/author/cinnamonmicrosoft-com/

Follow Kayla on Twitter
https://twitter.com/cinnamon_msft

Monsters Weekly 186 - Some Basic Linux Commands

In this video we go through a few of the most basic Linux commands and touch on the file system layout.

Monsters Weekly 185 - Azure Static Web Apps

In this week’s episode, we take a look at the new Static Web Apps service in Azure.
https://docs.microsoft.com/en-ca/azure/static-web-apps/