(Nagaraj M) The Observer Design Pattern is a Behavioral Pattern used to notify all the objects that are registered/attached/added to the same type of observer.
Other News
High Level Db2 Indexing Advice for Large and Small Tables
(Craig S. Mullins) In general, creating indexes to support your most frequent and important Db2 SQL queries is a good idea. But the size of the table will be a factor in decided whether to index at all and/or how many indexes to create.
Send an alert when the database state changes to SQL Server single-user mode
(Nisarg Upadhyay) This article explains the SQL Server single-user mode and how to configure an automated email alert when the state of the user database changes to the single-user mode. To send an alert, we will create a DDL trigger that executes when the user runs the ALTER DATABASE query.
Azure Synapse Analytics & Power BI concurrency
(James Serra) As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products.
Functional Java by Example | Part 8 – More Pure Functions
(Ted Vinke) This is part 8, the last instalment of the series called “Functional Java by Example”.
DevOps Engineers vs DBAs
(James Cockayne) DevOps engineer – job adverts for these positions abound, demanding years of experience in ten or fifteen skills and languages.
Getting Started with the AWS SDK in .NET Core
(Steve Gordon) In this post, we’ll learn about the AWS SDK for .NET and how to get started, using it to building .NET Core applications. There are many topics introduced in this post which lay some foundational knowledge that you will find useful as you get started developing .NET applications for A
Depth-First vs Breadth-First Tree Traversal Using A While-Loop In Lucee CFML 5.3.3.62
(Ben Nadel) As part of my post yesterday on how I sometimes replace recursive algorithms with loop-based algorithms in Lucee CFML, I mentioned that the algorithm incidentally shifted from a depth-first strategy to a breadth-first strategy.
What’s New for Java Developers in Visual Studio Code
(David Ramel) Microsoft touted the introduction of long-awaited “Call Hierarchy” support and some UI updates in the year’s first update to Java functionality in the cross-platform, open-source Visual Studio Code editor.
UUIDs are Popular, but Bad for Performance — Let’s Discuss
(Yves Trudeau) If you do a quick web search about UUIDs and MySQL, you’ll get a fair number of results. Here are just a few examples: