Tag: application

Feed: Planet MySQL; Author: Searce Engineering; Design A Highly Available MySQL Clusters With Orchestrator And ProxySQL In GCP — Part 1Recently we have migrated one of our customer's infra to GCP and post the migration we published some adventures on ProxySQL which we implemented for them.Reduce MySQL Memory Utilization With ProxySQL MultiplexingHow max_prepared_stmt_count can bring down productionNow, we are going to implement an HA solution with customer filter for failover. We have done a PoC and the blog is about this PoC configurations. And again the whole setup has been implemented in GCP. You can follow the same steps for AWS and Azure.Credits:A ... Read More

Feed: Blog. Author: Jim Donahoe; Hello everybody! One of my favorite features in Azure SQL DBaaS is Failover Groups.  I have been working with these since they were in preview and I cannot stress the value of this feature enough!  In my former company, we had 22 web applications that all had connections to various databases.  We had all of our databases configured for Geo-Replication already, but still if we had to failover, we had to update each connection string for the web apps along with others which became a tedious process. In came Failover Groups to the rescue!  With ... Read More

Feed: Blog. Author: Jim Donahoe; Hey everybody!I am asked by clients/team members/friends a lot about how to setup TEMPDB to use the D: drive on an Azure VM for SQL Server.  Following the steps listed below is how I configure it on my VM’s. This seems to be the most standard way folks are doing it.  However, this is not always the best practice to do.  The reason being is that the drive size varies depending on the VM size you choose. Read the section “Temporary Disk” first, then decide on where to place your TempDB. Temporary disk – AKA ... Read More

Feed: Blog. Author: Zoe Bell; Are you hoping to become a Microsoft MVP? Or, have you already gone through the application process yourself? Then participate in our next Twitter Chat!Our next #SQLChat will take place on Wednesday, February 7th at 11 AM CT with Mindy Curnutt (@sqlgirl). Mindy is a Microsoft MVP herself, and will be leading a conversation where actionable tips and information on how to receive this Most Valuable Professional designation will be shared. This will be a great opportunity to address personal hesitations and questions about the program with the SQL Family. This #SQLChat will allow members ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Chris Snowden. The Internet of Things (IoT) offers the potential for data acquisition and digital interaction in areas previously inaccessible at an unprecedented scale. The magnitude of this opportunity affects individuals, organizations, and governments in many different ways. In manufacturing, for example, many makers of existing products are racing to integrate connected features into their offerings and deliver these products to the market in substantial quantities. Startups and other organizations are creating completely new product lines built around connectability and cloud-based service integration. In order to address the complexity ... Read More

Feed: Blog. Author: Peter V.; Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL queries prevent other SQL queries from using these resources. This can eventually lead to blocking. Common causes of blocking are poor execution plans, lack of proper database indexes, poor application design, and misconfigured SQL Servers. Finding resource-intensive SQL queries is necessary for performance monitoring and tuning. Accurately identifying resource-intensive SQL queries is necessary to troubleshoot potential performance issues in early stages before they cause serious problems.Monitor and diagnose the performance of SQL queries for Microsoft SQL Server with IDERA ... Read More

Feed: Blog. Author: Scott Stone; We are pleased to announce the availability of a new suite of performance products packaged to fill the core needs of most SQL Server DBAs.Discovery and Tuning Suite includes products to measure and optimize SQL Server performance for your critical SQL Server instances while allowing you to continuously discover new instances and monitor them with a lighter footprint.  The suite includes: SQL Diagnostic Manager Pro - Comprehensive and adaptive SQL Server performance tool to monitor and diagnose most SQL Server performance issues.  Pro edition includes SQL Workload Analysis with a simplified interface to drill to ... Read More

Feed: The Connector by Workato. Author: Amlan Debnath; HR departments often face increasing pressure to not only attract but also retain highly sought after talent pools. After all, employees form the backbone of a company—and any strong business is only as good as its people. According to Capterra, 75% of hiring managers use either applicant tracking or recruiting software to improve their hiring process. And according to Gartner, cloud-based HR software expenditures are increasing faster than spending on on-premise solutions. In fact, HR cloud solutions will constitute 50% or more of all HR technology spending by the end of this ... Read More

Feed: The Connector by Workato. Author: Nicole Lee; A comprehensive suite of business apps has become an essential toolkit for any digital-first organization. According to an IDC survey, nearly one-third of the worldwide enterprise application market will be SaaS-based by 2018; this number will have doubled from $22.6 billion in annual SaaS revenue in 2013 to an estimated $50.8 billion next year. Putting these metrics into perspective, the average enterprise currently uses 1,427 distinct cloud services; the average employee actively uses 36 cloud services at work. By 2020—not too long from now—Gartner predicts that cloud software will become the default ... Read More

Feed: Blog. Author: bscalzo; This blog title may seem a little odd at first. Then again today's news is rife with stories about data breaches, therefore on second thought it's not as odd a title as you may have initially thought. So when is your data actually safe? Since almost all data these days is held in some database somewhere, the real question is when is the data within that database safe?In the good old days (for those of us old enough to remember them or at least not so old as to have forgotten), company databases were as safe ... Read More