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 115

Cloud Development AWS Servers 115

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

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 146

Innovation AWS Education Network 146

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

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

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. It will also use less power than a two-socket Intel server, with a lower hardware cost, and potentially lower licensing costs (for things like VMware). This system has one AMD EPYC 7502P 32-core processor and 512GB of RAM. The price per QphH for this system is 0.34 I/O lanes.

Servers 52

Servers Benchmarking Virtualization Architecture 52