(Jeff Friesen) Nested classes are classes that are declared as members of other classes or scopes. Nesting classes is one way to better organize your code.
Author: SSWUG Research
Extended Events: Histogram Output
(Grant Fritchey) The single most important thing to remember about Extended Events is that this functionality is not simply a replacement for Profiler/Trace, but a whole new tool with new functionality.
How To Copy Text To Clipboard Using Angular 8
(Siddharth Gajbhiye) In this article, we will learn how to copy text to Clipboard and also copy the current date and time, using Angular 8.
SQL SERVER – OPTION(FAST N) Hint and Performance
(Pinal Dave) SQL Server 2019 is indeed very well made software by Microsoft. Recently, I have a very interesting situation while working with SQL Server 2019, which I had not faced before about OPTION(FAST N). While busy with Comprehensive Database Performance Health Check, I did not have access to
What to Look for if Your MySQL Replication is Lagging
(Paul Namuag) A master/slave replication cluster setup is a common use case in most organizations. Using MySQL Replication enables your data to be replicated across different environments and guarantees that the information gets copied.
Anonymous Aware Middleware with Endpoint Routing and Healthchecks
(Steve Gordon) In this post, I want to describe an approach to allow anonymous access to a health check endpoint, added using the MapHealthChecks extension on EndpointRouting.
Using SPM to Control A Single SQL Execution Plan
(Liron Amitzi) SQL Plan Management (SPM) is a powerful tool. It can do many things to control and evolve SQL execution plans to allow the most stable system.
React Bootstrap Table with Searching And Custom Pagination
(Sanwar ranwa) In this article, we will learn how to use the React Bootstrap Table in React applications. I will also explain how we can implement paging, searching, and sorting in this Table.
SQL Server Maintenance Plan Shrink Database Task
(Sergey Gigoyan) In some cases, a SQL Server database occupies much more space than actually is used by the data or would ever be used. In such situations, it would be optimal to reduce the size of the database and return the storage space to the operating system.
Introduction to MySQL 8.0 Common Table Expressions (Part 1)
(Corrado Pandiani) This blog is the first part of a two-articles series. In this article, I’m going to introduce the Common Table Expression (CTE), a new feature available on MySQL 8.0, as well as Percona Server for MySQL 8.