(Phil Wilkins) When it comes to development, we have had coding standards for almost as long as we have been coding. We tend to look at coding standards for purposes of helping to promote good quality code and reduce the likelihood of bugs and so on.
Author: SSWUG Research
The dangers of replication filters in MySQL
(Federico Razzoli) MySQL supports what it calls replication filters. They allow to decide which tables are replicated, and which are not. They can be set on a slave to filter-in tables and databases: the slave will not replicate everything from the master, but only the specified databases and tables
Don’t Do It All Yourself: Exploiting gRPC Well Known Types in .NET Core
(Peter Vogel) If you’re creating business services that send dates and decimal data then you may be concerned that gRPC services don’t support the relevant data types. Don’t Panic! There are solutions. Here’s how to use them.
Snapshotting ColdFusion Component State In Order To Find Memory Leaks In Lucee CFML 5.3.3.62
(Ben Nadel) A couple of years ago, I wrote about a “Snooper” component that I created that would allow you to peek into the private scope of your ColdFusion component state in order to try and find memory leaks. That approach worked.
Create and Deploy your Python Django App using Azure DevOps Project
(Abhijit Jana) You can create and deploy your Python Django App very fast using Azure DevOps Project. Azure DevOps Project makes it very easy to get started on Setting up code repo, build, and deployment with Azure.
Planning Your Db2 Performance Monitoring Strategy
(Craig S. Mullins) The first part of any Db2 performance management strategy should be to provide a comprehensive approach to the monitoring of the Db2 subsystems operating at your shop. This approach involves monitoring not only the threads accessing Db2 and the SQL they issue, but also the DB2 add
Azure Site Recovery jobs fail on servers hosting SQL Server instances with AUTO_CLOSE DBs
(blobeater) This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error.
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.
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.
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.