Tag: query

Feed: R-bloggers. Author: Daniel Petzold. [This article was first published on RStudio Blog, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.Photo by Daniel Jerez on UnsplashData science can feel like an endless tunnel, with tremendous investment at the beginning and little visibility into where or when your results will emerge. Data science teams wrestle with many challenges, such as rapid iteration of new ideas, business alignment, productivity, transparency, and delivering durable value.As we’ve discussed ... Read More

Feed: Recent Announcements. Amazon Route 53 is a highly available and scalable cloud Domain Name System (DNS) service. Amazon Route 53 Resolver endpoints make hybrid cloud configurations easier to manage by enabling seamless DNS query resolution across your entire hybrid cloud. Create DNS endpoints and conditional forwarding rules to allow resolution of DNS namespaces between your on-premises data center and Amazon Virtual Private Cloud (Amazon VPC).   Visit the AWS Region Table to see all AWS Regions where Amazon Route 53 Resolver is available. Please visit our product page to learn more about Amazon Route 53.  ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In my day to day tasks as a DB Engineer at Mydbops we have been using multiple MySQL tools for multiple use cases to ensure an optimal performance and availability for servers managed by our Remote DBA Team. A tool like pt-online-schema can be used for any DDL changes ( Overview to DDL algorithm ), if any tool which needs to scheduled for longer period we tend to use screen or cron. Some of the problems we face when we demonise the process or use screen for running processes. The daemon process gets killed when ... Read More

Feed: Matillion. Author: Julie Polito; Applying transformations to an organization’s data helps make that data useful for analytics. However, transforming data can mean that data stored in source systems, such as Salesforce, differs from the data stored in a data warehouse. It can be a challenge for data teams to keep data in sync.  To help with this problem, Matillion has released a Salesforce Output component in v1.46. With this new component, a user can use the Salesforce API to write the contents of a source table or view back into Salesforce objects. The user can employ operations such as: ... Read More

Feed: Recent Announcements. PITR provides you with continuous backups of your Amazon Keyspaces table data to help you protect against accidental writes or deletes. When you enable PITR, Amazon Keyspaces backs up your table data automatically with per-second granularity. You can restore your table data to any second in time in the preceding 35 days. You can enable PITR with a single click in the AWS Management Console or with a simple Cassandra Query Language (CQL) API call. Using PITR, you can back up tables with hundreds of terabytes of data, with no impact on the performance or availability of ... Read More

Feed: Recent Announcements. The new Amazon Redshift console provides you new capabilities such as pause and resume and changing node type for a cluster with elastic resize. You can also now schedule your cluster operations such as pause and resume, and elastic resize.  The new monitoring dashboard in the new Redshift Console makes it easier for administrators to monitor all of their Redshift clusters from a single page by unifying all relevant information such as availability status, cluster and query performance, events, and alarms. This lets administrators quickly understand activity associated with their workloads.  The new console reduces the time ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL Firewall Overview ProxySQL’s flexible query rules engine has many uses, from Read/Write splitting, sharding and even creating firewall blacklist. This allows ProxySQL to be loved by both Performance and Security-minded engineers. Starting in ProxySQL 2.0.9, ProxySQL has another Security feature: the Firewall Whitelist. Modeled on MySQL Enterprise Firewall, this allows a security-conscious administrator to tune access to only allow certain queries. Imagine a situation where your webapp gets hacked, which exposes your user’s database credentials. If your webapp connects directly to the database, the malicious user can do what they want to your ... Read More

Feed: Microsoft Azure Blog. Author: Kirsten M. Walker. Commercial real estate developers, building owners, facilities management companies, and tenants have a huge opportunity to address, and solve for, the unique business challenges faced by their industry, by applying the Internet of Things (IoT) to buildings. For example, by leveraging data from IoT sensors and building management systems, companies can gain insights that enable them to save energy, reduce operational expenses, increase occupant comfort, and optimize space. However, the COVID-19 crisis has presented a new set of challenges for developers, owners, and management companies. New forecasts show the smart building market ... Read More

Feed: Teradata Blog. During this ongoing and unfortunate COVID-19 crisis, all of us are trying to remain safe by staying home, applying social distancing and wearing masks. The current limitations on our daily lives are very necessary for our health. But activities we have taken for granted in the past, such as eating out at a restaurant, going to the movies, shopping in a mall or having a drink with your friends are now restricted. All these activities are what freedom allows us to do and we have realized the value of these freedoms only after they are gone. In ... Read More

Feed: AWS Big Data Blog. Amazon Elasticsearch Service (Amazon ES) is a fully managed service that makes it easy for you to deploy, secure, and operate Elasticsearch in AWS at scale. It’s a widely popular service and different customers integrate it in their applications for different search use cases.Compass rearchitected their search solution with AWS services, including Amazon ES, to deliver high-quality property searches and saved searches for their customers. In this post, we learn how Compass’s search solution evolved, what challenges and benefits they found with different architectures, and how Amazon ES gives them a long-term scalable solution. We ... Read More