(John Sterrett) The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below.
Author: SSWUG Research
DROP IF EXISTS
(Kenneth Fisher) It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to completely miss over time. I was having a random conversation with a friend on Twitter the other day and they mentioned an acronym DIE.
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.
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.
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.
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
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.
How To Add TreeView Component In React Application
(Sanwar Ranwa) In this article, we will learn how to add TreeView component in React applications. A tree view is used to display a hierarchical list of data. In this demo we use React material UI Treeview component.
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
(Pinal Dave) One of the reasons, I love my job of SQL Server Performance Tuning Expert is that I get to learn every single day something new while working with my client on Comprehensive Database Performance Health Check. Recently I got a very unique situation where I had to Remove All Query Cached
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:-