SQL provides a date type that developers can use to store date values. Also, to make working with dates easier, SQL has several date functions for retrieving, formatting, and manipulating dates. In this post, you’ll learn about some SQL date functions and how to use them.

In this series of blog posts, we speak with database professionals from Financial Services organizations around the world to better understand how DevOps is shaping the sector. On the way, we dig into key current factors including the rise of technology upstarts in fintech and insurtech, the speed of digital transformation and the ever-increasing threat of cyberattacks.

The next major release of VMware GemFire is now available! GemFire is a high-speed in-memory database for low-latency applications. Focused on resiliency and consistency, GemFire makes it easy to scale your data and support business-critical applications, whether they are on-premises, in the cloud, or somewhere in between. GemFire 10* was pre-announced at the SpringOne Essentials conference in January and later released as a public beta.

MySQL is an open-source relational database management system that operates based on the client-server model by using SQL as its mode of communication. It is the second most popular database in the world owing to its flexible and scalable nature, high security, ease of use, and ability to handle large data sets seamlessly. Due to its wide range of functionalities, MySQL is employed as part of the database management system for several high-profile companies such as Facebook, PayPal, and Twitter.

A constant challenge for many development teams is how to include test data management in the development process. Testing with consistent, realistic and compliant datasets, and bringing the database into CI and DevOps pipelines, has been shown to catch data-related issues long before they reach customers. The result: an increase in efficiency, a reduction in costs, and an improvement in the quality of software releases, enabling value to be released to customers faster.

A database is one of the most critical components for almost every application. Making sure it is running with the expected read and write latencies is paramount. This can be the difference between a smooth, pleasing user experience and a slow, error-filled one that makes your customers turn their back on a product — and never come back.

Apache Cassandra is a highly scalable, open source NoSQL database system designed to handle large amounts of data across multiple commodity servers with no single point of failure. Apache Cassandra can be run as a single node but starts making sense when its run in a cluster setup. The system is optimized for high write throughput and is known for its ability to handle big data workloads with ease at super-low latencies.