Friday, July 22, 2016

Learning to COPE with Microservices | CSS-Tricks

Learning to COPE with Microservices | CSS-Tricks



To make the integration of API with other systems even easier, there’s a suite of libraries like Passport, to abstract the authentication layer (available for Node.js, PHP and React Native), or API wrapper, a high level toolkit for performing CRUD operations.



at DADI, using their open-source
platform for content and data management, which is built specifically in
support of microservices and the principle of COPE. 



 

Thursday, July 21, 2016

Cloud Deployment: It’s All About Cloud Automation | horovits

Cloud Deployment: It’s All About Cloud Automation | horovits



Amazon Web Services (AWS) include the very popular Relational Database Service (RDS). This service is an adaptation of a MySQL database to the Amazon cloud.



For the full MySQL cloud automation open source code see this public GitHub repo

Awesome MySQL

Awesome MySQL

How To Win With Agile By Cheating (a.k.a., Rules Are For Other People) -- ADTmag

How To Win With Agile By Cheating (a.k.a., Rules Are For Other People) -- ADTmag



The team you've joined is stalled on development. They haven't been
able to push a story card through their Kanban board in over three
weeks. The team is having yet another meeting to discuss how to resolve
the issue. And, lucky you, you are a part of it.

Tuesday, July 19, 2016

What is the best MySQL client for Windows? - Amazon Aurora RDS

(9) What is the best MySQL client for Mac OS X or Windows? - Quora





Commercial Clients with a Free Option
Commercial Clients

Key Takeaway Points and Lessons Learned from QCon New York 2016

Key Takeaway Points and Lessons Learned from QCon New York 2016









Architectures You've Always Wondered About


Code Quality in Practice

Code Quality in Practice

InfoQ eMag: Exploring Container Technology in the Real World

InfoQ eMag: Exploring Container Technology in the Real World

Linked data is what we (and libraries) have been waiting for | NoveList Blog | EBSCOhost

Linked data is what we (and libraries) have been waiting for | NoveList Blog | EBSCOhost



Linked data solves that by transforming library records into digital formats that web search engines understand. 



Libraries have some great data hidden inside MARC records. The MARC
standard was designed to solve specific problems at a specific point in
time -- and it worked pretty well for a while. But the web has really
transformed the structure and use of information, and it’s time for a
change to library data.

There is ongoing work underway to develop new standards -- the
Library of Congress and others have identified BIBFRAME as a path
forward. There are other digital formats that should also be considered
as part of the solution, such as Schema.org.

10 essential MySQL tools for admins | InfoWorld

10 essential MySQL tools for admins | InfoWorld

How does Amazon Aurora compare to RDS for MySQL and MS SQL Server on Azure

Benchmarking Aurora vs MySQL: Is Amazon’s New DB Really 5x Faster? | Takipi Blog

Ins and Outs of Running MySQL on AWS - O'Reilly Radar
Limits for Amazon RDS - Amazon Relational Database Service

Planning for a Successful Database Lifecycle
Best Practices for Amazon RDS - Amazon Relational Database Service

Pros and Cons of RDS vs EC2 for MySQL with AWS | Laurence Gellert's Blog


Top 10 Things to Know About Amazon RDS | Webyog Blog
RDS exposes the following metrics to CloudWatch to compensate for not providing SSH access to the underlying EC2 instance:
  • CPUUtilization—The percentage of CPU utilization
  • FreeStorageSpace—The amount of available storage space
  • DatabaseConnections—The number of database connections in use
  • ReadIOPS and WriteIOPS—The average number of disk I/O operations per second
  • ReadLatency and WriteLatency—The average amount of time taken per disk I/O operation
  • ReadThroughput and WriteThroughput—The average number of bytes read from or written to disk per second




AWS Training | AWS Security Fundamentals



This self-paced course is designed to introduce you to fundamental cloud
computing and AWS security concepts including AWS access control and
management, governance, logging, and encryption methods. It also covers
security-related compliance protocols and risk management strategies, as
well as procedures related to auditing your AWS security
infrastructure.

Signing and Authenticating REST Requests - Amazon Simple Storage Service

Authenticating Requests (AWS Signature Version 4) - Amazon Simple Storage Service

Technology Partner: Amazon Web Services | ExtraHop

Application Performance Management | ExtraHop

The Cloud Migration Checklist

Training To-Do List for New DBA - SQLServerCentral

Training To-Do List for New DBA - SQLServerCentral




o Stairway to SQL Server Security: http://www.sqlservercentral.com/stairway/110890/
o Stairway to Transaction Logs: http://www.sqlservercentral.com/stairway/73776/

Register for the Microsoft Virtual Academy. Pay special attention to:
o Database Fundamentals: https://mva.microsoft.com/en-US/training-courses/database-fundamentals-8243
o Updating your Skillset to SQL 2014: https://mva.microsoft.com/en-US/training-courses/updating-your-database-management-skills-to-sql-server-2014-8313?l=S3j693Yy_704984382


Codecademy.com free online learning labs for various languages including non-vendor specific tutorials on the SQL language standard:

Pluralsight.com contains many hours of high quality instructional videos for many, many technical platforms.

Monday, July 18, 2016

MySQL GUI Tools | Database Tools for MySQL by SQL Maestro Group

MySQL GUI Tools | Database Tools for MySQL by SQL Maestro Group



SQL Maestro for MySQL


A complete MySQL GUI admin tool with support of such advanced
MySQL features as views, procedures, triggers, and table partitioning.
 
Code Factory for MySQL
Gives you a powerful set of tools to edit SQL scripts and build SQL statements visually.
 

Friday, July 15, 2016

Introduction to communities of practice | COP

Introduction to communities of practice | Wenger-Trayner

Agile Teams Need Performance Testing in Their Definition of Done Registration

Agile Teams Need Performance Testing in Their Definition of Done Registration



with performance testing becoming an integral part of user experience,
agile teams no longer have the option to produce user stories for web
and mobile apps where the code doesn't scale once it's under load.



learn practices for testing performance without slowing down agile development. You'll also learn:


  • The advantages of using "definition of done" for performance instead of non-functional stories
  • How to add performance testing to your "definition of done"
  • When completed user stories can skip performance testing
  • How to automate performance testing to keep pace with development

Getting Started with MySQL Stored Procedures

Getting Started with MySQL Stored Procedures



MySQL :: MySQL Connector/Net Developer Guide :: 5.2 Creating a Connector/Net Connection String



MySQL :: MySQL 5.7 Reference Manual :: 14.2.1 CALL Syntax







Bringing Out the Best in Teams: Lessons from Special Ops - Knowledge@Wharton

Bringing Out the Best in Teams: Lessons from Special Ops - Knowledge@Wharton



Dr. Duckworth’s Grit Scale [a test developed by Angela Duckworth, a
professor of psychology at the University of Pennsylvania, which is
designed to identify the traits that could help to predict success].
When I first read through the questions in the Grit Scale, I was
thinking this is a fantastic measure of mental performance, what people
broadly call mental toughness. It’s a tough scale for us to put to use

Thursday, July 14, 2016

Intro to Natural Language Processing | Open Data Science

Intro to Natural Language Processing | Open Data Science



Natural Language Processing is one of Machine Learning's most intriguing
sub-fields. For those who want to wander its flora, there is some basic
terminology that must be understood.

EBSCO's holdings management tool streamlines library workflow for Waubonsee Community College

EBSCO's holdings management tool streamlines library workflow for Waubonsee Community College



library migrated from EBSCO’s previous generation link resolver and A-to-Z service to Full Text Finder, EBSCO’s new holdings and link management tool. Full Text Finder
includes a knowledge base, holdings management tools, a
state-of-the-art publication search service, and a fully functional link
resolver — all of which integrate with EBSCO Discovery Service
(EDS), a powerful library platform that allows users to search across a
majority of a library’s resources through a single search box.



According to Resource Sharing Specialist Kendall Vance, the process of managing custom collections in EBSCOadmin
is much more efficient. Vance simply goes to the Holdings Management
tab, types in the title name, gives it an ISSN, and adds it to the
collection.





“Adding a title to a custom collection is the biggest improvement,”
Vance said. “When we have a new title, I’m finding I can just go in and
add it as I go about my day.”





In addition, the Publication Finder feature, which allows users to
search for articles by journal title, has been particularly useful when a
student has a citation and needs to find out whether the library has
access to the full text.