(Ben Nadel) When I was first learning about Abstractions in programming, one of the early patterns that I came across was the Data Access Layer (DAL), which attempted to hide the implementation details of the underlying data persistence mechanism.
Community
How to Save on AWS RDS MySQL Costs by Instance Right-sizing
(Tomer Shay) Right-sizing database instances is the process of adjusting your database instances’ size to match the workload generated by the application. In most cases, the incentive to right-size your database instances will be to lower the cloud infrastructure’s costs, ideally without compromisin
My first steps with Oracle Cloud API Gateway – the stock response
(Lucas Jellema) The API Gateway service on Oracle Cloud Infrastructure went live very recently – read my overview article of what API Gateway entails.
Connecting to Integration Services Access is Denied in SQL Server 2016 or 2017
(Sergey Gigoyan) After installing SQL Server 2017 or SQL Server 2016, a user tries to connect to SQL Server Integration Services (SSIS) for the first-time using SQL Server Management Studio (SSMS), most likely the connection attempt will fail. The received error message indicates: Failed to retriev
Using XUnit [Theory] and [InlineData] to Test C# Extension Methods
(Matthew Jones) In this final part of my unit testing series, we’re going to take a single extension method and show how we can use XUnit’s [Theory] and [InlineData] attributes to quickly write a bunch of tests for that method.
MySQL Shell Plugins: InnoDB
(Frederic Descamps)Today, we will cover a totally different MySQL Shell plugin: InnoDB.
dbnodeupdate.sh appears to be stuck
(Sidhu) I was patching an Exadata db node from 18.1.5.0.0.180506 to 19.3.2.0.0.191119.
SQL SERVER – Performance and Recompiling Query – Summary
(Pinal Dave) Today is the first day of the year 2020 and I would like to share an interesting conversation that I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.
Learn Routing In Angular 8
(Shobana Sundararajan) In this article, let’s explore what Routing is and the uses of the router in Angular applications. Routing is a kind of process in which we can divide the UI of a web application with the help of a URL.
Causality Tracking in Extended Events
(Grant Fritchey) If you go through all the stuff I’ve written about Extended Events, you’ll find that I use causality tracking quite a bit.