Databases Resources

SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations

SQL Server has made available in recent versions automatic tuning! Interested to find out how it can benefit your project? Read on to find out!

December 29, 2017

by Grant Fritchey

· 7,154 Views · 4 Likes

Securing Your Inline SQL Statements From SQL Injection

Shifting security left, and using secure coding standards, is becoming more and more important. Read on to get a great introduction to this topic!

December 29, 2017

by Jennifer Marsh

· 9,383 Views · 3 Likes

In-Memory Technologies: Meeting Healthcare's Fast Data Challenges (Part 2)

Learn about a healthcare case study from a company called e-Therapeutics, which specializes in drug discovery and development, and see how they used Apache Ignite.

December 28, 2017

by Akmal Chaudhri

CORE

· 6,169 Views · 2 Likes

Load Testing WebDAV Servers

In this post, we'll give a tutorial that covers how to load test the unique abilities of the WebDAV server that are working on.

December 27, 2017

by George Maksimenko

· 9,330 Views · 1 Like

Creating a Simple Web App With Java 8, Spring Boot, and Angular

In this tutorial, we'll look at how developers can combine multiple technologies to make a web application. Read on to get started!

Updated December 27, 2017

by Ashish Lohia

CORE

· 393,421 Views · 39 Likes

15 Software Development Influencers You Should Follow in 2018

From Agile advocates and engineering experts, to growth gurus and Scrum specialists, this is a Who's Who guide for development in 2018.

December 27, 2017

by Ekaterina Novoseltseva

CORE

· 19,488 Views · 15 Likes

Achieving 10M Ops/Sec at 1ms Latency With Only 6 EC2 Nodes

With the OSS Cluster API, Redis Enterprise 5.0 can easily scale linearly by just adding shards to the database and nodes to the cluster — as proven by this benchmark.

December 27, 2017

by David Maier

· 8,107 Views · 5 Likes

Connecting a PostgreSQL Database With Apache Camel

The jdbc: and sql: components in Apache Camel are similar, but vastly different. Let's see how you can use them to connect to a Postgres database.

December 26, 2017

by Jitendra Bafna

CORE

· 29,515 Views · 9 Likes

Migration of Legacy DB/File Structure to RDBMS

Migration is difficult, but sometimes, it's required — like if you want to improve your database's performance or utilize features of the target RDBMS that are missing in the source.

December 25, 2017

by Krishna Anumarlapudi

· 9,251 Views · 8 Likes

API Test Parameterization With Spock

In this blog post, a performance testing expert will cover the different ways one can parameterize Groovy tests in Spock.

Updated December 25, 2017

by Grigor Avagyan

· 8,378 Views · 2 Likes

Optimizing AWS EBS Using LVM

Linux's Logical Volume Manager is an older tool, but it can still be useful today. See how you can use it to help right-size your EBS usage and save money.

December 24, 2017

by Jack Huang

· 12,580 Views · 6 Likes

Query Store Wait Statistics With sys.query_store_wait_stats

I absolutely love Query Store. But it's easy to get your data all jumbled up when sys.query_store_wait_stats comes into the mix.

December 24, 2017

by Grant Fritchey

· 5,612 Views · 2 Likes

Understanding Server-Sent Events (SSE) as Part of the API Landscape

Server-sent events can be a positive boon for any web application. In this post, we take a look at how SSEs fit into the world of APIs.

December 23, 2017

by Kin Lane

· 13,527 Views · 3 Likes

Installing the ELK Stack on AWS: A Step-by-Step Guide

Want to bring in the ELK stack for your AWS logging and monitoring needs? This guide will get you set up with the open source solution.

December 22, 2017

by Asaf Yigal

· 43,417 Views · 8 Likes

Custom Error Handling Framework for an Enterprise Using MuleSoft

Learn how to make that Mule gallop like a horse by creating your own custom exception handling framework for your MuleSoft app.

December 22, 2017

by Rakesh Kumar Jha

· 12,679 Views · 4 Likes

Too Many PreparedStatement Placeholders in Oracle JDBC

In this post, we discuss a particular error related to JDBC making calls out to an Oracle database. Read on for the details.

December 22, 2017

by Dustin Marx

· 17,615 Views · 2 Likes

A Guide for Customer Retention Analysis With SQL

See how to make basic customer retention analysis, build customer retention over time, deal with new vs. existing customers retention curves, and calculate retention analysis in cohorts.

December 22, 2017

by Luba Belokon

· 27,327 Views · 4 Likes

The Evolution of EC2 Network Performance: m3, m4, and m5

So, are AWS EC2's fancy new m5 instances worth it? In a word: yes. See the performance impact and cost savings you can expect.

December 21, 2017

by Andreas Wittig

· 12,054 Views · 4 Likes

Data Visualizations With InfluxDB and Plotly.js

Walk through creating data visualizations with InfluxDB and plotly.js, a JavaScript graphing library built on top of d3.js and stack.gl.

December 20, 2017

by Margo Schaedel

· 14,008 Views · 3 Likes

Implicit vs. Explicit Cursor: Which Should You Use?

"Hmmm," you might be saying to yourself, "a conversation about SQL queries in a post on conditional logic? That's strange." Ah, but maybe not so strange.

December 20, 2017

by Steven Feuerstein

· 7,773 Views · 2 Likes

The Latest Databases Topics