(Erin Stellato) In my last post, I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one.
Other News
Azure Synapse Analytics confusion
(James Serra) I see a lot of confusion among many people on what features are available today in Azure Synapse Analytics (formally called Azure SQL Data Warehouse) and what features are coming in the future.
Building a Matching Pairs Memory Game Using Knockout JS
(Rawan Nassar) All of us want to improve mind memory and concentration. Certainly, we know “match pairs memory game.” It is an amazing game that increase memory power.
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’
(Pinal Dave) Recently one of my clients contacted me to provide them assistance in finding and fixing the cause of a huge transaction log file. There are many caused to get error 9002 in SQL Server ERRORLOG.
Shutdown with MySQL 8
(Shinguz) On StackExchange for Database Administrators I recently have seen a question which attracted my interest.
What’s New for Azure Cosmos DB SDKs for .NET and Java
(David Ramel) Azure Cosmos DB is a globally distributed, multi-model database service, helping users and developers elastically and independently scale throughput and storage across Azure regions with a click of a button.
Add Discord Notifications to ASP.NET Core Apps
(Steve Smith) I’m continuing to have fun building out features for the devBetter site, which provides resources for my group coaching members. We meet weekly to answer questions, work through exercises together, and share progress, but we also have a very active Discord server where we do a lot of t
Replacing AJAX calls in Razor Pages with Razor Components and Blazor
(Andrew Lock) In a recent post I looked at whether you should consider using Razor Components in places where you would previously have used View Components.
Far Sync, Redo routes and Priorities with alternates
(Pieter Van Puymbroeck) Far Sync is a great technology. When implementing a Disaster Recovery (DR) scenario, the first remark is usually “We want zero Data Loss”. This is exactly what Data Guard is meant for in Synchronous mode.
Deadlock Caused by Row Cache and Library Cache Locks
(Nenad Noveljic) I’ve been occasionally seeing deadlocks like the following one: