(Frits Hoogland) This blogpost is about the Oracle database row or dictionary cache. This is a separate cache that caches database metadata, like database object properties or user properties.
Author: SSWUG Research
Working with SQL Cursors
(Manoj Debnath) In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time.
Query Store, Plan Forcing, and DROP/CREATE
(Grant Fritchey) I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality.
Use Angular Application As Desktop Application Using Electron
(Nagaraj M) In this article we will learn about how to use Angular as a desktop application using the Electron plug-in, and also we will see how to create a set up for Windows.
SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog ‘GUID’ is Encrypted by It
(Pinal Dave) Sometimes I get amazed by the speed at which the search engine crawls and gets the right results. A few days ago, I wrote a blog about a UI error in Always On availability group.
Better Prometheus rate() Function with VictoriaMetrics
(Peter Zaitsev) There are a lot of things I love about Prometheus; its data model is fantastic for monitoring applications and PromQL language is often more expressive than SQL for data retrieval needs you have in the observability space.
Visual Studio Code Gets New Python Debugger
(David Ramel) The March 2020 update to Microsoft’s wildly popular Python extension for Visual Studio Code focused on improving quality via bug fixes, but it did introduce a new debugger.
Grouping Shared Variables in Azure DevOps Pipeline
(Abhijit Jana) Grouping Shared Variables in Azure DevOps Pipeline helps to organize and managing common variables across different Build and Release Pipelines.
Variables? We Don’t Need No Stinking Variables – C# Discards
(Jason Roberts) C# 7.0 introduced the concept of discards. Discards are intentionally unused, temporarily dummy variables that we don’t care about and don’t want to use.
Guru Classic: Tuning SQL Environments On i
(Paul Tuohy) One of the frustrating things about being a speaker at conferences is that when you want to attend another session with a topic that piques your interest, it invariably clashes with when you are speaking.