Tag: INSERT

Feed: SQL Server Customer Advisory Team. Author: Arvind Shyamsundar. Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Nellie Gustafsson, Umachandar Jayachandran, Dimitri Furman (Microsoft) This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions. SQLCAT has been working with them in their process of adopting SQL Server 2017. Microsoft introduced the ability to invoke external Python scripts in SQL Server 2017, and this capability to effectively move ‘intelligence’ closer to the data, was a big ... Read More

Feed: R-bloggers. Author: R – Bio7 Website. 17.10.2017 A new version of Bio7 for Windows and Linux is available. The MacOSX version will be released soon, too. The application Bio7 is an integrated development environment for ecological modelling, scientific image analysis and statistical analysis. Beside many different tools it contains a complete Graphical User Interface for R. The application itself is based on an RCP-Eclipse-Environment (Rich-Client-Platform) which offers a huge flexibility in configuration and extensibility because of its plug-in structure and the possibility of customization. For  a short overview see this older video. General Improved the dark theme for Bio7 ... Read More

Feed: All - O'Reilly Media. Author: Mike Loukides. Winding road (source: PublicDomainPictures.net) For more, check out the Implementing AI track from the Artificial Intelligence Conference 2017 in San Francisco. Do you have your AI strategy? If you don't, be prepared to lose. Or at least, so say the consultants, tech journalists, and pundits. You can't possibly be a competitive modern company without an AI strategy. We are the last people to say that AI isn't important, or that having an AI strategy isn't a good thing—or even that, if you don’t start thinking about AI initiatives now, you’ll end up ... Read More

Feed: Planet MySQL; Author: Jonathan Levin; The following query gets data from performance_schema in MySQL and attempts to regex the digest to the list of tables in the same schema. SELECT d.*, (SELECT group_concat(distinct TABLE_NAME) FROM information_schema.TABLES WHERE table_schema = d.schema_name and d.digest_text regexp table_name) table_name FROM performance_schema.events_statements_summary_by_digest d WHERE d.DIGEST_TEXT regexp "^(SELECT|UPDATE|DELETE|REPLACE|INSERT|CREATE)" and d.LAST_SEEN >= curdate() - interval 7 day ORDER BY d.SUM_TIMER_WAIT DESC limit 10G ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; Follow @vlad_mihalcea Although there is an SQL Standard, every relational database is ultimately unique, and you need to adjust your data access layer so that you get the most out of the relational database in use. In this article, we are going to see what you can do to boost up performance when using MySQL with JPA and Hibernate. Every entity needs to have an identifier which uniquely identifies the table record associated with this entity. JPA and Hibernate allow you to automatically generate entity identifiers based on three different strategies: IDENTITY SEQUENCE TABLE ... Read More

Feed: Percona Database Performance Blog. Author: Bradley Mickel. Bradley Mickel  | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL PREVIOUS POST In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB Server (referred to as MariaDB for brevity) has similar roots as Percona Server for MySQL, but is quickly diverging from MySQL compatibility ... Read More

Feed: Planet big data. Author: Praveen Sripati. There are different ways of kick starting a Hive/Pig/MR/Spark on Amazon EMR. We already looked at how to submit a Hive job or a step from the AWS EMR management console here. This approach is cool, but doesn't have much scope for automation.Here are the other ways to start the Big Data Processing with some level of automation.1) Use Apache Oozie to create a workflow and a coordinator.2) Use the AWS CLI3) Login to the master instance and use the Hive shellIn the above, Option 1 is a bit complicated and will be ... Read More

Feed: SQL Server Customer Advisory Team. Author: Arvind Shyamsundar. Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Rajesh Setlem, Joe Sack, Dimitri Furman, Denzil Ribeiro (Microsoft) This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions. SQLCAT has been working with them in their process of adopting SQL Server 2017. During a recent lab engagement, we found a set of seemingly innocuous query (anti-)patterns which were actually having a significant impact on overall performance. In ... Read More

Feed: The Information Lab. Author: Pablo Saenz de Tejada. 16 October, 2017 | Pablo Sáenz de Tejada Vizzes in tooltips in Tableau 10.5 uring the Devs on Stage keynote at the Tableau Conference in Las Vegas (next year will be in New Orleans if you want to book your ticket already), one of the most exciting new features was announced for the next version of Tableau 10.5: the possibility to add visualizations in tooltips. Even better, you can try and have a play with this new functionality in the Beta version that is already available. How to add a viz ... Read More

Feed: Planet MySQL; Author: GitHub Engineering; At GitHub, we use MySQL as the main database technology backing our services. We run classic MySQL master-replica setups, where writes go to the master, and replicas replay master’s changes asynchronously. To be able to serve our traffic we read data from the MySQL replicas. To scale our traffic we may add more replica servers. Reading from the master does not scale and we prefer to minimize master reads. With asynchronous replication, changes we make to the master are not immediately reflected on replicas. Each replica pulls changes from its master and replays them ... Read More