(Robert Dorr) I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article.
Community
Making a GUID Creator in .NET
(Hannes DuPreez) Welcome to my article. Knowledge is relative. Education is relative. Experience is relative. It all boils down to what you can remember and how fast you can remember stuff.
SQL SERVER – 5061: FIX Error: ALTER DATABASE failed because a lock could not be placed on database ‘Database Name’. Try again later.
(Pinal Dave) Every consulting engagement is different and I get to learn new things. In this blog post, I will share what I learned during my recent Comprehensive Database Performance Health Check.
Architecting Blazor (and Integrating JavaScript)
(Peter Vogel) In a previous column I covered the mechanics of integrating Blazor and JavaScript to support extending existing JavaScript-enabled pages with Blazor code.
MySQL NDB Cluster row level locks and write scalability
(Bernd Ocklin) MySQL NDB Cluster uses row level locks instead of a single shared commit lock in order to prevent inconsistency in simultaneous distributed transactions.
Internet Intelligence – Checking on the accessibility of your web application from Anywhere in the world – for free with Oracle Cloud Infrastructure
(Lucas Jellema) A valuable capability that organizations using Oracle Cloud Infrastructure have available is internet intelligence. This capability allows you to monitor the health and accessibility of your web site’s or web application’s host – from over 30 locations across the world.
Did You Know #28 – Standby + RAC
(amitzil) In an Oracle Data Guard configuration, the primary and standby databases can have different configurations.
Partioning — 13a : Relocating a Partition
(Hemant K Chitale) When you want to / need to move a Partition to a different Tablespace (e.g. as part of a LifeCycle Management Policy), you may need downtime to relocate the Partition. However, version 12cRelease1 allows Online Relocation of a Partition.
Document and Test API with Swagger UI
(Benktesh Sharma) More than often, developers test API, either through a browser request or using some clients such as POSTMAN, Advanced Rest Client (ARC).
Overview of the SQL Order by clause
(Prashanth Jayaram) In this article, we’ll walk-through the concept of the SQL Order by clause and understand how the SQL engine works with the ordering result in a query.