(Ian Miell) The software industry is permeated with metaphors borrowed from architecture and construction.
Author: SSWUG Research
Why is the XLOCK table hint broken?
(Daniel Janik) Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses.
C#.NET – JSON Object Mapper
(Asma Khalid) JSON (JavaScript Object Notation) is one of the most commonly used data passing formats used in Web API(s) development. Parsing & manipulating complex JSON objects becomes quite the headache especially with array parsing technique.
SQL SERVER – Enable Additional Logging for SQL Server Agent
(Pinal Dave) When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs. In this blog, I would share my learning about logging about SQL Server Agent itself.
Addressing the Drop Column Bug in Oracle 18c and 19c
(David Fitzjarrell) The road of progress can be rough at times. Oracle versions 18 and 19 are no exception. Up until version 18.x Oracle had no issues with marking columns as unused and eventually dropping them.
Debugging ORA-1775
(Liron Amitzi) ORA-1775 “looping chain of synonyms” can be found online quite easily. But every time they talk about a real loop of synonyms (like syn1 -> syn2 -> syn3 -> syn1) and sometime about missing objects.
How to export AWS CLI CloudWatch data to Oracle using SQL*Loader
(Matthias Hoys) In my previous blog post I explained how you can load AWS CLI CloudWatch data into a MySQL database. In this blog post I will explain how you can do something similar using Oracle as database.
The Maybe Monad in C#: More methods
(Yacoub Massad) The Maybe Mona is a container that represents a value that may or may not exist. In this tutorial, I will go through some methods that make working with the Maybe monad easier.
Generating Meme Images In The Browser Using html2canvas In Angular 9.0.1
(Ben Nadel) Over the weekend, I was noodling on some ideas regarding image generation when I came across a blog post about “screenshots” by Daniel Sternlicht.
Creating Certificates in .NET Core for Vue.js development using HTTPS
(damienbod) This article shows how to create development certificates for a Vue.js application, so that you can develop using HTTPS. The certificates are created using the CertificateManager nuget package.