(Dobromir Nikolov) Creating and distributing Visual Studio templates is hard. You need to get familiar with custom XML formats, the VSIX project type, and Visual Studio’s occasionally eccentric behavior. Now you don’t waste time with that. Learn how you can instantly extract a ready-to-go template o
Community
MessageQueue in .NET, Part 1: The Background Work on Windows
(Hannes DuPreez) Hello and welcome to my article. Today, I’d like to speak about MessageQueue in .NET. But, to do that, I need to explain how MSMQ works in the background. So, this will be Part 1, and in Part 2 we will do it practically in .NET
MySQL Shell Plugins: check (part 2)
(Frederic Descamps) In the first part of this article related to the check plugin, we discovered information retrieved from the binary logs.
Oracle REST Data Services running on Tomcat – Basic Authentication using JNDI Realm
(Jakub Granieczny) We want to protect our REST endpoints using Basic Authentication and authenticate the requests against our users directory (LDAP).
Installing Oracle GoldenGate Microservices – Part 2 of 2
(Bobby Curtis) In the my last post, I showed you how to install the binaries for Oracle GoldenGate Microservices. Then at the end of the post, I mentioned that you will need to run Oracle GoldenGate Configuration Assistant to finish the configuration of Oracle GoldenGate Microservices.
Using Oracle EXPAND_SQL_TEXT
(David Fitzjarrell) Database tables are not static entities; besides the usual insert/update/delete events, occasional DDL can be executed to add columns, drop columns or add needed constraints or indexes.
SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING
(Pinal Dave) Just a few hours ago, I finished my very last consulting engagement of the year Comprehensive Database Performance Health Check. My client had hired me after reading my recent series on Parameter Sniffing.
Observer Design Pattern Explained With Java Sample
(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.
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.