Tag: instance

Feed: Planet PostgreSQL. Table partitioning has been evolving since the feature was added to PostgreSQL in version 10.  Version 11 saw some vast improvements, as I mentioned in a previous blog post.During the PostgreSQL 12 development cycle, there was a big focus on scaling partitioning to make it not only perform better, but perform better with a larger number of partitions. Here I’d like to talk about what has been improved. COPY Performance: Bulk loading data into a partitioned table using COPY is now able to make use of bulk-inserts.  Previously only one row was inserted at a time. The ... Read More

Feed: All Oracle Press Releases. Oracle today announced that it is expanding its security portfolio with new cloud services designed to automatically help protect cloud workloads and data from risks posed by misconfigurations and cyber threats. The three new cloud services, including Oracle Data Safe, Oracle Cloud Guard and Oracle Maximum Security Zones provide centralized security configuration and posture management, as well as automated enforcement of security practices. Together with Oracle Data Safe, Cloud Guard and Maximum Security Zones, customers can better protect their critical workloads. These intelligent systems operate in the background enforcing security practices, gathering telemetry from across ... Read More

Feed: James Serra's Blog. Author: James Serra. With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used for many of them, a common question I am asked about is “How can I access data in ADLS Gen2 instead of a copy of the data in another product (i.e. Azure SQL Data Warehouse)?”. The benefits of accessing ADLS Gen2 directly is less ETL, less cost, to see if the data in the data lake has value before making it part of ETL, for a one-time report, for a data scientist who wants to use the data to ... Read More

Feed: Planet MySQL; Author: Simon Mudd; I posted a few days ago some initial thoughts on the the MySQL native cloning functionality. Overall this looks good and I need to spend time to test further. I’m here in San Francisco ahead of Oracle Open World which starts today. As is usual with trips like this jet lag wakes you up rather early. So I thought I would add some further thoughts on the topic which I think may also be of interest. Version compatibility: The current clone process requires the source and destination to be identical. That is quite a ... Read More

Feed: Big Data Made Simple. Author: Christopher Pappas. When we think about technology, everything from our computers to our smartphones take the center stage in our brain.Every technology that we use for work, recreation, or relaxation requires some of the other forms of data which has its own good, bad and ugly.The good: This data enhances customer experience and allows service providers to personalize user experience.The bad: All the digital devices store data locally which might become a point of concern for some people or companies.The ugly: Virtually all of such devices are hackable.It is a rather scary thought to ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Jamie Cole, Research and Innovation Lead; Jamie Cole, Research and Innovation Lead In Matillion ETL version 1.40, Enterprise customers  (those on a Large or XLarge instance of Matillion) can now utilize Git. Git is a distributed version control system that is used to track code changes through the development lifecycle process. Some of our Enterprise customers have corporate policies that necessitate that all code, including their Matillion jobs, and associated items are stored in Git. This is usually for code control, business continuity, and disaster recovery. Git integration support is another way ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . SQL Server Integration Services (SSIS) was first made available well over a decade ago as part of the release of SQL Server 2005, replacing Data Transformation Services, which had been integrated into the product since SQL Server 7.0. This enduring pedigree has been interrupted by the introduction of Azure SQL Database, which, unlike its on-premises counterparts, restricted its capabilities to those implemented directly by the database engine. Unfortunately this meant that existing SSIS packages could not be used to perform extraction, transformation, and loading (ETL) tasks by relying on computing and storage ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Racheal Chapman. How secure is your data? What measures do you take to hide your confidential data? Can you confidently say that data breaching stands nowhere close to your security? Data breaching is not new and neither will it disappear. As technology rises with new developments, hackers are studying the tools closely to understand how they can grasp your sensitive information? In 2019, one of the articles stated, ‘’61% of IT professionals have experienced a serious data breach’’. Imagine when the experts get hit with such a crucial issue, do you ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Jorge Castanon. Ancient ruins are sometimes discovered after long years investigating regions of the world covered by dense jungle or giant forests. The feeling of an archaeologist at that moment of discovery gives a window into the feeling data scientists often have when getting a view of their data — through visualizations — that clarifies a key aspect of the analysis. Ancient ruins are sometimes discovered after long years investigating regions of the world covered by dense jungle or giant forests. The feeling of an archaeologist at that moment of discovery ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Henry Axelrod. By Henry Axelrod, Partner Solutions Architect at AWSBeing able to access files via standard file protocols from one or more locations is important to many organizations. In this post, I will explore how Nasuni’s solution allows customers to access files across many locations through the use of a physical or virtual appliance. You can run these appliances in a data center or the Amazon Web Services (AWS) Cloud. Nasuni is an AWS Partner Network (APN) Advanced Technology Partner with the AWS Storage Competency. With industry-leading encryption, local performance, and pay-as-you-go pricing, Nasuni ... Read More