(Vinay Magrania) Beginning with 11.2.0.2, for any form of database control file backup operations, Oracle no longer acquires the controlfile enqueue lock.
Community
Partitioning — 3b : More Indexes on Partitioned Table
(Hemant K Chitale) In the previous blog post, I had demonstrated a Global (Non-Partitioned) Index and a Local (Partitioned) Index. A Global Index itself may be partitioned. A Local Index is actually Equi-Partitioned with the Tablee.
Security Benefits for SQL Server Temporal Tables – Part 2
(Ameena Lalani) You may have heard about SQL Server Temporal Tables by now, but do you know all the benefits of using them? In this tip we look at some of the benefits and uses of SQL Server Temporal Tables.
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLDB’ is Full Due to ‘DATABASE_MIRRORING’
(Pinal Dave) It is interesting to see in SQL Server that same error message is raised due to multiple reasons. One such error is 9002. In this blog, we would quickly learn about the cause of error 9002: The transaction log for database ‘SQLDB’ is full due to ‘DATABASE_MIRRORING’
What’s new in VSTS Sprint 138 Update
(Alex Nichols) The Sprint 138 Update of Visual Studio Team Services (VSTS) has rolled out to all organizations. In this update, test results for releases have been enhanced to group together test attempts and summarize better.
MySQL 8.0 Data Dictionary
We are all familiar with “.frm” files since the earliest days of MySQL, The community has been continuously requesting for replacement of file-system based metadata for several good reasons, So with MySQL 8.0 “.frm” files are gone for ever,
How to securely access remote content without using a VPN: Use a proxy server accessed through an SSH tunnel
(Maarten Smeets) There are numerous occasions that I was limited in my work because of connectivity which could not be trusted. For example;
Angular Data CRUD with Advanced Practices of Reactive Forms
(Shenwei Liu) An Angular sample application that includes selecting, adding, updating, and deleting data with HttpClient service, reactive forms for object and array types, in-line data editing, custom input validations, and various other features (Available in both Angular 5 and 6).
Xamarin.Forms 3 – Cheat sheet
(Gerald Versluis) This tutorial gives a good overview of the most important new features of Xamarin Forms 3 in the form of a cheat sheet, and a reference on how to use them.
Impact of sharding on query performance in MySQL Cluster
(Mikael Ronström) A new week of blogs about our development in MySQL Cluster 7.6. After working a long time on a set of new developments, there is a lot of things to describe.