Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. Many open source proponents, including the Open Source Initiative (OSI) , do not consider software under the SSPL to be open source. We agree with the OSI’s determination that any software under the SSPL cannot be open source.

Open Source 81

Open Source Programming Database Servers 81

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy.

Availability 83

Availability Open Source Architecture Database 83

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB? Enhanced security is another advantage MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

DECEMBER 11, 2017

Current limitation: Engaging in a distributed transaction with SQL Server 2017 on Linux. SQL Server 2017 on Linux does not have distributed transaction support. However, SQL Server 2017 on Windows provides distributed transaction support allowing interactions with SQL Server 2019 on Linux. Try out this example.

Servers 40

Servers Database Software Engineering Engineering 40

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 128

Internet Internet AWS Performance 128

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. The reduction effort started when we shipped SQL Server 2017 ( [link].) Remove the background task and aggressively reclaim database space during query execution.

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Adaptive query processing in SQL databases – Bob Ward and Conor Cunningham.

Engineering 40

Engineering Azure Best Practices Servers 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Database architects working with MongoDB encounter specific challenges related to database systems and system growth.

Best Practices 71

Best Practices Traffic Database Servers 71

SQL Performance

JANUARY 23, 2020

Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. There is a single SQL Server database at the heart of every SentryOne monitoring environment, and this customer was monitoring around 600 servers with our software. Query Store 2017 to the Rescue.

Tuning 115

Tuning Servers Monitoring Hardware 115

The Netflix TechBlog

OCTOBER 19, 2020

By 2017, open source projects like Open-Tracing and Open-Zipkin were mature enough for use in polyglot runtime environments at Netflix. In 2019 our stunning colleagues in the Cloud Database Engineering (CDE) team benchmarked EBS performance for our use case and migrated existing clusters to use EBS Elastic volumes. What’s next?

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

All Things Distributed

JUNE 30, 2017

So much so, that in March 2017, we announced Amazon Connect, which is the result of nearly ten years of work to build cloud-based contact centers at scale to power customer service for more than 50 Amazon teams and subsidiaries, including Amazon.com, Zappos, and Audible.

Artificial Intelligence 128

Artificial Intelligence Lambda AWS Virtualization 128

SQL Server According to Bob

APRIL 24, 2018

I also started my career developing on UNIX systems with C++ and databases like Ingres. Last October we released SQL Server 2017 including support for Linux and Docker Containers. docker pull microsoft/mssql-server-linux:2017-latest. As I moved to other jobs, the PC was becoming very popular as was the Windows Operating System.

Servers 40

Servers Internet Internet Open Source 40

MachMetrics

DECEMBER 14, 2019

In 2017, mobile internet usage passed desktop as the majority. Obviously, the key phrase there is ‘fully loaded’ A lot of that time is behind the scenes scripts, tracking software, advertisements, etc. It is typically reduced via server-side optimizations, such as enabling caching and database indexes.

Best Practices 105

Best Practices Speed Mobile Google 105

ScaleOut Software

MAY 4, 2018

Traditional stream-processing and complex event processing systems, such as Apache Storm and Software AG’s Apama , have focused on extracting interesting patterns from incoming data with stateless applications. Michigan) in 2002 for use in product life cycle management, it was recently popularized for IoT by Gartner in a 2017 report.

Processing 40

Processing IoT Programming Software Engineering 40

Particular Software

MARCH 15, 2021

As popular as NoSQL databases have become, you’d be hard-pressed to find a successful business that isn’t running some flavor of SQL somewhere. Unfortunately, that name is not a legal identifier which meant the scripts would not work with SQL*Plus, which is one of the more popular tools used to automate scripts against an Oracle database.

Transportation 52

Transportation Azure Database Servers 52

ScaleOut Software

MAY 4, 2018

Traditional stream-processing and complex event processing systems, such as Apache Storm and Software AG’s Apama , have focused on extracting interesting patterns from incoming data with stateless applications. Michigan) in 2002 for use in product life cycle management, it was recently popularized for IoT by Gartner in a 2017 report.

Processing 40

Processing IoT Programming Software Engineering 40

O'Reilly Software

APRIL 4, 2018

Google was among the pioneers that created “web scale” architectures to analyze the massive data sets that resulted from “crawling” the web that gave birth to Apache Hadoop, MapReduce, and NoSQL databases. We usually relate SQL to querying tables in relational databases. Determine requirements first. Leverage your SQL knowledge.

Architecture 80

Architecture Scalability Google Operating System 80

SQL Server According to Bob

FEBRUARY 22, 2018

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. Conflict with existing data is unlikely but the new value may sort before those values stored in the database already. Bob Dorr – Principal Software Engineer SQL Server. secrets/instance_id file.

Servers 40

Servers Software Engineering Database Network 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed 40

Speed Java AWS Virtualization 40

Adrian Cockcroft

JANUARY 29, 2023

Bill Kaiser of NewRelic published this blog in 2017 which goes some way towards what I’m talking about, but since then I have figured out a new way to interpret the data. This applies to other areas like software project time estimates as well, there’s a tendency to focus on the best case but it always takes longer.

Lambda 98

Lambda Latency Cache C++ 98

Particular Software

AUGUST 8, 2017

The new persister supports multiple database engines and uses raw ADO.NET and native SQL queries, without the need for an intermediate ORM. Up until now, our primary method of persisting data in relational databases used NHibernate, which was making it impossible to realize those dreams. It's worth it.

DevOps 40

DevOps Database Education Engineering 40

SQL Performance

JULY 16, 2019

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. Older Intel processors are more vulnerable to these exploits, and they suffer more of a performance decrease from existing software and firmware-level fixes. There are many reasons!

Servers 46

Servers Hardware Architecture Retail 46

O'Reilly

MARCH 23, 2023

Maybe it’s surprising that ChatGPT can write software, maybe it isn’t; we’ve had over a year to get used to GitHub Copilot, which was based on an earlier version of GPT. What Software Are We Talking About? It isn’t hard to connect it to speech synthesis and speech-to-text software. It has helped to write a book. It’s much more.

Google 103

Google Open Source Programming Code 103

Enprowess

JANUARY 12, 2022

Twitter Lite PWA : It was integrated as the standard User Interface in 2017. Technology helps companies offer their software services to customers quickly, creating personalized experiences. Blockchain technology is an encrypted database storage system. Do you wish for a reliable custom software development companion?

Blockchain 59

Blockchain IoT Development Serverless 59

SQL Server According to Bob

DECEMBER 18, 2018

Assume the database application opens the backup file, allowing file system caching (~_O_DIRECT.) The sync was called by an application outside database application so the database application is unaware of the failure. · This issue does NOT impact SQL Server database, log and backup files.

Servers 40

Servers Media Cache Software Engineering 40

O'Reilly

JULY 25, 2023

I really wanted to go beyond these quick gut reactions that I’ve seen so much of online, so I tried using ChatGPT for a few weeks to help me implement a hobby software project and took notes on what I found interesting. or “ha look how incompetent it is … it couldn’t even get my simple question right!” using “22” for the year 2022).

Programming 98

Programming Code Design Benchmarking 98

KeyCDN

NOVEMBER 8, 2018

We also recommend using a free program like KeePass or KeePassX which allow you to generate secure passwords and store them in a database locally on your computer. Varonis) In 2017 there was a 13 percent overall increase in reported system vulnerabilities.

Transportation 47

Transportation Website Google Infrastructure 47

SQL Server According to Bob

JULY 17, 2018

systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 The simple answer is the first entry (85829) is not what you are used to on a Windows system as sqlservr.exe and does not listen for TDS traffic or open database files.

Servers 40

Servers Processing Software Engineering Traffic 40

Alex Russell

APRIL 29, 2021

WebGL 2 launched for other platforms on Chrome and Firefox in 2017. Provides safe access to USB devices from the web, enabling new classes of applications in the browser from education to software development and debugging. Some commenters appear to confuse unlike hardware for differences in software. Web Serial.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. This means there are no DTC components available for SQL Server 2017 on Linux. Microsoft specific implementation for DTC using (OLE-TX). X/Open Standard for TM to RM communications and behavior. Transaction Monitor/Manager – Coordinator. Microsoft MSDTC protocol.

Servers 40

Servers Azure Engineering Java 40

SQL Server According to Bob

DECEMBER 10, 2018

The internal, SQL Server, database allocation structures track SQL Server, data file allocations and valid data read activities. If database creation speed is a concern use Instant File Initialization and allow the first writes to encounter the additional overhead. Bob Dorr – Principal Software Engineer SQL Server.

Servers 40

Servers Speed Database Software Engineering 40

Smashing Magazine

JANUARY 7, 2019

Depending on how much dynamic data you have, you might be able to "outsource" some part of the content to a static site generator , pushing it to a CDN and serving a static version from it, thus avoiding database requests. An interesting way of avoiding parsing costs is to use binary templates that Ember has introduced in 2017.

Performance 104

Performance Cache Network Metrics 104