(Greg Larsen) In the processes of executing a query the database optimizer calculates an estimate at the cost to run the query. This cost is determined based on statistics.
Author: SSWUG Research
Installing SQL Server 2019 on Azure VM
(blobeater) Unfortunately, this is not an on-premises SQL Server install because I do not have the right operating system available for SQL Server 2019, which includes the below:
How to Perform a Mail Merge in a Word Document in Java
(C# Curator) Mail merge is a very useful functionality in Microsoft Word that lets us quickly and easily generate a batch of documents from specific templates.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
(Pinal Dave) The other day I was hired by a large consulting organization that is managing database operations for the bank Comprehensive Database Performance Health Check. The organizations wanted to have lots of performance issues and we worked through them one at a time.
Evaluating Group Replication Scaling Capabilities in MySQL
(Vadim Tkachenko) In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections.
How to Do Kernel Logistic Regression Using C#
(James McCaffrey) Regular logistic regression is a machine learning technique that can be used for binary classification. An example is predicting whether a person is male or female based on predictor variables such as age, height, weight, and so on.
Running CFExecute From A Given Working Directory In Lucee CFML 5.2.9.31
(Ben Nadel) When you invoke the CFExecute tag in ColdFusion, there is no option to execute the given command from a particular working directory. That’s why I recently looked at using the ProcessBuilder class to execute commands in ColdFusion.
How to automatically choose a free port in ASP.NET Core 3.0
(Andrew Lock) This post is in response to a discussion I had with a friend recently who was trying out .NET Core.
DATAGUARD Using DBCA Silent Mode Is Not Setting DB_UNIQUE_NAME
(mdinh) Unfortunately, db_name=db_unique_name which is not ideal for Data Guard environment
Oracle Cloud Infrastructure (OCI) Part 4 – Virtual Cloud Network….
(Aman) In this installment of the series of OCI fundamentals, we shall understand with networking with OCI. And in this post, we shall look at what is virtual cloud network (VCN) in OCI. Let’s get started.