Category: Microsoft SQL Server

Feed: Planet MySQL; Author: MySQL Performance Blog; We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them. Most of the cases when the error occurs are described in MySQL documentation, but it can get tricky. And here, I’d like to talk about “tricky”.There are only a few major cases when this happens:1. MySQL Thread Was Killed by an Administrator or a Utility Such as pt-killThe manual intervention is likely ... Read More

Feed: Planet MySQL; Author: The Pythian Group; If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there’s now an easy solution at your fingertips. With the New Relic MySQL integration you can monitor and graph almost any detailed metric you could possibly want. New Relic recently unified its analytics tools with New Relic One, a dashboard that provides quick access to all the New Relic tools. With an Infrastructure Pro subscription, you get access to: New Relic Infrastructure: Flexible, dynamic monitoring of your entire infrastructure, from services running in the cloud or on dedicated hosts, to ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; MySQL will be used for our online sections because the VMware instance and Docker configurations where too large to effectively download this term. MySQL 8.0.21 Installation Steps After you download the MySQL 8 MSI file, you will perform the following 24 steps to install MySQL on Windows 10. If you want a full developer install you must install Microsoft Excel and Visual Studio first. The first thing you need to do is grant privileges to allow the MySQL Installer application to work in Windows 10. Click the Yes button to authorize the MySQL Installer ... Read More

Feed: Planet MySQL; Author: ProxySQL; This post is the first of a series of blogposts on how to easily use ProxySQL to scale-out your application’s database workload on a Galera cluster. This series will explore the main concepts in configuring ProxySQL for Galera across three articles as follows: – A first introductory post describing the minimal configuration needed for ProxySQL to monitor and manage a Galera Cluster.– A second post describing how to setup a read/write split configuration for our Galera Cluster, using ProxySQL query rules.– A third and final post with examples on specific cluster configuration options and more ... Read More

Feed: CIO. Author: . SAP users should deploy the patches for Adaptive Server Enterprise (ASE) released last month because the server fails to clear credentials from persistent installation logs. Even though the credentials are encrypted or hashed, researchers warn that attackers can easily decrypt them to gain full access to a sensitive monitoring component.Previously known as Sybase SQL Server, the SAP Adaptive Server Enterprise (ASE) is a high-performance relational database with on-premises and cloud deployment options. The product is used by over 30,000 organizations worldwide, including over 90% of the world's top 50 banks.SAP ASE is a complex piece of ... Read More

Feed: James Serra's Blog. Author: James Serra. There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and clicking the “+” at the top to the right of Data brings up: Under “Workspace”, choosing “Synapse SQL Database” gives you the ability to create a database in a SQL on-demand pool. A SQL on-demand pool (which you access via an endpoint) can have multiple databases. Note that SQL on-demand has no local storage so only metadata objects are stored in the databases. After ... Read More

Feed: Microsoft Azure Blog. Author: Rohan Kumar. We live in demanding times, and change is happening faster than ever before. Data has always provided important insights into changing contexts, but to navigate the rapidly evolving landscape, adding layers of intelligence where AI advances decision making and applies predictive analytics at the edge to unlock new possibilities is pivotal. At Microsoft Ignite, we shared a number of announcements to help organizations rebuild in a changing world. Following the announcement of Azure Arc in November 2019, we are announcing the preview launch of Azure Arc enabled data services. With this preview, customers ... Read More

Feed: Microsoft Azure Blog. Author: Amanda Silver. Over the last six months, organizations of all shapes and sizes have had to suddenly pivot to serve customers, employees, and partners exclusively via digital channels. In this uncertain business environment, we have seen resilient organizations adapt in three dimensions: by supporting remote application development; improving business agility with a focus on Developer Velocity; and by driving cost savings. At Microsoft Ignite, we've shared new capabilities that enable developers and the teams they support to become more resilient with Microsoft Visual Studio, GitHub, Microsoft Azure, and Microsoft Power Apps. Creating resilient development teams ... Read More

Feed: Microsoft Azure Blog. Author: Erin Chapple. Organizations including ASOS, Keiser University, and Manulife trust and build services on Azure to run their business-critical workloads and support their customers across the world. It’s customers such as these that fuel our desire to innovate. While this desire is ever-present, given the impact of the pandemic in recent months, organizations now more than ever are looking to adopt Microsoft Azure more rapidly to enable remote work, optimize costs, increase efficiency, and innovate. Today we’re announcing several new Azure infrastructure capabilities that unlock cost savings, increase efficiency, and extend innovation anywhere—directly addressing the ... Read More

Feed: Planet MySQL; Author: David Yeager; In this post I describe the various steps that allowed me to reach 3.6 million queries per second on a single VM instance using MySQL 8.0 with the help of Dynimize.It's not every day that you get to break a record. So when I discovered that you can now rent by the hour massive instances within Google Compute Cloud that support 224 virtual cores based on AMD EPYC 2 Rome processors, I had to jump at the opportunity to see what kind low hanging fruit might be out there. Low and behold I found ... Read More