(Steve Smith) I don’t know how I didn’t know about this before now, but apparently you can turn on autocorrect for your git command line, and it will accept (after a short delay in which you can cancel) commands that are close to but not exactly correct.
Community
SQL SERVER – Temp Table vs Table Variable – Cardinality Estimation
(Pinal Dave) It has been a while since I have been working with SQL Server 2019 with my clients to help them with performance-related issues while working on Comprehensive Database Performance Health Check. Recently, I had a very interesting conversation with one of my clients about Cardinality Esti
MySQL InnoDB Cluster Tutorial 1 ( Group Replication + MySQL Shell )
(hercules7sakthi) MySQL InnoDB Cluster has introduced by the MySQL team for the High Availability ( HA ) purpose . It provides a complete high availability solution for MySQL.
ASP.NET MVC jQuery Server Side Datatable Example
(Abhishek Mishra) Today I will demonstrate the implementation of jQuery server side Datatable in MVC appplication with server side filter, sorting and Pagination.
Patching Null++
(Ashley Frieze) Here’s a curiosity.
What’s new with Oracle database 19.6 versus 19.5
(Frits Hoogland) As expected, there aren’t any really drastic differences between Oracle database version 19.5 and 19.6. Now that I am doing these series on differences for all the versions every quarter the new release updates are coming out, there is a certain line, and this release does follow th
StructCopy() Does Not Necessarily Return A Native Struct In Lucee CFML 5.3.3.62
(Ben Nadel) Over the weekend, while working on a version of dump() that gracefully handles cyclic references in Lucee CFML, I happened upon a quirk of the language when dealing with reflection-style coding.
Using Referential Constraints with Partitioned Tables in InnoDB
(Carlos Tutte) One of our support customers approached us with the following problem the other day:
SQL Server Dynamic PIVOT Query
(Eli Leiba) The PIVOT operator (or “cross-tab” operation) is a very handy tool in SQL Server, but its main limitation is that you often don’t know the values that you need to pivot on.
SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 1
(Nisarg Upadhyay) In this article, I will explain the process of installing pre-requisites to deploy the SQL Server AlwaysOn availability group.