(Grant Fritchey) Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but, without actually doing any work to capture query metrics?
Author: SSWUG Research
How To Use Async Pipe In Angular 8
(Siddharth Gajbhiye) In this article, we will learn how to use async pipe in Angular 8 application. We start off with defining an Async pipe and listing its advantages, followed by how to use the code.
Update SQL Server 2017 on Linux Container
(Edwin Sarmiento) Our company has started evaluating Containers to modernize our SQL Server databases. I have deployed SQL Server 2017 RTM on Linux for our development environments and would like to get it updated. How do I update my SQL Server 2017 on Linux containers?
Generating sequences/ranges, via MySQL 8.0’s Common Table Expressions (CTEs)
(Saverio Miroddi) A long-time missing (and missed) functionality in MySQL, is sequences/ranges.
How to Train a Machine Learning Radial Basis Function Network Using C#
(James McCaffrey) A radial basis function network (RBF network) is a software system that is similar to a single hidden layer neural network. In this article I explain how to train an RBF network classifier.
Avoiding Self-Closing IFRAME Tags Using htmlParse() In Lucee CFML 5.3.4.80
(Ben Nadel) Over the past week, I’ve been working to retrofit Markdown onto all of my old blog content using Lucee CFML. It’s been an exciting journey with a lot of trial and error. For example, the other day, I realized the .xmlText property wasn’t giving me escaped HTML entities; and, just this mo
IIS Hosting for ASP .NET Core 3.1 Web Apps
(Shahed C) This is the ninth of a new series of posts on ASP .NET Core 3.1 for 2020. In this series, we’ll cover 26 topics over a span of 26 weeks from January through June 2020, titled ASP .NET Core A-Z!
SQL Developer Keyboard Shortcuts: The Movie!
(Jeff Smith) Short post today, and short video – but the content could save you HOURS of coding and working with your Oracle Database!
Patch the 2 node RAC in OCI with DBCLI
(Skant Gupta) In this post, we will perform patching on BM (Bare Metals) and VM ( Virtuals Machine) database systems by using DBCLI on the 2-Node RAC running on Oracle Database 19c.
MERGE burns Sequence Numbers
(Marco Mischke) In my previous blog post I wrote about the MERGE statement and how it can efficiently be used. During the implementation of this solution a colleague stumbled upon some very high values numbers for the sequence he used to generate the IDs.