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

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

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. DMV data is always available, so very often it's the easiest method to get a quick first look at query performance. total_worker_time / qs. ORDER BY qs.

C++ 74

C++ Database Servers Tuning 74

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

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 93

AWS Internet Internet Storage 93

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 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

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

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