(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
Other News
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.
What Should I Do if My Manager is Taking Advantage of Me?
What should I do if my manager is taking advantage of me? I’ve been working at a small firm for a few months. The owner quickly found out that my skills surpass the job, so she’s overworking me with no change in pay or title, while she works less. One thing that is working to your disadvantage is that you...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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.