Lesson Learned #491: Monitoring Blocking Issues in Azure SQL Database
Time ago, we wrote an article Lesson Learned #22: How to identify blocking issues? today, I would like to enhance this topic by introducing a monitoring system that expands on that guide. This PowerShell script not only identifies blocking issues but also calculates the total, maximum, average, and minimum blocking times.Lesson Learned #330: Blocking issues Sch-M and Sch-S
Today, I worked in a very interested case. Our customer is trying to run an ALTER TABLE <TableName> to add two columns but this process is taking too much time, even, when the documentation reported "Starting with SQL Server 2012 (11.x) Enterprise Edition, adding a NOT NULL column with a default value is an online operation when the default value is a runtime constant. This means that the operation is completed almost instantaneously despite the number of rows in the table, because the existing rows in the table aren't updated during the operation" https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=azuresqldb-current#adding-not-null-columns-as-an-online-operationLesson Learned #319: Lock request time out period exceeded using SSMS
Today, we got a service request that our customer got the following error message: Lock request time out period exceeded. (.Net SqlClient Data Provider) using SQL Server Management Studio. Following I would like to share with you some details about this issue and how to find and fix it.[Resolved] Adding cookies to the Allow list makes them bypass the 3rd party cookie blocking !?
When I turn on 3rd party cookie blocking, and add [*.]youtube.com [*.]google.com to the allow list of cookies this causes Google and YouTube cookies to be read and accessed in Reddit and other sites, Even though 3rd party Cookie blocking is enabled. Edge (or Chromium in general, since it happens on Chrome 88 stable too) is confused. that Allow list is for allowing certain cookies to enter or stay in the browser, the Allow list is Not a 3rd party cookie bypass list. my actual setup and configuration was more complex but I had to do lots of testing to find out why Reddit still detects and asks me to sign into my Google account when 3rd party cookie blocking is enabled!Add Audio-only blocking to Media autoplay blocking in Edge browser
Currently the media Auto-play blocking options (Allow, Limit, Block) only apply to Videos. but what if we want the video to be auto-played, but its audio be muted by default? so I think these options needed to be added to that settings page which also has lots of vacant space left to be filled with useful options. edge://settings/content/mediaAutoplay Block Audio Block Video Block Audio and Video (should also block Auto-Buffering/preloading of media)List of the REMOVED features in the latest Edge insider Canary update Version 79.0.305.0
1. Block option is Removed and only Limit and Allow is available You can confirm this too by going into your settings edge://settings/content/mediaAutoplay 2. Another removed option in this latest Canary update in the previous Canary version (79.0.304.0) , the InPrivate mode window would look like this:
