SQL Server According to Bob

JULY 12, 2016

For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes. Trace flag 2549 is used to change how DBCC sees the volume layout of the database. This is behavior is unchanged in SQL Server 2016.

Servers 40

Servers Design Engineering Database 40

All Things Distributed

APRIL 5, 2012

By Werner Vogels on 06 April 2012 06:00 AM. One of the services that is very successful in driving innovation at our customers in this context is Amazon RDS , the Relational Database Service. Troy: We moved our service from internal servers to AWS. Werner Vogels weblog on building scalable and robust distributed systems.

Innovation 146

Innovation AWS Education Network 146

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 212

Database Traffic Transportation Open Source 212

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database 197

Database Traffic Transportation Open Source 197

All Things Distributed

JANUARY 18, 2012

a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. By Werner Vogels on 18 January 2012 07:00 AM. Today is a very exciting day as we release Amazon DynamoDB , a fast, highly reliable and cost-effective NoSQL database service designed for internet scale applications. Amazon DynamoDB â??

Scalability 167

Scalability Database Ecommerce Latency 167

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Performance

MAY 20, 2022

The most important things to understand about server-side parameterization are it doesn’t happen all at once and a final decision to parameterize isn’t made until the end of the process. Decisions about parameterization at this early stage are generic and conservative because the only information available is the statement itself.

Cache 55

Cache Database Servers Testing 55

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

SQL Performance

JULY 11, 2019

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query.

Azure 90

Azure Servers Tuning Operating System 90

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. When it comes to backups, there are multiple types available, each with its own advantages and limitations. A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database.

Storage 68

Storage Strategy Network Efficiency 68

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 Performance

AUGUST 15, 2019

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query.

Azure 50

Azure Servers Tuning Operating System 50

All Things Distributed

FEBRUARY 18, 2013

When a new app server instance starts, OpsWorks will use built-in recipes to configure the app server software and deploy your apps, and can also apply your specified recipes to make changes to your database and monitoring infrastructure. Operational Control â?? Automate tasks. AWS Application Management Solutions. Contact Info.

AWS 157

AWS Cloud Architecture Infrastructure 157

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 because most of our workloads are CPU and memory bound, which were already virtualized in hardware.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. instructions are available. Introduction.

Servers 67

Servers Testing Metrics Storage 67

Smashing Magazine

APRIL 1, 2020

We need a new breed of CMS — one that can make content available through any channel at which point a Headless CMS is required. The API makes contents available through any channel and on any device using most favorite tools and programming languages plus it also provides a higher level of security and much better scalability.

Open Source 103

Open Source Website Mobile Code 103

O'Reilly

JULY 25, 2023

To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022. This choice also inspired me to call my project Swift Papers. But still, I liked how Moment.js

Programming 98

Programming Code Design Benchmarking 98

Alex Russell

MARCH 6, 2021

The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. Modern network performance and availability. low-end Androids have finally caught up to the iPhone 5 from 2012. twitter.com/slightlylate/status/1139684093602349056 455 06:18 AM · Feb 28, 2020. Here begins our 2021 adventure. Hard Reset.

Performance 124

Performance Network Cache Metrics 124

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 because most of our workloads are CPU and memory bound, which were already virtualized in hardware.

Virtualization 40

Virtualization AWS Hardware Storage 40

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.

Database 40

Database Analytics Blockchain Healthcare 40