(Greg Larsen) When you turn on Transparent Data Encryption (TDE), the SQL Server database engine asynchronously starts encrypting data pages.
Author: SSWUG Research
Causality Tracking in Extended Events
(Grant Fritchey) If you go through all the stuff I’ve written about Extended Events, you’ll find that I use causality tracking quite a bit.
SQL 101: Flipping It—Using RPG Code in SQL
(Rafael Victoria-Pereira ) The first question crossing your mind is probably “Why do this?” I’m sure that, after reading the last few TechTips of this series, you’ve realized how useful SQL in your RPG code can be, but it’s probably not so obvious why the opposite can be equally beneficial.
CRUD Operation Using Angular And Web API
(Mohammad Irshad) In this article, we will try to implement the basic operations ( Create, Read, Update, Delete ) using Angular and WebApi.
SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)
(Pinal Dave) Today is the last blog post of the year 2019 and this is also a final blog post in the series of Parameter Sniffing which I have been writing. I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.
Running the (Segment) Space Advisor – on a Partitioned Table
(Hemant K Chitale) Here is a quick demo on running the Segment Space Advisor manually
Updating the trail file location for Oracle GoldenGate Microservices
(Bobby Curtis) When you first install Oracle GoldenGate Microservices, you may have taken the standard installation approach and all the configuration, logging and trail file information will reside in a standard directory structure.
db_securefile PREFERRED results in ORA-60019 with small uniform extents
(Bobby Durrett) Last 19c upgrade issue. Working on our new 19c database, several things died off with errors like this:
MySQL Shell Plugins: check (part 3)
(Frederic Descamps) What is great with MySQL Shell Plugins, it’s that it provides you an infinite amount of possibilities. While I was writing the part I and part II of the check plugin, I realized I could extend it event more.
An Introduction to Ordered Associative Containers in C++
(Manoj Debnath) Associative containers are those that provide direct access to its elements for storage and retrieval purposes.