Category: Microsoft SQL Server

Feed: AWS Compute Blog. Author: angelhua. By Fred Wurden, GM Enterprise and BenchmarkingAWS has spent the last 11 years working with you to migrate and run your Windows workloads on AWS, and gained valuable experience along the way. We’ve taken this learning and evolved our products, services, and programs to make AWS the best place to run Windows workloads. We are excited to announce the new Migration Acceleration Program for Windows (MAP for Windows), which launches in Q1 2020. MAP for Windows provides prescriptive guidance, specialist consulting support, tooling, training, and services credits to help reduce the risk and cost ... Read More

Feed: Planet PostgreSQL. There is a less-talked-about improvement in PostgreSQL 12 which can greatly reduce the benign log entries. This patch is probably one of the smallest in PostgreSQL 12.The commit message says: Don't log incomplete startup packet if it's empty This will stop logging cases where, for example, a monitor opens a connection and immediately closes it. If the packet contains any data an incomplete packet will still be logged. Author: Tom LaneDon't log incomplete startup packet if it's emptyThis will stop logging cases where, for example, a monitor opens aconnection and immediately closes it. If the packet contains ... Read More

Feed: Blue Medora. Author: bluemedora_admin. Stackdriver log integration expands functionality across on-prem and multi-cloud Kubernetes, databases and applications with 50+ log sources GRAND RAPIDS, MICH. – Dec 3, 2019 – IT monitoring integration innovator Blue Medora today announced general availability and open access of 50+ log source integrations through its BindPlane log streaming platform, for all Google’s Stackdriver customers. This follows the October beta release and announcement from Google Cloud bringing BindPlane’s log services to market at no additional licensing cost to Stackdriver customers. Stackdriver and BindPlane together bring an in-depth hybrid-cloud, multi-cloud and on-premises view into a single dashboard, ... Read More

Feed: Microsoft Azure Blog. Author: John 'JG' Chirapurath. Over a million on-premises SQL Server databases have moved to Azure, representing a massive shift in where customers are collecting, storing, and analyzing their data. Modernizing your databases provides the opportunity to transform your data architecture. SQL Server on Azure Virtual Machines allows you to maintain control over your database and operating system while still benefiting from cloud flexibility and scale. For some, this represents a step in the journey to a fully-managed database, while others choose this deployment option for compatibility with on-premises workloads such as SQL Server Reporting Services. Whatever ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Experts know how to write performance efficient queries. Although experience ripens wisdom, there are certain things that one must understand at least to begin with. For example, you must understand key considerations of query design; how a query performs internally, where it fails, optimization patterns, etc. In this article, I’ll provide a few optimization points to ponder upon while designing a query in MySQL. Why Are Some Queries Slow? A common problem with SQL queries is that more data is being retrieved than is actually needed. Of course, there are queries that ... Read More

Feed: Recent Announcements. AWS now provides a new BYOL experience for software licenses, such as Windows and SQL Server, that require a dedicated physical server. You can now enjoy the flexibility and cost effectiveness of using your own licenses on Amazon EC2 Dedicated Hosts, but with the simplicity, resiliency, and elasticity of AWS. You can specify your Dedicated Host management preferences, such as host allocation, host capacity utilization, and instance placement in AWS License Manager. Once set up, AWS takes care of these administrative tasks on your behalf, so that you can seamlessly launch virtual machines (instances) on Dedicated Hosts ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Previous post in this series was published 3 months ago and the last Bug #96340 from it is already closed as fixed in upcoming MySQL 8.0.19. I've picked up 50+ more bugs to follow since that time, so I think I should send quick status update about interesting public MySQL bug reports that are still active.As usual I concentrate mostly on InnoDB, replication and optimizer bugs. Here is the list, starting from the oldest:Bug #96374  - "binlog rotation deadlock when innodb concurrency limit setted". This bug was reported by Jia Liu, who used gdb ... Read More

Feed: Recent Announcements. Amazon RDS for SQL Server now supports differential restores and log restores on to an RDS SQL Server db instance. With this enhancement you can now migrate to RDS for SQL Server while significantly increasing the availability of your application during the migration process ... Read More

Feed: Recent Announcements. Amazon RDS for SQL Server Multi-AZ is a high availability option which leverages either SQL Server Database Mirroring (DBM) or Always On Availability Groups (AGs), depending on your configuration. DBM and AGs meet the requirements of enterprise-grade production workloads running on SQL Server. The Multi-AZ deployment option provides enhanced availability, data durability and fault tolerance by automatically replicating database updates between two AWS Availability Zones. Availability Zones are physically separate locations with independent infrastructure engineered to be insulated from failures in other Availability Zones.  When you create or modify your SQL Server database instance to run using ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Arjun Chakraborty. By Arjun Chakraborty, Sr. Solutions Architect at AWSBy Jonathan Victor, CIO at InsurityThe increasing frequency and severity of natural disasters worldwide have brought a higher level of focus on the availability of insurance carriers’ IT systems, particularly those related to claims management. In the aftermath of a large-scale disaster—such as a Gulf Coast hurricane or California wildfire—the number of claims will jump significantly. Insurance carriers’ claims systems must be highly available (HA) and ready to scale to accommodate the needs of affected policyholders; and then scale back down afterwards, as well ... Read More