I had the opportunity to participate to POUG day 1 and wanted through this blog to share some of my feedback on the interesting sessions I could follow. First of all, I would like to mention the great introduction done by the staff team and the great organization.
SQL Server 2017 was made generally available on Windows, Linux, and Docker on . Download the free Express / Eval / Developer editions. For Windows, the latest CU is always available here. If you're running on Linux, you can navigate through the 1991-esque packages.microsoft.
Galera is based on synchronous (or ‘virtually synchronous’) replication method, which ensures the data applied to other nodes before it is committed. Having the same data on all nodes means that node failures can be easily tolerated, and no data is lost.
There are many ideas and considerations behind graph databases. This includes their use cases, advantages, and the trends behind this database model. There are many ideas and considerations behind graph databases. This includes their use cases, advantages, and the trends behind this database model.
Binary Large OBject storage (BLOB) is a topic that comes up in almost every conversation about Oracle to PostgreSQL migration. I will discuss it here with enough detail to make architectural choices coming from the Oracle perspective. Ready? Ok, let’s continue.
Greetings! This is Eldin reporting from the Solutions Engineering team at Grafana Labs. In previous posts, you might have read about Grafana’s New 7 release or our introduction to Loki. In this week’s post, I am introducing Éamon, who will be covering our Grafana Cloud Agent. – Eldin
In this article, I am going to explain how we can refresh a SQL Database using the Maintenance plan. To demonstrate the process, I have configured two virtual machines. I have installed SQL Server 2016 on both.
In this article, we will introduce SQL queries hint and will analyze the OPTION(Fast ‘N’) hint in detail. Once the user submits any query to SQL Server, it creates an optimized and cost-effective execution plan depending upon the statistics, indexes, and data distribution.
You don’t have to choose between cost management and full observability. With Logz.io features Log Patterns, Drop Filters, and Archive & Restore add to cost efficiency. These features are designed to easily identify and filter out that data before indexing it, and then reingest that data if necessary later.
Fabric is a new feature introduced in Neo4j 4.0 and is a way to store and retrieve data in multiple databases. This feature makes it easy to query the data in the same DBMS or multiple DBMS using a single Cypher query. If you haven’t already, please download Neo4j Desktop.
We are working on an Integration Services project with multiple developers. Some team members work remotely, so it's not always easy to see which package someone is working on. We'd like to use a git repository as a source control repository. This way we can also manage the code using branches.
It’s been 20 years since MySQL Replication was introduced in MySQL 3.23.15 (Released in May 2000). Since then, virtually every MySQL Database deployment in production has been using Replication in order to achieve high availability, disaster recovery, read scale out and various other purposes.
Nicolas Hourcard Nicolas is a lifelong technology enthusiast and co-founder of QuestDB. He previously leveraged time-series data for companies like Rothschild and Nasdaq. He splits his time between London and San Francisco and enjoys tennis, skiing and climbing new mountain peaks each year.
What this means in practical terms is that a MySQL instance has reached its maximum allowable limit for client connections. Until connections are closed, no new connection will be accepted by the server.
Postman is one of the most popular REST API clients. Since v7.2, it also supports GraphQL APIs. In this blog post, we will look at how you can use Postman to make GraphQL requests. We will also look at some of the advantages of doing so.
With over 300 databases on the market, how do you determine which is right for your specific use case or skill set? We continue to see the common debate of SQL vs. NoSQL and other database comparisons all over social media and platforms like dev.to.
Most of the projects developed today rely on open source libraries - it is likely that your project does too. While using these libraries accelerates development by relying on proven solution for common needs, it also introduces a potential risk factor.
The 10.5 release of MariaDB Community Server which includes ColumnStore columnar storage engine is now available as an image on Docker hub. Columnar data storage is designed for analytics workloads with large data sets and ad hoc queries. With the MariaDB Community Server 10.