Category: Microsoft SQL Server

Feed: Puppet.com Blog RSS Feed. Author: ; The Windows Platform team here at Puppet has been working hard on updating our key Windows modules. Customers who use our Puppet Supported SQL Server module will be happy to know that we added support for SQL Server 2016. We also added support for internationalization and the new Puppet 5 platform. You can see all of the updates here.We also made updates to our supported IIS and ACL modules. Both now support Puppet 5. Additionally:IIS 4.1 includes bug fixes based on customer feedback. See the changelog for more details.ACL 2.0.1 allows you to ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I'd like to continue reviewing MySQL bug reports from Community users that I considered interesting and subscribed to. Unlike in the previous post in this series, I am not going to check test cases on any competitor product, but will use only recently released MySQL 5.7.29 and 8.0.19 for checks, if any. This time I'll concentrate on bugs reported in November 2019.As usual, I mostly care about optimizer, InnoDB and replication related bugs. Here is the list:Bug #97476 - "Range optimizer skips rows". This bug reported by Ilya Raudsepp looks like a clear regression in ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; As on every release MySQL Shell 8.0.19 includes several bug fixes as well as new features. However, this release includes some significant changes: Fixes for bugs in the schema definition:  Cascading keys in multi-primary mode. Introduction of InnoDB ReplicaSet. These changes required updates to the metadata schema definition, some of which incompatible with previous versions. InnoDB Cluster and ReplicaSet deployments that are created using MySQL Shell 8.0.19 will automatically use the new version of the metadata schema. However, to use InnoDB Cluster deployments created in older Shell versions (8.0.18 or earlier) with ... Read More

Feed: James Serra's Blog. Author: James Serra. As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage, as it can get a bit confusing with all the options that are available. Azure Data Lake Store (ADLS) Gen2 should be used instead of Azure Blob Storage unless there is a needed feature that is not yet GA’d in ADLS Gen2. The major features that are missing from ADLS Gen2 are premium tier, soft delete, page blobs, append blobs, and snapshots. The major features ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; If you are reading this blog post, you likely already know the purpose of user-defined functions (UDF) in MySQL. If you need a quick refresher on UDF’s take a look at the MySQL reference manual.  You may have created your own UDFs as well. Have you ever run into character set related issues with your UDF?  If yes, then this blog post will interest you. If you are planning to write new UDFs then it will be good to know this information. The initial design of MySQL UDF framework did not consider ... Read More

Feed: Planet MySQL; Author: HowToForge; A FEMP stack, which is akin to a LEMP stack on Linux, is a collection of open-source software that is typically installed together to enable a FreeBSD server to host dynamic websites and web applications. FEMP is an acronym that stands for FreeBSD (operating system), Nginx (HTTP server pronounced Engine-x), MySQL (database server), and PHP (programming language to process dynamic PHP content). In this tutorial, we'll set up components of a FEMP stack on a FreeBSD 12.1 server using pkg, the FreeBSD package manager. Requirements Before you start this guide, you'll need the following: A FreeBSD ... Read More

Feed: Microsoft Azure Blog. Author: John Molesky. We’ve released our newest Azure blueprint that maps to another key industry-standard, the Center for Internet Security (CIS) Microsoft Azure Foundations Benchmark. This follows the recent announcement of our Azure blueprint for FedRAMP moderate and adds to the growing list of Azure blueprints for regulatory compliance, which now includes ISO 27001, NIST SP 800-53, PCI-DSS, UK OFFICIAL, UK NHS, and IRS 1075. Azure Blueprints is a free service that enables cloud architects and central information technology groups to define a set of Azure resources that implements and adheres to an organization's standards, patterns, ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; In a follow-up to the work presented on MySQL 8.0.18  where we introduced privilege checks for slave applier threads, in this post we present a new feature to further increase your ability to securely replicate your data: you can now restrict replication streams to row based events only. In MySQL 8.0.19, a new CHANGE MASTER parameter REQUIRE_ROW_FORMAT is added for replication channels, which makes the channel accept only row-based replication events.This requirement will increase overall security by: Not allowing the replication of LOAD DATA instructions, as they mean a file will be temporally ... Read More

Feed: Planet MySQL; Author: Sri Sakthivel Durai Pandian; At 13th January 2020, MySQL Community has released the very latest MySQL 8.x version ( 8.0.19 ). The MySQL 8.0.19 has released with the good amount of bug fixes and the cool features . InnoDB ReplicaSet is one of them and most interesting feature for me . In this blog I am going to explain about the configuration of the MySQL InnoDB ReplicaSet and how to do the switchover smoothly with InnoDB ReplicaSet . What is InnoDB ReplicaSet ? from MySQL document, The AdminAPI includes support for InnoDB ReplicaSet, that enables you ... Read More

Feed: Planet MySQL; Author: Bernd Ocklin; MySQL’s NDB Cluster Development team proudly announces NDB Cluster 8.0 General Availability. NDB 8.0.19 GA is a completely new generation of the world’s highest throughput transactional datastore MySQL NDB Cluster. Some of the key highlights of 8.0 are NDB is now fully aligned with MySQL Server 8.0 and includes the latest server maintenance release Dynamic Memory Management for transaction memory resources removes configuration complexity and allocates transaction resources automatically Up to 4 replicas are fully supported now and allows cluster to maintain 1 to 4 copies of data Cluster capacity has dramatically been increased by ... Read More