(Pinal Dave) Recently, I had a very interesting situation while working with my client on the Comprehensive Database Performance Health Check. Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan.
Community
Forwarding Refs In React
(Sumit Kharche) In this article, we will be discussing another concept about Refs called Forwarding Refs. But before understanding Forwarding Refs we have to first understand what ref is, why we have to use it and how to create it.
Version 9.1 of Angular Now Available — TypeScript 3.8, faster builds, and more
(Stephen Fluin) We just released Version 9.1 of Angular. This is a minor release of the framework and the CLI that is a drop-in replacement for 9.0 containing new features and bug fixes.
Oracle Cloud Infrastructure(OCI) Overview
(Jagruti Jasleniya) Oracle Cloud Infrastructure , as its name suggests provides you a full infrastructure to run your application. It is a set of cloud services that supports you to build and run an extensive range of services and applications with high availability , scalability and high performanc
Putting DEBUG Comments In Your SQL Statements Makes FusionReactor Query Tracing More Effective
(Ben Nadel) For years, I’ve been advocating that people put DEBUG comments in their SQL statements to help identify performance bottlenecks in their applications.
Controlling table encryption in MySQL 8.0
(Gopal Shankar) MySQL 5.7.11 introduced InnoDB transparent tablespace encryption, which enabled support for file-per-table tablespaces, and this feature is discussed in this blog.
Simple DBCC CHECKDB process to report on database corruption for all SQL Server databases
(Alejandro Cobar) As DBAs, we all know how important it is to check all of the SQL Server databases under our care for potential corruption issues.
How long will my database upgrade take? Revisited …
(Mike.Dietrich) I received this question twice within a few days. And I remember that a tiny little while ago I wrote something on the blog about it.
C#: The Order of Interfaces Is Important for Casting Performance
(Thomas Claudius Huber) Recently there was a discussion in a Pull Request for the .NET runtime on GitHub. In the discussion it was mentioned by Jan Kotas from Microsoft that the order of interfaces is important for the casting performance.
Using MySQL Enterprise Audit Filtering for only Insert/Update/Delete statements for allUsers
(Chandan Kumar) Before i talk about MySQL Audit Filtering , it is more important to know below details:-