Pat Hopple

23 Flips | 3 Magazines | 74 Likes | 4 Following | 3 Followers | @plh139 | Keep up with Pat Hopple on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Pat Hopple”

MySQL 5.7 multi-source replication – automatically combining data from multiple databases into one

MySQL’s multi-source replication allows you to replicate data from multiple databases into one database in parallel (at the same time). This post …

Learn SQL In 20 Minutes

Every web developer should know SQL. Although it has been around since the 70s, it is still widely used, and you can’t build a serious application …

NOSQL Databases

NoSQL DEFINITION:<p>Next Generation Databases mostly addressing some of the points: being <b>non-relational, distributed, open-source</b> and <b>horizontally</b> …

PostgreSQL advances in the JSON datastore landscape

JSON based datastores have been gaining popularity in the past years. Following on the increasing popularity of MongoDB, CouchDB, RethinkDB, ToroDB …

The Hype Around Graph Databases And Why It Matters

Organizations are struggling with a fundamental challenge – there’s far more data than they can handle. Sure, there’s a shared vision to analyze structured and unstructured data in support of better decision making but is this a reality for most companies? The big data tidal wave is transforming …

Databases

Connecting Asia's startup ecosystem

Quick CSV import: Import CSV data into a MySQL database table

This class can be used to import data from CSV (Comma Separated Value) files into a given MySQL database table.<p>It parses a given CSV file to extract …

Databases

How does a relational database work

When it comes to relational databases, I can’t help thinking that something is missing. They’re used everywhere. There are many different databases: …

Databases

A road map to become a Data Scientist

I receive a lot of questions regarding which books one should read to become a Data Miner/Data Scientist. Here is a suggested reading list, and also …

How to Backup/Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’ and ‘Autopostgresqlbackup’ Tools

If you are a database administrator (DBA) or are responsible for maintaining, backing up, and restoring databases, you know you can’t afford to lose …

Introduction to SQL Server’s Mathematical Functions

Math Rocks!<p>SQLServer includes many mathematical functions you can use to perform business and engineering calculations. Many of these aren’t used in …

Seven SQL Server Data Types you Must Know

In SQL the columns of a table are defined to store a specific kind of value such as numbers, dates, or text; these are called data types. With over …

JSON in SQL Server 2016: Part 1 of 4

JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers …

Databases

How to read data from an Excel file starting from the nth row with SQL Server Integration Services

Problem<p>I have Excel files I need to read using SQL Server Integration Services (SSIS), but the first few rows in the file are just information about …

The 10 Pasta Recipes to Know

It's easy to look to pasta as that happy weeknight cure-all: the palette on which to throw any bits and bobs, to dress with the random things hanging out in the pantry, to just top with cheese and call it dinner. But there are some classic pasta dishes -- or just really delicious ones -- that we …

Adventures of an amateur baker

These simple Brown Butter Strawberry Muffins have such wonderful flavor. They make a great grab-and-go breakfast or a sweet snack. Muffins are one …

Invention - Responsive HTML5 Template

<b>Invention is awesome and creative responsive HTML5 template created for corporate, portfolio and business websites. It is a very simple, clean and</b> …

幸运快乐8 幸运快乐8平台 幸运快乐8开奖 - 幸运快乐8官网

Type & Grids: Free Responsive HTML5 Template

Instructions<p>Download and open the ZIP file.<br>• Edit the only HTML file, index.html, to add your own content.<br>• Mix and match the included type and color CSS …