(Hemant Dangi) Further to our earlier blog post about Fail-safe enhancements to Group Replication, where we discussed enhancements against data modification in members which are not ONLINE, we now present here additional changes to protect data from being accidentally modified by asynchronous replic
Community
Patching GoldenGate with DBFS
(mdinh) There seems to be no consistency as to what directories should be on DBFS for when GoldenGate is implemented with RAC.
jQuery DataTable Integration with Server Side Processing Using Dynamic LINQ
(Proneetkumar Pradeep Ray) While integrating jQuery Datatable, first of all we have to ready with JSON results sets then after require initializing jQuery DataTable with that result. It works smoothly if number of records count or result content length/size is very less.
ASP.NET Core Exploring Custom Middleware
(Adam Storr) I’ve read a number of articles and watched the MVA on custom middleware so I thought it would be time to explore a bit more.
When Should I Use Amazon Aurora and When Should I use RDS MySQL?
(Ananias Tsalouchidis) Now that Database-as-a-service (DBaaS) is in high demand, there is one question regarding AWS services that cannot always be answered easily : When should I use Aurora and when RDS MySQL?
Session using a database link hangs on ‘SQL*Net more data from dblink’
(Zahid Anwar) I have a client who recently move a database server from on-premise to a Cloud provider. A database on this database server had a database link to their E-business database in the Oracle Cloud.
Using the Data Migration Assistant (DMA) tool to migrate from SQL Server to Azure SQL database
(Mohammed Moinudheen) We have an on-premises SQL Server database and we have used the Data Migration Assistant (DMA) to check for any compatibility issues before migration to Azure SQL database. Is it possible to use this tool to perform the actual migration of the database to the new target?
Fetching Data From XML File To SQL Database
(Altaf Ansari) In this article, I will share some tricks for the creation of a SQL table by using an XML file and importing data from an XML file to an SQL table.
SQL Server on Linux – Best practices post installation
(Manoj) Here are some of the best practices post installing SQL Server on Linux that can help you maximize database performance:
Measuring Query Execution Time: What Is Most Accurate
(Grant Fritchey) Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you go about measuring query execution time.