(Rahul) Keeping configurations and reading them at runtime is an essential part of any application.
Community
SQL SERVER – SSMS – SET ROWCOUNT – Real-World Story
(Pinal Dave) Today, I have a very interesting scenario while I was working with my client on the Comprehensive Database Performance Health Check. Let us today talk about SSMS Query Execution configuration for SQL Server where SET ROWCOUNT settings gave us an interesting challenge with query tuning.
Logging all MySQL queries into the Slow Log
(Federico Razzoli) MySQL optionally logs slow queries into the Slow Query Log – or just Slow Log, as friends call it. However, there are good reasons to log all the queries, not just some of them.
New for VS Code: MongoDB, Kite AI-Powered JavaScript Completions
(David Ramel) This week sees several significant additions to the Visual Studio Code ecosystem: an update to the Python extension; the popular open source MongoDB database; and AI-powered JavaScript code completions from Kite.
The Affect Of File-IO On Performance Experimentation In Docker And Lucee CFML
(Ben Nadel) Ever since I learned that Lucee CFML supports parallel array iteration, I’ve been itching to find a good place to really leverage it. And, recently, it occurred to me that I might be able to use it to boost PDF generation at InVision.
Using Dapper in ASP.NET Core applications
(Gunnar Peipman) Times ago I blogged about micro ORM-s. I have been busy through all Covid-19 times learning technical side of DDD and during that I met again my old friend Dapper.
Implementing Glue ETL job with Job Bookmarks
(Anand) AWS Glue is a fully managed ETL service to load large amounts of datasets from various sources for analytics and data processing with Apache Spark ETL jobs.
Migration methods to Autonomous Database (ADB) – Part I (Data Pump)
(Syed Jaffar Hussain) In this part of on-premise Oracle database migration to ADB series, we will focus on set of tools to migrate your on-prime database to Autonomies database (ADB).
Adding columns to external tables…idiocy?
(Connor McDonald) Let me start with the idiotic part first. That part would be…. me! Smile
Managing Transactions with Spring and Spring Data JPA
(Thorben Janssen) Spring Boot and Spring Data JPA make the handling of transactions extremely simple. They enable you to declare your preferred transaction handling and provide seamless integration with Hibernate and JPA.