Category: Tutorials

Feed: Featured Blog Posts - Data Science Central. Author: Deepanshu Bhalla. R language is the world's most widely used programming language for statistical analysis, predictive modeling and data science. It's popularity is claimed in many recent surveys and studies. R programming language is getting powerful day by day as number of supported packages grows. Some of big IT companies such as Microsoft and IBM have also started developing packages on R and offering enterprise version of R. Table of Contents 50 R Tutorials for Beginners 30+ Data Science with R Tutorials Text Mining with R R Interview Questions and Answers ... Read More

Feed: Planet MySQL. Author: MySQL Server Dev Team. Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea). So many people end up procrastinating setting up HA until disaster strikes and downtime happens. The MySQL team at Oracle has now released a preview of a solution that aims to make it ... Read More

Feed: AWS Big Data Blog. Prasad Alle is a consultant with AWS Professional Services Intuit, a creator of business and financial management solutions, is a leading enterprise customer for AWS. The Intuit Data team (IDEA) at Intuit is responsible for building platforms and products that enable a data-driven personalized experience across Intuit products and services. One dimension of this platform is the streaming data pipeline that enables event-based data to be available for both analytic and real time applications. These include—but are not limited to—applications for personalization, product discovery, fraud detection, and more. The challenge is building ... Read More

Feed: Severalnines. Of the different types of clustered MySQL environments, NDB Cluster is among the ones that involves more effort and resource to administer. And unless you are a command line freak, you would want to use a tool that gives you a full view of what is going on in your cluster. It is possible to install ClusterControl and monitor your existing MySQL Cluster (NDB). In this blog post, we are going to show you on how to add two existing MySQL Clusters (production and staging) into ClusterControl. ClusterControl: 192.168.55.170 Cluster #1: Management/API node: mgmd-api1 - 192.168.55.71 Management/API node: ... Read More

Reviewed By: Denzil Ribeiro, Kun Cheng Deleting all rows from a given partition is a very common operation on a partitioned table, especially in a sliding window scenario. In a sliding window scenario, when a new period starts, a new partition is created for the new data corresponding to this period, and the oldest partition is either removed or archived. To remove or archive the oldest partition, the general practice is to switch the partition out to a temporary staging table. The SWITCH operation for a partition is a simple statement, but it takes a bit of preparation for the ... Read More

Reviewed by Panagiotis Antonopoulos, Jakub Szymaszek, Raghav Kaushik Always Encrypted is one of the compelling features in SQL Server 2016 and in Azure SQL DB which provides a unique guarantee that data in the database cannot be viewed, accidentally or intentionally by users who do not have the ‘master key’ required to decrypt that data. If you want to know more about this feature, please review the product documentation at the previous link or watch the Channel 9 video on this topic. Customer Scenario In a recent case, we were working with a customer who was trying to use Table ... Read More

Summary: improve performance of you queries by including hot data into index If you have a big table, let's say with 100 columns and million rows, and some of those 100 columns, say 5 of them are being used in queries very often, you may significantly improve performance by building a special non-clustered index with INCLUDE clause. People often overlook this opportunity, but it's amazing. Something like this: table "bigTable" contains plenty of columns rare01...rare85 which are rarely required. Users very often search by columns "oftenSearchBy01" and "oftenSearchBy02". IF EXISTS ( SELECT 1 FROM sys.objects WHERE name='bigTable' AND type='U' ) ... Read More

Reviewed by: Denzil Ribeiro, Mike Weiner, Arvind Shyamsundar, Sanjay Mishra, Murshed Zaman, Peter Byrne, Purvi Shah SQL Server 2016 introduces changes to the default behavior of checkpoint. In a recent customer engagement, we found the behavior change to result in higher disk (write) queues on SQL Server 2016 vs. the same workload on SQL Server 2012. In this blog we’ll describe the changes, options are available to control these and what impact they might have on workloads that are upgrading to SQL Server 2016. In this specific case changing the database to use the new default behavior of checkpoint proved ... Read More

Arvind Shyamsundar, Lee Woods Reviewed by Jeff Papiez, Mike Weiner, Troy Moen, Suresh Kandoth It has been a while now since SQL Server 2016 has been generally available. We trust you are excited with the great capabilities that SQL Server 2016 brings to you, and have either already installed or will be installing it soon. Critical Visual C++ Runtime Update At this time, we want to remind you of a critical Microsoft Visual C++ 2013 runtime pre-requisite update that may be* required on machines where SQL Server 2016 will be, or has been, installed. Installing this, via either of the ... Read More

Arvind Shyamsundar Reviewed by: Gjorgji Gjeorgjievski, Sunil Agarwal, Vassilis Papadimos, Denzil Ribeiro, Mike Weiner, Mike Ruthruff, Murshed Zaman, Joe Sack In a previous post we have introduced you to the parallel INSERT operator in SQL Server 2016. In general, the parallel insert functionality has proven to be a really useful tool for ETL / data loading workloads. As an outcome of various SQLCAT engagements with customers, we learnt about some nuances when using this feature. As promised previously, here are those considerations and tips to keep in mind when using parallel INSERT…SELECT in the real world. For convenience we have ... Read More