Types of Distributed Databases Homogeneous Distributed Databases The locations use identical DBMS and operating systems in case of homogeneous distributed databases. The characteristics are as follows: The websites use very similar software. The locations use identical DBMS or DBMS from the same supplier. Each site knows all other sites and works with other sites to process user requests. The database...
Other News
Audit Logons with Extended Events
(Jason Brimhall) Some time ago, I wrote an article for SQL Server 2008 to help determine the use of the server since SQL Server 2008 was reaching End Of Life.
SSIS Catalog Deployment to Support Dev, QA and Production
(John Miner) The development life cycle of an Extract, Translate and Load (ETL) process encompasses many phases. The Business Intelligence developer gathers the requirements from the business line and designs a package to transfer the data from point A to point B adhering to the time window that wa
Send Email with Java and Yahoo! Mail
(Han Bo Sun) In this tutorial, we will discuss the way of sending emails from a Yahoo! Mail account using Javax Mail library. After taking a look at how to enable third party app access to Yahoo! Mail, we will see a Java project that will demonstrate how to send email and finally learn how to test.
MySQL 8 InnoDB flow Architecture with related variables
(Sri Sakthivel Durai Pandian) Few months back, I have released the MySQL 8 architecture diagram .
What Are .NET Worker Services?
(Steve Gordon) With the release of .NET Core 3.0, the ASP.NET team introduced a new “Worker Service” project template, which is available as part of the SDK. In this post, I’ll introduce the new template, along with some practical examples of the kinds of services which I develop using it.
#762 Creating net new apps on top of Netsuite with OIC Visual Builder
(Niall Commiskey) I am probably speaking to the converted here, but for all those still not aware of the rich functionality OIC provides –
Kendo UI jQuery Validator
(Jin Vincent Necesario) Basically, based on my experience, client-side validation is one form of protection to protect data before being stored at the backend.
SQL SERVER – Query for CPU Pressure
(Pinal Dave) Today’s blog post is inspired by my earlier blog post SQL SERVER – Measure CPU Pressure – Detect CPU Pressure. I was recently asked during one of the consulting engagement Comprehensive Database Performance Health Check how do I actually measure the CPU for the entire server.
Introducing the LDAP Authentication Plugin in Percona Server for MySQL 8.0.19
(Zsolt Parragi) Percona Server for MySQL 8.0.19 includes the experimental simple LDAP authentication plugin, which allows for direct authentication using an LDAP server.