Tag: group

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Leo Li - Program Manager of Microsoft. Dear all, I am very pleased to announce that the Linux version SSIS is available in CTP 2.1. Since March 2016 Microsoft announced that SQL Server plan to support Linux platform, SSIS team has been working on any possibility to also support SSIS on Linux OS. Now you can download SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines. In this version, you can: Run SSIS packages on Linux OS, monitor and track execution ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Leo Li - Program Manager of Microsoft. Dear all, I am very pleased to announce that the Linux version SSIS is available in CTP 2.1. Since March 2016 Microsoft announced that SQL Server plan to support Linux platform, SSIS team has been working on any possibility to also support SSIS on Linux OS. Now you can download SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines. In this version, you can: Run SSIS packages on Linux OS, monitor and track execution ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: Lingxi Li. PowerShell is a powerful task automation tool from Microsoft. With Azure PowerShell cmdlets, you can write PowerShell scripts to automate various Azure-related tasks. It would be quite nice if we can run PowerShell scripts within SSIS. Although SSIS does not provide something like Execute PowerShell Script Task out of the box, it does have an Execute Process Task which can be used to run PowerShell scripts just as easily. Specifically, the PowerShell.exe command-line comes with a -File parameter: Runs the specified script in the local scope (“dot-sourced”), so that ... Read More

Feed: Severalnines. In this blog post, we are going to show you some examples of things that can go wrong in Galera - inexplicable node crashes, network splits, clusters that won’t restart and inconsistent data. We’ll take a look at the data stored in log files to diagnose the problems, and discuss how we can deal with these. This builds upon the previous post, where we looked into log files produced by Galera (error log and innobackup.* logs). We discussed how regular, “normal” activity looks like - from initialization of Galera replication to Incremental State Transfer (IST) and State Snapshot ... Read More

Feed: Severalnines. Requires ClusterControl 1.2.11 or later. Applies to MySQL single instances, replications and Galera clusters. You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a backup using xtrabackup. Or, if it is a Galera cluster, you have to recover a galera node using wsrep_sst_method=xtrabackup[-v2]. Unfortunately it fails and the following is emitted in the Job Logs messages: xtrabackup: Generating a list of tablespaces 2015-11-03 19:36:02 7fdef130a780 InnoDB: Operating system error number 24 in a file operation. InnoDB: Error number 24 means 'Too many open files'. InnoDB: Some operating ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: JimmyWongMS. Hi all, In the SQL PASS Summit of 2016, I presented a session about “Running SSIS on Azure VM – Do more with less money” and it was well received based on the session feedback. Therefore, I am extracting some key content from my SQL PASS presentation and sharing it on this blog so that more SSIS users can benefit from it. Why running SSIS on Azure VM? Pay per use with support of BYOL Elasticity with cost options (1 Core 2GB 1TB -> 32 Core 512GB 64TB) Extremely Secure at physical/infrastructure/SQL level Reliable storage ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: DionYe. In 2008, SSIS team posted a blog about loading 1TB data in 30 minutes, and after 8 years, hardware and software are rapidly improved, now we are doing similar experiment with only on two servers which can achieve same performance. In our experiment, we use the latest SSIS 2016 and we can load 1TB data in 30 minutes (1.5TB dataset in 43 minutes). In addition, we also tested data loading into table with column store index and provide the details in end this article Design of this experiment is almost ... Read More

Feed: Severalnines. In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in the last post, how to make your setup highly available through HAProxy and MaxScale.So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last ... Read More

Feed: Severalnines. This is part 2 of our blog on how to troubleshoot Galera cluster - SST errors, and problems with network streaming. In part 1 of the blog, we covered issues ranging from node crashes to clusters that won’t restart, network splits and inconsistent data. Note that the issues described are all examples inspired from real life incidents in production environments. This is the eighteenth installment in the ‘Become a MySQL DBA’ blog series. Our previous posts in the DBA series include: Troubleshooting Galera cluster issues - part 1, Galera cluster diagnostic logs, Understanding the MySQL error log, Optimizing ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Michael Garcia. You can connect securely millions of objects to AWS IoT using our AWS SDKs or the AWS IoT Device SDKs. In the context of industrial IoT, objects are usually connected to a gateway for multiple reasons: sensors can be very constrained and not able to directly connect to the cloud, sensors are only capable of using other protocols than MQTT or you might might need to perform analytics and processing locally on the gateway.One feature of local MQTT broker is called ‘Bridge’ and will enable you to ... Read More