(David Ramel) Miguel de Icaza doesn’t post to his personal blog often, but when he does, developers listen.
Community
Guru: Using Identity Columns For Complex Keys
(Paul Tuohy) In September 2019, Ted Holt published an article that demonstrated how an identity column can be used to generate a unique key in a table. In this article, I want to expand on that theme and examine another use of an identity column — replacing complex keys.
ySQL performance benchmark ( with/without binary log )
(Sri Sakthivel Durai Pandian) Recently I had the discussion with one of my colleague about the impact of MySQL binary logs. It was a nice discussion and triggered me further to benchmark the MySQL with/without binary logs.
SQL SERVER – Row Goal and Performance
(Pinal Dave) During the recent consulting engagement Comprehensive Database Performance Health Check with SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.
Getting Started With HTTP Client Get Request In Angular 8 Using Entity Framework
(Rupesh Kahane) In this article, I am going to consume RESfFul API in Angular 8 using the HttpClient module Get request using the entity framework. The HttpClient module is used to GET, POST, PUT, PATCH, and DELETE requests. An Angular application can communicate with backend services over HTTP.
Nesting with Java interfaces
(Jeff Friesen) If you’ve read my Java 101 tutorial introducing static classes and inner classes, you should be familiar with the basics of working with nested classes in Java code.
MySQL 8 Minor Version Upgrades Are ONE-WAY Only
(Marco Tusa) In the many years we have used MySQL, we got accustomed to the fact that upgrades from MySQL 5.7.11 to 5.7.12 was a minor event. This meant that if something was going wrong, we could roll back the binaries and be happy again.
Inserting middleware between UseRouting() and UseEndpoints() as a library author – Part 1
(Andrew Lock) This post is in response to a question from a reader about how library authors can ensure consumers of their library insert the library’s middleware at the right point in the app’s middleware pipeline.
Recover a database using RMAN but failing to open redo
(David_89) When using RMAN to restore and recover the database, it seems to work OK – no obvious errors during the restore / recovery, as far as I can see.
SQL Server Best Practices for Data Quality
(Jeremy Kadlec) Accurate data is imperative for an organization to conduct cost effective decision making, marketing promotions, mailings, database bloat impacting performance, storage and more. Like everything else, change is constant for your data. There is a need to cleanse and validate data wh