(Pinal Dave) One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well.
Community
Cloud Backup Options for MySQL & MariaDB Databases
(Bart Oles) The principal objective of backing up your data is, of course, the ability to roll back and access your archives in case of hardware failure.
Common features in ASP.NET Core 2.1 WebApi: Validation
(AnthonyGiretti) Validating user input is a common scenario in a Web-based application. For production applications, developers often end up spending a lot more time and code on this task than we would like.
What Happens If You Set innodb_open_files Higher Than open_files_limit?
(James Lawrie) The settings of MySQL configuration variables have a fundamental impact on the performance of your database system.
Renaming a SQL Server instance on Ubuntu Linux
(Rajendra Gupta) In my previous articles, we installed the SQL Server 2019 CTP 2.1 on Ubuntu Linux. You can follow the below articles to prepare the SQL instance on Linux.
Important Java Keywords That You Must Know
(Rinu Gour) Java keywords are a reserved word that has a special meaning associated with it. For easy identification, they are usually highlighted in Java.
What product to use to transform my data?
(James Serra) If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake. And much of this data will need to be transformed (i.e. cleaned and joined together – the “T” in ETL).
Contact application – Upgrade Asp.net Core 2.0 to 2.1
(Jayesh Agrawal) In this article, we will look into steps for contact application – upgrade Asp.net Core 2.0 to 2.1, please see my previous articles about how we developed contact application:
Shared-Array Iteration Can Cause Thread Deadlocks In Lucee ColdFusion 5.2
(Ben Nadel) Yesterday, as we migrated some ColdFusion code from the Adobe ColdFusion 10 engine over to the Lucee ColdFusion 5 engine, we saw a lot of JVM threads enter a BLOCKED state once the code was put under load.
SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database databasename. CREATE DATABASE is aborted
(Pinal Dave) It is indeed a pleasure when we write a timeless article for SQL Server and DBAs read it after many years. In the year 2007, I wrote an article about an error related to Could not open a new database.