Feed: Planet MySQL. Author: InsideMySQL.com. This tutorial shows how to read information from MySQL Sakila database in an ASP.NET Core application using Connector/NET Core to explore the possibility to run this application on any .NET Core supported environment as Windows, Linux, and Mac. The first step is to create an ASP.NET Core Web Application (.NET Core) type project and name it MvcSakilaCore Note: the project name should not contain spaces Select Web Application template and No Authentication: The new project will be created: Press F5 to run the application: Stop the running application to add some code. Creating the data model Create ... Read More

Feed: Microsoft Press blog. Author: Kim Spilker. We’re pleased to announce the availability of MOS 2016 Study Guide for Microsoft Word Expert (ISBN 9780735699359), by John Pierce. Purchase from these online retailers: Microsoft Press StoreAmazonBarnes & NobleIndependent booksellers – Shop local Advance your expert skills in Word 2016. And earn the credential that proves it! Demonstrate your expertise with Microsoft Word! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Word 2016 Expert certification, this official Study Guide delivers: In-depth exam prep for each MOS objective Detailed procedures to help build the skills measured by the exam ... Read More

Feed: Planet MySQL. Author: InsideMySQL.com. MySQL Connector/Net 6.10.0 alpha is the first release to provide EntityFramework Core 1.1 support and to enable compression in the .NET Coreversion of the driver for enhanced cross-platform applicationdevelopment.To download MySQL Connector/Net 6.10.0 alpha, see the “DevelopmentReleases” tab at http://dev.mysql.com/downloads/connector/net/ Note Known limitation of this release: DbContext within an application can emit an unhandled exception. Due to this limitation, MySQL Connector/Net 6.9.9 is the preferred version to use with EF6. Functionality Added or Changed Support for compression was extended to the .NET Core version of the driver. Added support for Entity Framework (EF) Core 1.1 ... Read More

Feed: Planet MySQL. Author: MySQL Performance Blog. Hrvoje Matijakovic  | December 9, 2016 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit PREVIOUS POST Percona announces the availability of Percona Toolkit 2.2.20. Released December 9, 2016, Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL server and system tasks that DBAs find too difficult or complex for to perform manually. Percona Toolkit, like all Percona software, is free and open source. This release is the current GA (Generally Available) stable release in the 2.2 series. Downloads are available here and from the Percona Software Repositories. New Features: : New --pause-file option ... Read More

Feed: Planet PostgreSQL. PG Phriday: Planner Pitfalls December 9th, 2016 | Published in Database, Tech Talk | No Comments Recently a coworker asked me this question: Should I expect variance between minutes and hours for the same query? And I was forced to give him this answer: Potentially, but not commonly. Query planning is an inexact science, and regardless of the query being the “same query,” the data is not the “same data.” This isn’t generally the case, but on occasion, changes in data can affect the query execution path. Usually this is a good thing, as the database accounts ... Read More

Feed: SAS BlogsRSS – SAS Blogs. Author: Jonathan Zenouda. During a recent customer visit, I was asked how to include a calculated variable within SAS Asset Performance Analytics’ (APA) Root Cause Analysis workflow. This is a simple request. Is there a simple approach to do this? To remind you, in the APA workflow, an ETL Administrator makes a Data Mart available in the solution for the APA users. They can select variables and explore, analyze and create a model based on the columns present in the Data Mart. But if you want to analyze a calculated column, like a difference ... Read More

Feed: Planet MySQL. Author: MySQL Server Dev Team. In MySQL 8.0.0 we introduced many new features; among those, three new functions that ease and enhance the support for working with UUIDs. Background A UUID is just a 128-bit value and it is usually represented in human-readable format as an UTF8 string composed of 5 groups of hexadecimal characters separated by dashes. Ex: 12345678-1234-5678-1234-567812345678 12345678-1234-5678-1234-567812345678 UUIDs can have different underlying structure depending on the version. The RFC4122 specifies 5 versions. The one that MySQL implements in the UUID() function ... Read More

Feed: Microsoft Press blog. Author: Kim Spilker. If you’re wondering how to implement and manage Microsoft Operations Management Suite (OMS) to monitor a hybrid enterprise infrastructure, be sure to check out this course with Yuri Diogenes. Learn about deployment, antimalware, and update assessments, in addition to incident detection and response. Recommended resources for this course include Yuri’s latest book, Microsoft Azure Security Infrastructure, co-authored by Dr. Thomas Shinder and Debra Littlejohn Shinder. Watch the video below or at the Microsoft Virtual Academy. What you will learn Get the details on security challenges for IT operations and how the OMS Security and Audit ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. Python is one of the most popular and fastest-growing languages used today. Pyodbc (Python-SQL Server Connector) is an open source Python module maintained by Michael Kleehammer that uses ODBC Drivers to connect to SQL Server. It allows you to connect from the platform of your choice to SQL Server on-premises and in the cloud. Pyodbc is also cross platform and can be installed using pip. We recently announced SQL Server v.Next CTP1 on Linux and Windows, which brings the power of SQL Server to both Windows and — for the first time ... Read More

Feed: Microsoft Dynamics 365 Blog. Author: Tricia Morris. In business, everyone is competing to develop the next big thing. You could have a billion dollar business idea. But without the proper execution, it’s not worth a cent. According to an Economist Intelligence Unit (EIU) survey, companies typically realize only 60% of their strategy’s potential due to defects and breakdowns in planning and execution.For that reason, more and more companies are developing innovation labs. For some, the motivation for developing these labs is going after new markets. For others, it’s the chance to learn, try and sometimes fail fast. In a ... Read More