SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

All Things Distributed

NOVEMBER 28, 2012

By Werner Vogels on 28 November 2012 09:00 AM. Unlike traditional row-based relational databases, which store data for each row sequentially on disk, Amazon Redshift stores each column sequentially. This means that Redshift performs much less wasted IO than a row-based database because it doesnâ??t Expanding the Cloud â??

Cloud 164

Cloud Storage Architecture Scalability 164

All Things Distributed

OCTOBER 8, 2014

The original Dynamo paper inspired many database solutions, which are now popularly referred to as NoSQL databases. These databases trade off complex querying capabilities and consistency for scale and availability. In 2012, we launched Amazon DynamoDB, the successor to Amazon Dynamo.

Availability 145

Availability Performance Scalability AWS 145

All Things Distributed

DECEMBER 12, 2013

We launched DynamoDB last year to address the need for a cloud database that provides seamless scalability, irrespective of whether you are doing ten transactions or ten million transactions, while providing rock solid durability and availability. DynamoDB stores information as database tables, which are collections of individual items.

Games 130

Games Scalability Database Retail 130

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 SentryOne Plan Explorer / Query Tuning forum. or newer ( July announcement post ).NET NET Core Runtime 2.1

Azure 50

Azure Servers Tuning Operating System 50

All Things Distributed

APRIL 11, 2012

By Werner Vogels on 12 April 2012 12:00 AM. And increasingly, search is applied to data that, though called a "document" for the purposes of search, is really just a record in a database or an object in a NoSQL system. Amazon CloudSearch provides the ability to have customized ranking functions to fine tune the search results.

Cloud 149

Cloud AWS Technology Technology 149

SQL Performance

SEPTEMBER 2, 2021

UPDATE: September 2nd, 2021 (Originally published July 26th, 2012.). A lot of things change over the course of a few major versions of our favorite database platform. Here are the contenders I am going to compare (using SQL Server 2012, 11.00.2316, on a Windows 7 VM with 4 CPUs and 8 GB of RAM): CLR. CREATE FUNCTION dbo.

C++ 59

C++ Servers Testing Database 59

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.

Programming 98

Programming Code Design Benchmarking 98