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.

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

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=

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

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

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/

In this week’s episode, we are joined by special guests Khalid Abuhakmeh. Join us to find out why Khalid loves static site generators!

Khalid Abuhakmeh: (https://twitter.com/buhakmeh and https://khalidabuhakmeh.com/)

Jekyll: https://jekyllrb.com/
Hexo: https://hexo.io/
Eleventy: https://www.11ty.dev/
jekyll-aspnet-core: https://github.com/khalidabuhakmeh/jekyll-aspnet-core
Algolia: https://www.algolia.com/
Jamstack | JavaScript, APIs, and Markup: https://jamstack.org/
Azure Static Web Apps: https://azure.microsoft.com/en-us/services/app-service/static/

Playwright is a relatively new entrance to browser automation. Written in nodejs, it offers a single API to automate Chromium, Firefox and Webkit while promising to be capable, reliable and fast. In today’s episode, we take Playwright for a spin and see if it delivers on those promises.

Playwright: https://playwright.dev/

Getting the logic right when dealing with dates is hard in any application but it’s even harder when your application logic crosses platform boundaries. In today’s episode, we take a look at some of the common issues faced when trying send user entered dates in a browser based JavaScript application to a .NET Core based server side process.

Sample Repo: https://github.com/AspNetMonsters/EP170_EFCoreNodaTime

Previous episode:
NodaTime and JavaScript Dates (Vue edition): https://youtu.be/OG9KYoj92OU
NodaTime and API Controllers: https://youtu.be/NnUoOdnsIko
Noda Time and Entity Framework Core: https://youtu.be/zl0h2J6a0w4

Noda Time: https://nodatime.org/
Luxon: https://moment.github.io/luxon/index.html

Azure Data Studio is a lightweight alternative to the often clunky SQL Server Management Studio.

Azure Data Studio: https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio
SQL Server Profiler Extension: https://docs.microsoft.com/sql/azure-data-studio/sql-server-profiler-extension
List of Extensions: https://github.com/microsoft/azuredatastudio/wiki/List-of-Extensions