(Steve Gordon) In this post, I will continue my journey into writing high-performance C# and .NET Core code by taking a look at a benchmarking challenge I recently encountered.
Other News
Dependency Injection Using the MEF Framework
(Tapas Pal) The Managed Extensibility Framework (MEF) has solved the common problems encountered when developing enterprise applications.
How to Use Regular Expressions in Visual Studio Find
(Peter Vogel) I have to admit that I’ve never really understood regular expressions. But if there was any reason that I was going to learn to use them, it would be when doing searches in Visual Studio.
How to Perform Compatible Schema Changes in Percona XtraDB Cluster (Advanced Alternative)?
(Przemys³aw Malkowski) If you are using Galera replication, you know that schema changes may be a serious problem. With its current implementation, there is no way even a simple ALTER will be unobtrusive for live production traffic.
Bitmap Index On Column With 212552698 Distinct Values, What Gives? (I’d Rather Be High)
(Richard Foote) In my previous post on Indexing The Autonomous Warehouse, I highlighted how it might be necessary to create indexes to improve the performance and scalability of highly selective queries, as it might on any Data Warehouse running on an Exadata platform
Creation of Recovery Catalog and Registering Database
(Jagruti Jasleniya) Recovery Catalog: RMAN metadata is stored in a different database instead of the control file. That database works as a repository.
Data Modeler Domains: Build & Use
(Jeff Smith) I’ve previously talked about Domains…this is the concept where say you want to have a JSON column in your Oracle TABLE, but you always want it defined the same way, e.g. as a CLOB.
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
(Pinal Dave) Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me.
Top 12 React.js Libraries You Should Know In 2019
(Sandeep Aspari) React is one of the most popular JavaScript libraries. Here are top 12 React.js libraries.
Database Development Life Cycle, Normalization, Errors and Security of Database – Part 4
f execution database processor then executes the database access routines. The results are returned to the application that first made the request. All runtime errors are also returned. Query Optimization Allow the system to obtain (or improve) acceptable performance by choosing a better (if not the best) strategy during the query process. One of the great strengths to the relational...
