(Daniel Janik) If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice.
Community
DevOps Is About Communication
(Grant Fritchey) I spend a lot of time showing how to use tools to automate database deployments in support of DevOps.
The Demise of Big Data
(Lockwood Lyon) Big data as an application (or as a service) is being supplanted by artificial intelligence (AI) and machine learning.
Functional JavaScript: How to use array reduce for more than just numbers
(James Sinclair) The array reduce method is really powerful. But people often run into trouble as soon as they step beyond the basic examples. Simple things like addition and multiplication are fine.
Profiling .NET Core Memory Traffic using JetBrains dotMemory
(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.
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.