Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

MAY 29, 2019

From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. FastLoadContext can be disabled on SQL Server 2016 using documented trace flag 692. DEFAULT ''. )

Cache 64

Cache Testing Servers Code 64

Scalegrid

AUGUST 15, 2019

In 2014, we discussed 4 of the top MongoDB GUIs: MongoVue, MongoHub, RockMongo, and Robo 3T (formerly Robomongo), and again in 2016: MongoDB Compass, Robo 3T, Studio 3T, and MongoBooster. It’s further enhanced by an in-place code editor which is also available in all three views. We left those at the end of this post for your review.

Database 40

Database Servers Monitoring Availability 40

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model.

Servers 47

Servers Database Testing Performance 47

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. Test data and versions. For my test, I need to choose: Aurora instance type and comparison. With faster disks (i.e. SSD) we can’t utilize the full potential of IOPS with just one thread.

Cache 45

Cache C++ AWS Airlines 45

SQL Server According to Bob

JANUARY 26, 2017

“Quick question about a behavior we’re seeing at a customer and in testing. Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest.

Servers 40

Servers Database Azure Cache 40

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. Thanks to the Web Platform Tests project and wpt.fyi , we have the makings of an answer for the first: Tests that fail only in a given browser. Count of APIs available from JavaScript by Web Confluence.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

JULY 13, 2016

Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. We actually launched this functionality for SQL Server 2016 Express Edition when SQL Server 2016 RTM was announced but didn’t really promote this.

Servers 40

Servers Media Engineering Virtualization 40

SQL Performance

MAY 16, 2019

If both sort and no-sort alternatives are available, the optimizer will make a cost-based choice. The following script should be run on a development SQL Server instance in a new test database set to use the SIMPLE or BULK_LOGGED recovery model. Test ; END ; GO. DMLRequestSort Conditions. DROP TABLE dbo. CREATE TABLE dbo.

Cache 67

Cache Servers Testing Storage 67

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. Microsoft SQL Server Database Engine Input/Output Requirements. Val and Dylan performing power outage durability testing and adding new tests. The Back Story. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Performance

APRIL 23, 2019

SQL Server 2016 introduced serial batch mode processing and aggregate pushdown. instructions are available. Still, when the plan generally qualifies for grouped aggregate pushdown, both pushdown (fast) and non-pushdown (slow) code paths are made available. You should not use it on anything except a personal test system.

Servers 67

Servers Testing Metrics Storage 67

Smashing Magazine

OCTOBER 26, 2018

It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more. on December 6th, 2016. I’m working on Varying Vagrant Vagrants , and have set up a test site with an URL [link].

Cache 78

Cache Website Speed Database 78

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. Leverage your SQL knowledge. But what is a table?

Architecture 80

Architecture Scalability Google Operating System 80

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This was extended to instance storage devices for the x1.32xlarge in 2016. The first was c3. Impressive!

Virtualization 111

Virtualization AWS Hardware Storage 111

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. It's a place filled with unit tests, automated integration tests, and code written using the "most latest" framework in town. And doing this is simple, especially if you're using an available library like NServiceBus or MassTransit.

Architecture 49

Architecture Database Code Systems 49

Alex Russell

MAY 9, 2022

Improving latency and reducing variance allows teams to test other product hypotheses with less noise. Even junior PM s internalise the notion that product quality is at risk if tests are not built, automated, and tracked. Reduced network and device capacity correlate with other access challenges. Protecting the Commons #.

Performance 86

Performance Latency Metrics Engineering 86

The Symphonia

DECEMBER 6, 2017

We plan to test this out when we get the chance. Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available. there’s no inline debugging available in the Lambda Console.) Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for.

Serverless 40

Serverless Lambda AWS Traffic 40

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This was extended to instance storage devices for the x1.32xlarge in 2016. The first was c3. Impressive!

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. The SQL Server ODBC driver is built for Windows and linked with the MSDTC libraries but the SQL Server JDBC implementation is not Windows specific and does not have the msdtcprx.dll or service available on the client. Transaction Monitor/Manager – Coordinator.

Servers 40

Servers Azure Engineering Java 40