(David McGahey) CSV files are a quick and convenient way to record structured data in a generic format. Because CSV files are so easy to create, multiple similar versions of very large CSV files can quickly proliferate.
Other News
Azure Cosmos DB – Deep Dive
(Tim Sommer) Azure Cosmos DB is a powerful database service. This tutorial explores the concepts, features and advantages companies get when using Cosmos DB in distributed environments.
Case sensitivity in MySQL and MariaDB queries
(Federico Razzoli) Maybe you’re wondering why in MySQL/MariaDB ‘string’ seems to be the same as ‘STRING’. Or maybe that’s not the case for you, but you would like to make a case insensitive search.
Improving URLs for Oracle GoldenGate Microservices using a Reverse Proxy
(Bobby Curtis) Oracle GoldenGate finally has a GUI/Web Page interface to work with the product. This has been a long over due and welcomed feature that was initally released with Oracle GoldenGate Microservices in 12.3.
Did You Know #31 – OCR and Voting Disks in 18c and 19c
(Liron Amitzi) In Oracle GI 18c, the OCR and Voting disks must be located on ASM. A certified NFS or 3rd party shared file system is not supported for these files (you can keep your database on NFS or 3rd party shared FS, but not the OCR or the voting disks).
Tips and Tricks – Data Edition
(Jeff Smith) At Oracle Code One this past September, I was inspired to do up a special edition of my SQL Developer tips & tricks talk.
SQL SERVER – Identifying Query Generating Malicious Wait Type
(Pinal Dave) Just another day in my life when I got involved in the SQL Server Performance Comprehensive Database Performance Health Check, where I ended up with a server with a high amount of malicious Wait Type. In this blog post, we will learn about how to fix the performance issue with the malic
Login With Facebook and Google Using Angular 8
(Sanwar ranwa) In this article, we will learn the step-by-step process of allowing users to log in to an application with Facebook and Gmail using Angular 8. Login with Facebook and Google makes it safe and easy for users to use applications.
Row numbers with nondeterministic order
(Itzik Ben-Gan) The ROW_NUMBER window function has numerous practical applications, well beyond just the obvious ranking needs.
Want to be more comfortable with the Extended Events Viewer?
(Kenneth Fisher) I’ll admit, I’m a lot more comfortable with tracing and the profiler than I am with EE (extended events) and the viewer. It’s something I really want to get past but haven’t yet.