(Ben Nadel) Last week, I shared some of my frustration over the elusive nature of State Management in a JavaScript Single-Page Application (SPA); and, my not-so-novel idea of a “Runtime” abstraction that would completely hide the very notion of state management from the application View.
Other News
Programming on Trees
(Nick Polyak) In this article, I present some very general programming concepts I came up with long ago, but have not implemented yet. I hope that, perhaps, the interest will be sufficient to motivate me to work on them.
SQL truncate enhancement: Silent Data truncation in SQL Server 2019
(Rajendra Gupta) In this article, we’ll take a look into SQL truncate improvement in SQL Server 2019.
ADF Task Flow Performance Boost with JET UI Shell Wrapper
(Andrejus Baranovskis) ADF application with UI Shell and ADF Task Flows rendered in dynamic tabs would not offer instant switch from one tab to another experience. Thats because tab switch request goes to the server and only when browser gets response – tab switch happens.
The Importance of mysqlbinlog –version
(Ceri Williams) When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk using encrypt_binlog
SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator
(Pinal Dave) Every day I spend a good amount of time with my regular and new clients, helping them with SQL Server Performance Tuning issues. Today, in this blog, I will discuss a situation faced where I was engaged in Comprehensive Database Performance Health Check.
HTTP-REPL Tool to test WEB API in ASP.NET Core 2.2
Today there are no tools built into Visual Studio to test WEB API. Using browsers, one can only test http GET requests.
SQL Server 2017 on Linux: Support for third-party AD providers
In the past, SQL Server on Linux has required SSSD to be configured for AD Authentication to work. SSSD is a very powerful service which provides support AD authentication and integration.
Bad Query Performance Tips Rebutted
(Grant Fritchey) Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over the internet, over and over.
Update! – Unexpected Behaviour With V$DIAG_ALERT_EXT
(Robert Crames) I wanted to know which “ORA-” Errors have occured in my Production-DB and issued a