Databases

Forget about Big Data. Think Smart Data.

Do you remember back in 1999 when everyone was talking about the Y2K systems crash that was going to take place when the clocks turned midnight on …

Data Warehousing

Analyzing Ethereum, Bitcoin, and 1200+ other Cryptocurrencies using PostgreSQL

<i>Cryptocurrencies are fueling a modern day gold rush. Can data help us better understand this evolving market?</i><p>Lately it seems like money has been …

Cryptocurrency

Creating enterprise grade BI models with Azure Analysis Services

In April we announced the general availability of Azure Analysis Services, which evolved from the proven analytics engine in Microsoft SQL Server …

Microsoft SQL Server

Earmuffs | PPE | 3M Worker Health & Safety

3M™ PELTOR™ Earmuffs X Series<p>Applied to moderate-to-high industrial noises, lightweight 3M™ X Series Earmuffs are the perfect match. With a designed …

The Limits of the CAP Theorem

The CAP theorem is a fundamental part of the theory of distributed systems. It states that in the presence of partitions (i.e. network failures), a …

Amazon DynamoDB Accelerator (DAX): A Read-Through/Write-Through Cache for DynamoDB | Amazon Web Services

<i>Joseph Idziorek is a product manager at Amazon Web Services.</i><p>AWS recently launched Amazon DynamoDB Accelerator (DAX), a highly available, in-memory …

Cloud Computing

Introduction to Redis + Node.js – Diogo Santos – Medium

Introduction to Redis + Node.js<p>Redis is used as a database and for cache since it’s super fast due to the fact that the data is stored “in-memory” …

JavaScript

dbplyr 1.1.0

(This article was first published on <b>RStudio Blog</b>, and kindly contributed to R-bloggers)<p>I’m pleased to announce the release of the dbplyr package, …

Data Science

Replace Bad Characters in Table

If you have a table of data that possibly contains characters that you don't want this script will remove the invalid characters.<p>You've probably seen …

Aristotle

Challenges of Sharding MySQL

MySQL databases are sharded for the best of reasons. At some point, the MySQL workload needs to scale, and scaling RDBMSs is hard (Clustrix’s …

MySQL

Amazon Web Services, Inc.

Enterprises are quickly moving database workloads like SQL Server to the cloud, but with so many options, the best approach isn’t always obvious. You …

SQL Servers

AWS Named as a Leader in The Forrester Wave: Database-as-a-Service Q2 2017 | AWS Database Blog

<i>Larry Weber and Yoav Eilat are product marketing managers at Amazon Web Services.</i><p>On April 24, Forrester published The Forrester Wave: …

Microsoft SQL Server

Introducing Dexter, the Automatic Indexer for Postgres

Your database knows which queries are running. It also has a pretty good idea of which index is best for a given query. And since indexes don’t …

Dexter

Saving Data from a DB Cluster into Text Files in an Amazon S3 Bucket - Amazon Relational Database Service

Saving Data from a DB Cluster into Text Files in an Amazon S3 Bucket<p>You can use the SELECT INTO OUTFILE S3 statement to query data from an Amazon …

Cloud Computing

IDENTITY now supported in Azure SQL Data Warehouse

Azure SQL Data Warehouse now supports the IDENTITY property for the creation of surrogate keys.<p>IDENTITY is supported in the following …

Big Data

Morrison 'Felt Something Special' at UNC

Before hitting the field for Fedora's Freak Show, Trey Morrison pledged to North Carolina. He broke down his decision with Inside Carolina...

College & University

How to Install LEMP (Linux, Nginx, MariaDB, PHP-FPM) on Debian 9 Stretch

Since Debian powers a large percentage of web servers all over the world, in this article we will explain how to install the <b>LEMP</b> (<b>Linux</b> + <b>Nginx</b> +</b> …

MariaDB

Jeddict

Visualize architecture<p>Jeddict helps you visualize and design application architecture for rapid change, continuous improvement, sustainability and …

Programming

How to create Outlook appointments from Excel data

Learn how to quickly import Excel data into Outlook appointments after converting the data into a comma-delimited file.<p>It's not unusual to receive an …

Tech Industry

Structured Streaming + Kafka Integration Guide (Kafka broker version 0.10.0 or higher)

Structured Streaming integration for Kafka 0.10 to poll data from Kafka.<p>Linking<p>For Scala/Java applications using SBT/Maven project definitions, link …

Programming

Top 5: Getting started with Python, Ansible to manage PostgreSQL, and more

In this week's Top 5, we highlight machine learning, games, DevOps, and more!Top 5 articles of the week5. Using open source tools to play Dungeons …

PostgreSQL

An Easy Guide to Creating Databases and Tables in SQL

Are you ready to begin creating databases and tables with the Structured Query Language? In this article, we explore the process of creating tables …

Microsoft SQL Server

Ditch Your Spreadsheet for a Database to Access the Power of your Data

Databases offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar …

Microsoft Excel

Hackolade CEO: Schema modeling in a schema-less world - CW Developer Network

<i>This is a guest post for the Computer Weekly Developer Network written by Pascal Desmarets in his capacity as founder and CEO of Hackolade — the</i> …

Tech Industry

Expectations V Reality, week two with Corsair’s Analytics.

My First Hand Account — Week 2<p>Working with live data and C-Level executives can be, at times, both exciting and overwhelmingly complicated. You learn …

Data Warehousing

10 Best Practices for Amazon Redshift Spectrum | AWS Big Data Blog

Amazon Redshift Spectrum enables you to run Amazon Redshift SQL queries against data that is stored in Amazon S3. With Amazon Redshift Spectrum, you …

Cloud Computing

SQL FAQ - Get Answers to Common Structured Query Language Questions

Looking for advice on using the Structured Query Language? This Databases SQL FAQ provides answers to the most frequently asked questions about SQL …

Data Science

Understanding How SQL Databases work

Each column can only contain one type of data which we must define. An example of what this means is; in our age column we use a number. We could not …

An Easy Guide to Using Databases in Excel 2003

01<p>of 09<p>Excel 2003 Database Overview<p>At times, we need to keep track of information and a good place to this is in an Excel database file. Whether it …

MacOSX Recents Plugin

This is the 8th plugin that has been submitted for the OSDFCon plugin competition. This plugin has been in the works for a while. I have had it …

SQLite