(Amit Prabhu) Container is a good way to create a package of applications along with all its dependencies so the application can be transferred between environments and also, it should run without any changes.
Community
Handling Pagination With JAX-RS and NoSQL in Your Jakarta EE/MicroProfile Application
(Otavio Santana) Want to learn more about handling pagination with JAX-RS? Look no further than Jakarta EE and MicroProfile.
SharpScript from ServiceStack lets you run .NET apps directly from a GitHub Gist!
(Scott Hanselman) I’ve blogged about ServiceStack before. It’s an extraordinary open source project – an ecosystem of its own even – that is designed to be an alternative to the WCF, ASP.NET MVC, and ASP.NET Web API frameworks.
Handling Large Data Volumes with MySQL and MariaDB
(Krzysztof Ksiazek) Most databases grow in size over time. The growth is not always fast enough to impact the performance of the database, but there are definitely cases where that happens.
SORT GROUP BY NOSORT ROLLUP
(Oren Nakdimon) In the previous post we saw that the Oracle Optimizer has a special operation – SORT GROUP BY ROLLUP – for performing several aggregations of the same population in a single scan, as long as the grouping keys are in a “rollup form”; for example:
SQL SERVER – DELETE Qualified Rows From Multiple Tables – Part 2
(Pinal Dave) Earlier this week, I had announced a contest to get Recorded PASS of my extremely popular training SQL Server Performance Tuning Practical Workshop – Recorded Classes. As the price of this class high, I wanted to keep my contest difficult as well.
T-SQL Regular expression: LIKE Operator and its use-cases.
(Nisarg Upadhyay) A regular expression is a rule which defines how characters can appear in an expression. It’s a sequence of character or text which determines the search pattern.
Monitoring SQL Server deadlocks using the system_health extended event
(Rajendra Gupta) Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases.
Guru: Read a Data Area As a One-Row Table with SQL, Take Two
(Ted Holt) Fifteen years ago, reader W.G. asked me about the possibility of treating a data area as a one-row table (a physical file with one record) in an SQL query.
16 Ways to Speed Test Automation Using a CI/CD Pipeline
(Stella Murugesan) Test automation plays a significant role in software development. It improves speed, better detects errors and bugs, is repeatable, scalable, has broader coverage, and more. Let’s take a look at test automation using a CI/CD pipeline.