Category: Microsoft SQL Server

Feed: Recent Announcements. The read replicas feature is supported on SQL Server Enterprise Edition in the Multi-AZ configuration using Always On Availability Groups. This feature allows RDS SQL Server customers to offload their read workload from the primary DB instance to the replica, and also supports the scalability of read-heavy workloads over a farm of up to five read replicas. Read replicas can also render another level of availability by allowing you to promote a given read replica as a new standalone database, in the event of a failure of the primary DB instance.  Read replica is billed as a ... Read More

Feed: Planet MySQL; Author: Continuent; In this blog post, we talk about the basic function and features of the Tungsten Connector.The Tungsten Connector is an intelligent MySQL proxy that provides key high-availability and read-scaling features. This includes the ability to route MySQL queries by inspecting them in-flight. Connector Basics Understanding the Two Key Features The most important function of the Connector is failover handling. When the cluster detects a failed master because the MySQL server port is no longer reachable, the Connectors are signaled and traffic is re-routed to the newly-elected Master node. Next is the ability to route MySQL ... Read More

Feed: Recent Announcements. Apache Kafka enables you to perform real time analytics on your data to get insights faster than you would normally see with other data stores. With DMS adding support for Apache Kafka as a target, you don’t need a self-managed streaming data connector and your software development teams can focus more on innovation. For example, you can use DMS to aggregate ongoing change logs and metrics from applications that use multiple data stores such as Oracle, SQL Server, Aurora, MongoDB and many more to produce centralized operational data feeds and monitor everything in one place ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; My previous post related on how to install WordPress on Oracle Cloud seemed to be very popular. To continue the exploration of OCI, today we will install Drupal. This time, even if it’s possible to use the Free Trier like in the WordPress post, I will use a pay account to have the possibility to split the Web Server and the Database into two different subnets. Both instances will have their own subnet and only the Webserver will be reachable directly from the Internet. MySQL will be installed on a private subnet that could ... Read More

Feed: Planet MySQL; Author: FromDual; On StackExchange for Database Administrators I recently have seen a question which attracted my interest.The question puzzled me a bit because the answer seems too easy. Further the question was not so clear. An all theses factors smell dangerous... About time - was, is and will be How can I find out if the database "was" shutdown slowly? This is quite easy: Look into your MySQL Error Log and there you will find a log sequence similar to the following: 2020-03-30T08:03:36.928017Z 0 [System] [MY-010910] [Server] /home/mysql/product/mysql-8.0.19-linux-glibc2.12-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.19) MySQL Community Server - GPL.Ups! ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . There are several ways to move data between SQL Server and MariaDB. Here we will discuss them and we will highlight some caveats. Moving Data Definition from SQL Server to MariaDB To copy an SQL Server data structures to MariaDB, one has to: Generate a CSV file from SQL Server data. Modify the syntax so that it works in MariaDB. Run the file in MariaDB. Variables That Affect DDL Statements DDL statements are affected by some server system variables. sql_mode determines the behavior of some SQL statements and expressions, including how strict ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Join us for a Power Platform webinar on Tuesday 31 March, 2020 at 11:00 am – 12:00 noon PDT, presented by Microsoft Data Platform MVP Ana María Bisbé York In Ana Maria’s words: “In recent times I’ve worked primarily on projects, training and consulting around Microsoft Power BI. Sometimes Power BI is thought of as something just intended to create the visualization. Just focusing on the name, we can correct this inaccurate perception. Power indicates strength and BI stands by Business Intelligence. Power BI is capable of flowing through ... Read More

Feed: Planet PostgreSQL. 1. Overview In previous two blogs, we explained how to setup Kerberos, and how to configure PostgreSQL to support GSSAPI user authentication. This blog will be focusing on how to check GSSAPI authentication, encryption and user principal information when given different connection options. 2. pg_stat_gssapi view According to the official PostgreSQL document, “PostgreSQL supports GSSAPI for use as either an encrypted, authenticated layer, or for authentication only.“ To check the authentication, encryption and user principal, we need to use pg_stat_gssapi view, which is a dynamic statistics views containing one row per backend and showing the information about GSSAPI authentication and ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Microsoft provides a number of different deployment options for its Azure SQL Database offerings. We have reviewed a number of them on this forum, including the recently introduced Azure SQL Database Serverless. While most of them share the same characteristics, one in particular warrants special attention from the standpoint of its infrastructure dependencies. That exception is Azure SQL Database Managed Instance, which will be the topic of this article. The majority of the caveats regarding Azure SQL Database Managed Instance results from its unique architecture. Its primary tenets, which differentiate it for ... Read More

Feed: Planet MySQL; Author: Sri Sakthivel Durai Pandian; MySQL have the nice feature, which helps to write the error log with JSON format . This can be achieved through the MySQL components . In this blog, I am going to show the complete walkthrough involved in this process . What is MySQL component ? from MySQL document , MySQL Server includes a component-based infrastructure for extending server capabilities. A component provides services that are available to the server and other components. (With respect to service use, the server is a component, equal to other components.) Components interact with each other ... Read More