(Pinal Dave) Recently I was working with a client on Comprehensive Database Performance Health Check and we discovered that they are struggling with Memory issues. During the health check, we reached the point where we needed a investigate the data in memory for a single database.
Author: SSWUG Research
Multithreaded ALTER TABLE with pt-online-schema-change and myloader
(David Ducos) pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table.
Can’t Cast Object Type [Struct] To A Value Of Type [image] In Lucee CFML 5.3.4.77
(Ben Nadel) As I wrote about back in January, we were having some performance issues in one of our Lucee CFML services.
RMAN Restore From Tape
(mdinh) In my previous post, Testing RMAN Restore Validate From Tape , now I will perform actual restore.
Creating and Playing Sounds using HTML5
(After2050) In this article, we are going to see how we can create and play sounds using the latest version v3 of musquito.
Transfer SQL Server Maintenance Plans Between Servers
(Sergey Gigoyan) In the previous articles, we have learned how to create, configure and use SQL Server Maintenance Plans. Sometimes, it is needed to move these plans from one environment to another.
MySQL Security – Failed-Login Tracking and Temporary Account Locking
(Olivier Dasini) When thinking about security within a MySQL installation, you can consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
Working With PyTorch Tensors
(James McCaffrey) PyTorch is a Python language code library that can be used to create deep neural networks. The fundamental object in PyTorch is called a tensor. A tensor is essentially an n-dimensional array that can be processed using either a CPU or a GPU.
Exclude Work Item Types in Azure DevOps Projects
(Abhijit Jana) We can exclude Work Item types in Azure DevOps projects by enabling or disabling them based on the business need. For any Azure DevOps Project. You can keep only work item types which makes sense for your project, and rest you can exclude from the project by hiding them.
EF Core In depth – what happens when EF Core reads from the database?
(Jon P Smith) This article gives an “under the hood” view of what happens when EF Core reads in data from a database. I look at two types of database read: a normal query and a query that contains the AsNoTracking method in it.