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 WarehousingAnalyzing 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 …
CryptocurrencyCreating 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 ServerEarmuffs | 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 ComputingIntroduction 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” …
JavaScriptdbplyr 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 ScienceReplace 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 …
AristotleChallenges 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 …
MySQLAmazon 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 ServersAWS 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 ServerIntroducing 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 …
DexterSaving 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 ComputingIDENTITY 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 DataMorrison '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 & UniversityHow 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> …
MariaDBJeddict
Visualize architecture<p>Jeddict helps you visualize and design application architecture for rapid change, continuous improvement, sustainability and …
ProgrammingHow 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 IndustryStructured 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 …
ProgrammingTop 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 …
PostgreSQLAn 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 ServerDitch 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 ExcelHackolade 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 IndustryExpectations 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 Warehousing10 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 ComputingSQL 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 ScienceUnderstanding 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