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

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. 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). 64 equals 104.95

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. The code may be easier to read and understand than the recursive CTE.

Servers 86

Servers Tuning Database Efficiency 86

All Things Distributed

MAY 8, 2012

Werner Vogels weblog on building scalable and robust distributed systems. Using the AWS Toolkit for Visual Studio , you can now deploy your.NET applications to AWS Elastic Beanstalk directly from your Visual Studio environment without changing any code. All Things Distributed. Expanding the Cloud for Windows Developers. Comments ().

Cloud 115

Cloud Development AWS Servers 115

Randon ASCII

FEBRUARY 25, 2018

In this particular investigation, which spanned twenty months, we suspected hardware failure, compiler bugs, linker bugs, and other possibilities. Jumping too quickly to blaming hardware or build tools is a classic mistake, but in this case the mistake was that we weren’t thinking big enough.

Programming 79

Programming Hardware Cache Code 79

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

O'Reilly

SEPTEMBER 19, 2023

” Each step has been a twist on “what if we could write code to interact with a tamper-resistant ledger in real-time?” Doubly so as hardware improved, eating away at the lower end of Hadoop-worthy work. Mental contortions led to code contortions led to frustration. And, often, to giving up.

Hardware 99

Hardware Storage Big Data Blockchain 99