Category: Microsoft SQL Server

Feed: Planet MySQL; Author: MySQL Performance Blog; ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused on the following two topics: When the replication lag threshold is reached, ProxySQL will move the server to SHUNNED state, instead of moving them to OFFLINE hostgroup. When shunning a server, it will be performed gracefully and not immediately drop all backend connections. The servers can be taken to ... Read More

Feed: Planet PostgreSQL. We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 14 Windows 64-bit. To use these, copy the files into your PostgreSQL 14 Windows 64-bit install folders in same named folders and then run CREATE EXTENSION as usual in the databases of your choice. More details in the packaged README.txt This package contains the following FDWs: odbc_fdw (version 0.5.2.3) for connecting to ODBC data sources such as SQL Server, Oracle, MS Access databases, and anything else that has a 64-bit ODBC driver. Note that since this is for PostgreSQL 64-bit, it can only ... Read More

Feed: Planet PostgreSQL. Date: 11.10.2021 Tags:   postgresql    edb    ansible    postgresql_pg_hba    wal-g    oauth2    museum    Category:   Interviews    Interview conducted by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I was born in a city that is nowadays called Lelystad in the Netherlands. Lelystad was founded in 1967, and is built on reclaimed land, so a ... Read More

Feed: Planet PostgreSQL. OpenBSD is a rock solid, super secure, real Unix operating system. PostgreSQL is a rock solid, enterprise level, fully feautured relational database. Is it possible to merge the two for a great database on such operating system? Yes, of course! OpenBSD has a packaging system that is somehow different from many other operating systems; in particular the packages are deeply inspected before they are installed, so that the installation process proceed only if it really sure the installation can succeed. Moreover, the operating system provides a simple and flexible way to manage services like PostgreSQL. In this ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We are excited to announce that XMLA endpoints on Premium Per User (PPU) now support Azure Active Directory (AAD) authentication with service principals. This authentication option enables administrative applications to perform automated maintenance tasks and unattended service-level operations by using their own app identities, which is often a requirement for migration of existing tabular data models from Azure Analysis Services and SQL Server Analysis Services to Power BI Premium. For technical details, see the article Automate Premium workspace and dataset tasks with service principals in the product documentation. Service ... Read More

Feed: Planet PostgreSQL. By Ryan Lambert -- Published October 08, 2021Our data dictionary extension, PgDD, has been re-written using the pgx framework in Rust! At this time I have tagged 0.4.0.rc3 and just need to do a bit more testing before the official 0.4.0 release. While I am excited for the news for PgDD, what is more exciting is the pgx framework and the ease it brings to developing Postgres extensions! Getting started with pgx is straightforward and using cargo pgx run makes it simple to build your extension against multiple versions of Postgres. This post outlines how I came ... Read More

Feed: Planet PostgreSQL. Today saw the launch of PostgreSQL14. For me, the important area to focus on is what the community has done to improve performance for heavy transactional workloads and additional support for distributed data. The amount of data that enterprises have to process continues to grow exponentially. Being able to scale up and out to support these workloads on PostgreSQL 14 through better handling of concurrent connections and additional features for query parallelism makes a lot of sense for performance, while the expansion of logical replication will also help. Performance Enhancements Server Side Enhancements Reducing B-tree index bloat ... Read More

Feed: James Serra's Blog. Author: James Serra. After a very long public preview (9 months), Azure Purview is finally generally available (GA). I described Purview in a previous blog (New Microsoft data governance product: Azure Purview). In short, Purview’s main purpose is to collect metadata from various sources and provide a search feature over that metadata so you can quickly find relevant data. It can automatically classify the data (i.e. SSN) and provide data lineage, as well allowing you to enter glossary terms. It then provides insights into the data: (Note: The below info, including slides, were talked about during ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how the new dual passwords feature can reduce the overall DBA workload and streamline the management process (see MySQL 8: Dual Passwords). This wasn’t the only change to user/password management in MySQL 8; one of the more security-focused changes was the implementation of temporary account locking, first introduced in MySQL 8.0.19. With this feature, database administrators can now configure user accounts so that too many consecutive login failures can temporarily lock the account. The account locking feature only ... Read More

Feed: Microsoft Azure Blog. Author: Eric Lockard. The pandemic has prompted many organizations to greatly accelerate digital transformation and cloud adoption initiatives to mitigate disruption, gain efficiencies, and take advantage of scalable infrastructure. At Microsoft, we provide our customers with flexibility and choice to adopt the cloud in a way that’s right for their business. Because every customer starts their cloud journey at a different place, we help enable customers to migrate to the cloud on their terms and maintain support for the business platforms and investments they have today. Azure VMware Solution is one of the key ways we ... Read More