(Pinal Dave) Sometimes I feel like I have become a kid again when I do a blog post such as today but it is indeed the best part of running a blog tirelessly for over 13 years. This morning I received a coffee mug with printed quotes of Indexes and SELECT Queries.
Other News
Gathering CPU Load, Garbage Collection Time, Thread Dumps And Other JVM Metrics In ColdFusion
(Ben Nadel) A few months ago, I looked at generating a Java thread dump programmatically using ColdFusion. I was doing that as part of an ongoing effort to find processing bottlenecks in the main ColdFusion application that we have at InVision.
Primary Key in InnoDB: how they work and best practices
(Federico Razzoli) InnoDB is MySQL default storage engine – the one you use if you don’t know what a storage engine is, or you don’t have special needs.
Indexing Null Values – Part 2
(Randolf Geist) In the previous post I’ve demonstrated that Oracle has some problems to make efficient use of B*Tree indexes if an IS NULL condition is followed by IN / OR predicates also covered by the same index – the predicates following are not used to navigate the index structure efficiently bu
SQL Server Substring Function Example with T-SQL, R and Python
(Siddharth Mehta) String manipulation is one of the most fundamental data manipulation items used in almost every data processing exercise. Generally, string manipulation objectives are formatting, trimming, padding, replacing, casting and similar functions.
Iterator Pattern In Java
(Eranda Horanagama) In this article, you will learn about Iterator Pattern in Java.
Tracking Azure Costs with Cost Management
(Timothy Smith) The Azure Portal offers the free tool Cost Management that we can use for managing Azure costs. As we’ll see, we can use this tool to organize how we manage our spending along with setting limits for thresholds to alert the appropriate members.
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
(John L. Viescas and Michael J. Hernandez) In this book excerpt, you’ll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs.
An Interesting Case Of .NET Performance and Caching
(Khalid Abuhakmeh and Bill Boga) Several months ago, Bill Boga and I, realized there was a performance enhancement we could make in our infrastructure. We were utilizing IdentityServer and took notice that many of our APIs were validating many of the same access tokens and storing the results in mem
Scale a Kubernetes Deployment with .NET Core
(Carlos Mendible) Let’s start: