(Pinal Dave) Recently while working with a large financial organization on Comprehensive Database Performance Health Check, I found an instance where stored procedure had a very incorrect execution plan cache. I told the DBA who was working with me to recompile the stored procedure so we have to bra
Community
Database Transaction Management across AJAX Calls
(Marc Clifton) Another rabbit hole, this time how to handle AJAX calls in a manner that lets you roll back the entire set of transactions if any particular AJAX call fails.
Relay Blazor client logs to Serilog in ASP.NET Core
(Nicholas Blumhardt) Microsoft’s new UI stack, Blazor, features in just about every summary of what’s new in .NET Core 3. I’m not planning to use “server-side” Blazor, although it’s undeniably impressive (frameworks based on stateful client/server sessions tend to blow their complexity budget dealin
Setting up an NDB Cluster in the Oracle Cloud using Auto Installer
(Mikael Ronstrom) In MySQL Cluster 8.0.18 we have developed MySQL Cluster Auto Installer to also support installing NDB 🙂
ServiceManager … as a daemon
(dbasolved) In an earlier post on ServiceManager, I took a look at how you could start/stop the ServiceManager manually.
Create SQL Server Database using SQL Server Management Studio
(Joe Gavin) You’re new to SQL Server and need to create a database. It sounds like a simple enough task, but how do we do it?
Stack Class in Java
(Vijay Kumari) Java Collection framework provides a Stack class that models and implements a Stack data structure. The class is based on the basic principle of last-in-first-out.
Visual Studio for Mac: Take Control of Your IDE with Keybindings
(Cody) The great debates in computing all have one common theme. Whether it is tabs vs. spaces or Vi vs. Emacs, the thread linking all these debates together is keyboard efficiency.
AtomicInteger on Java and Round-Robin
(Emmanouil Gkatziouras) AtomicInteger belongs to the Java family of atomic variables. The main benefit is that using it is not blocking instead of doing a blocking synchronization, thus you avoid the suspension and rescheduling of threads.
MySQL Workbench Review
(Peter Zaitsev) MySQL Workbench is a great multi-purpose GUI tool for MySQL, which I think is not marketed enough by the MySQL team and is not appreciated enough by the community for what it can do.