All Things Distributed

JUNE 20, 2017

In 2008, AWS opened a point of presence (PoP) in Hong Kong to enable customers to serve content to their end users with low latency. Beyond running their web properties and applications, Next Digital also uses Amazon RDS (database), Amazon ElastiCache (caching), and Amazon Redshift (data warehousing).

AWS 149

AWS Logistics Cloud Social Media 149

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

SQL Performance

SEPTEMBER 6, 2022

Let’s look at some examples using a fresh database. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists.

Database 98

Database Storage Testing Servers 98

All Things Distributed

MAY 8, 2012

Werner Vogels weblog on building scalable and robust distributed systems. You can then off load the management and scaling of your database and application stack to Amazon RDS and AWS Elastic Beanstalk , and focus on adding value to your customers. All Things Distributed. Expanding the Cloud for Windows Developers. Comments ().

Cloud 116

Cloud Development AWS Servers 116

SQL Performance

MARCH 17, 2020

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Cost" column shows the optimizer's cost estimate for each query as reported on the test system. BountyAmount.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. This system has one AMD EPYC 7502P 32-core processor and 512GB of RAM. The price per QphH for this system is 0.34 That is a higher score, but this system used two Intel Xeon Platinum 8180 28-core processors (that had a total of 56C/112T) and 512GB of RAM. In this case, 6,716.88/64

Servers 52

Servers Benchmarking Virtualization Architecture 52

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. I always check backups first when looking at a new system. When looking at backups, I check for recovery model and the current history of backups for each database. DBCC CHECKDB.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

OCTOBER 29, 2019

In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it. [ dbid ] ) AS [ Database Name ] , REPLACE ( REPLACE ( LEFT ( t. [ SELECT TOP ( 50 ) DB_NAME ( t. [

C++ 74

C++ Database Servers Tuning 74

All Things Distributed

APRIL 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. One of the services that is very successful in driving innovation at our customers in this context is Amazon RDS , the Relational Database Service. All Things Distributed. Customer Conversations - How Intuit and Edmodo Innovate using Amazon RDS. Comments ().

Innovation 149

Innovation AWS Education Network 149

All Things Distributed

MARCH 24, 2011

Werner Vogels weblog on building scalable and robust distributed systems. The images from the 2008 TNW Conference have travelled around the world in my Animoto demo: This year TNW is showing that it is not just a conference for talkers but also for builders by organizing a massive Hackaton in the two days running up to the conference.

AWS 96

AWS Internet Internet Storage 96

SQL Server According to Bob

JANUARY 26, 2017

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. That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 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. You might be asking why you should care about all of this as a SQL Server Database professional? Figure 2: AMD EPYC Rome Processor. How is This Relevant for SQL Server? There are many reasons!

Servers 46

Servers Hardware Architecture Retail 46

O'Reilly Software

OCTOBER 23, 2018

Technology systems are difficult to wrangle. Our systems grow in accidental complexity and complication over time. The product management team states what must be done to solve the problem, and the architect describes how to realize that vision in a system. To do so, we borrow metaphors from roles in other industries.

Strategy 100

Strategy Architecture Technology Technology 100

The Agile Manager

FEBRUARY 28, 2017

There are people behind the systems to which we're bound today. Ten years ago, I was leading an inception for a company replacing their fleet maintenance systems. More modestly, we can simply license technology to replace major portions of legacy systems, and train or hire experts in that technology.

Strategy 40

Strategy Java Code Systems 40

Highly Scalable

MARCH 10, 2015

Most of this article represents an overview of the results published by retailers and researchers who built practical decision making and optimization systems combining abstract economic models with data mining methods. The most typical use cases for this problem are recommender systems, personalized search results ranking, and targeted ads.

Retail 152

Retail C++ Analytics Metrics 152

O'Reilly

JULY 25, 2023

And if I switch tabs to view a paper from 2008, then a song from 2008 could start up. 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.

Programming 98

Programming Code Design Benchmarking 98

SQL Server According to Bob

JANUARY 11, 2020

​​​​ Note:​​ The BID/SNI ​​ Trace for the ​​ SQL Server (SQL 2008’ish ​​ days) used to require ETW setup and a restart of SQL Server. ​​ ​​ Start by ​​ determining ​​ what is registered on your system.

Network 40

Network Servers Processing Software Engineering 40

All Things Distributed

APRIL 19, 2010

Werner Vogels weblog on building scalable and robust distributed systems. Here are the laurels given by the editors: Debuting in November 2008, Amazons entry into the CDN market quickly became a major player. a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. All Things Distributed.

Media 61

Media AWS Storage Big Data 61