Tag: SQL

Feed: Puppet.com Blog RSS Feed. Author: ; The Windows Platform team here at Puppet has been working hard on updating our key Windows modules. Customers who use our Puppet Supported SQL Server module will be happy to know that we added support for SQL Server 2016. We also added support for internationalization and the new Puppet 5 platform. You can see all of the updates here.We also made updates to our supported IIS and ACL modules. Both now support Puppet 5. Additionally:IIS 4.1 includes bug fixes based on customer feedback. See the changelog for more details.ACL 2.0.1 allows you to ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Today we are thrilled to announce, alongside our friends at Google, a new project between Google and Puppet to make it easy to manage Google Cloud Platform (GCP) services with Puppet. To learn more, register for the webinar with me and Nelson Araujo from Google on 13 September 2017.The initial release includes five open source Puppet Approved modules for managing GCP services, using the Puppet DSL. All are available from the Puppet Forge.The modulesThere is also one additional helper module that provides a single unified authentication mechanism for all modules that is available ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; The move to the cloud is the most important sea change we have experienced in the technology world since the web revolutionized how businesses interact with their customers. The benefits most often associated with cloud computing are around agility (the ability to create virtual resources in minutes) and capital efficiency (the ability to stand up infrastructure with no up-front capital costs). While agility and capital efficiency are critical drivers, the most important shift we are seeing is that customers expect vendors will take over an increasing amount of the operational burden of running ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: pearl-chen; If you’re at a multinational company, running your data operations across various clouds and geographies can be a time-consuming, complicated process. Cloud Pak for Data, our leading data and AI platform, partners with Cockroach to solve multicloud and compliance challenges so organizations can scale their data strategies across the globe.CockroachDB is a relational database for next generation, cloud-native applications. Named for the most resilient species on earth, CockroachDB delivers a durable, consistent, distributed SQL transactional database at scale. Said VP of business development Eric Goldstein: “We've built the ... Read More

Author: . We typically talk about transactions in the context of Data Manipulation Language (DML), but the same principles apply when we talk about Data Definition Language (DDL). As databases increasingly include transactional DDL, we should stop and think about the history of transactional DDL. Transactional DDL can help with application availability by allowing you perform multiple modifications in a single operation, making software upgrades simpler. You’re less likely to find yourself dealing with a partially upgraded system that requires your database administrator (DBA) to go in and fix everything by hand, losing hours of their time and slowing your ... Read More

Author: mkysel. We typically talk about transactions in the context of Data Manipulation Language (DML), but the same principles apply when we talk about Data Definition Language (DDL). As databases increasingly include transactional DDL, we should stop and think about the history of transactional DDL. Transactional DDL can help with application availability by allowing you perform multiple modifications in a single operation, making software upgrades simpler. You’re less likely to find yourself dealing with a partially upgraded system that requires your database administrator (DBA) to go in and fix everything by hand, losing hours of their time and slowing your ... Read More

Feed: Planet MySQL; Author: Percona Community; Wayne Leutwyler  | January 17, 2020 |  Posted In: MySQL, Open Source Databases, Percona Server for MySQLIn my last blog post I showed you how to get the entire Percona “Stack” up and running on a Raspberry Pi. This time around, I would like to show the impact on performance between using an SSD hard disk and a standard hard disk.Disk performance is a key factor in Percona Server for MySQL (or any RDB platform) performance on a Raspberry Pi 4.Test set upEach test below was run three times per Hard Disk and I took the best ... Read More

Feed: AWS Partner Network (APN) Blog. Author: AWS Admin. By Matt Yellen, Principal Engineer at CloudZeroAnalyzing large datasets can be challenging, especially if you aren’t thinking about certain characteristics of the data and what you’re ultimately looking to achieve. There are a number of factors organizations need to consider in order to build systems that are flexible, affordable, and fast, while at the same time meeting the needs of their end users. For example, you need to understand where your data is coming from, how often it changes, and how the data will be queried. In some cases, a fixed ... Read More

Feed: erwin Expert Blog – erwin, Inc.. Author: Zak Cole. What is Data Modeling?Data modeling is a process that enables organizations to discover, design, visualize, standardize and deploy high-quality data assets through an intuitive, graphical interface. Data models provide visualization, create additional metadata and standardize data design across the enterprise. As the value of data and the way it is used by organizations has changed over the years, so too has data modeling. In the modern context, data modeling is a function of data governance. While data modeling has always been the best way to understand complex data sources and ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; According to the National Vulnerability Database (NVD) maintained by the U.S. National Institute for Standards and Technology (NIST), 92 percent of reported vulnerabilities are in applications, and not due to insecure networks. That’s 11 out of 12. But this doesn’t mean you can throw away your firewall or go back to using telnet for your remote logins. Considering the NIST NVD contains over 86,000 known vulnerabilities, that still leaves around 7,000 reported network vulnerabilities. Using a layered approach to security is still the best approach.This does mean, however, that your quality assurance team ... Read More