SQL Server According to Bob

JUNE 3, 2016

My development collogues and I are starting a regular blog series, outlining the vast range of scalability improvements, allowing SQL Server 2016 to run across a wide array of hardware configurations, faster and better than previous releases of SQL Server. Try SQL Server 2016 Today.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

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

The Agile Manager

APRIL 30, 2020

Both the financial and real economies have suffered quite a few shocks in the last 20 years: the dot-com bubble bursting (2000); September 11 (2001); the Great Recession (2008); and today in 2020 the COVID-19 crisis is wreaking economic havoc. It was much different in 2008.

Social Media 52

Social Media Innovation Internet Internet 52

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

Brendan Gregg

JULY 4, 2021

This was a chance to talk about other things I've been working on, such as the present and future of hardware performance. The video is on [youtube]: The slides are [here] or as a [PDF]: first prev next last / permalink/zoom I work on many areas of performance, but recently I've had a lot of demand to talk about BPF.

Performance 52

Performance Latency Hardware Storage 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 serial aggregate push down result of 13ms is equally impressive.

Servers 86

Servers Tuning Database Efficiency 86

The Agile Manager

MAY 31, 2020

By way of example, nations have low tolerance to bank failures because the panic that results from them has knock-on effects in the financial and real economies alike (as exemplified by Lehman in September, 2008). From a certain point of view, a lot of banks were nationalized by governments in the wake of the 2008 financial crisis.

Airlines 52

Airlines Government Hardware Technology 52

The Agile Manager

MARCH 18, 2013

Soon after the financial crisis began in 2008, companies shifted attention from finance to operations. A reduction in business investment is not particularly good news for tech firms selling hardware, software or services to companies. The crisis also ushered in a period of tepid growth undermined by persistent economic uncertainty.

Engineering 40

Engineering Innovation Government Hardware 40

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. Where this really can make a difference is in cloud implementations where you are paying for more than just compute and storage resources.

Servers 55

Servers Azure Hardware Network 55

SQL Performance

AUGUST 27, 2019

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). A one-socket AMD EPYC 7002 Series server can have up to 64 physical cores, 4TB of DDR4-3200 RAM, and 128 PCIe 4.0 AMD is not going to stand still and wait for Intel to catch up.

Servers 52

Servers Benchmarking Virtualization Architecture 52

The Agile Manager

JANUARY 10, 2011

Tech, and especially tech services, went counter-cyclical a few months into the last recession (2008). There's been a sea-change in the technology sector, from counter-cyclical to pro-cyclical. Companies entered the downturn with record levels of cash. With so much uncertainty, most firms didn't bet on expansion.

Hardware 40

Hardware Internet Internet Mobile 40

SQL Performance

JUNE 21, 2019

While hardware such as intelligent SANs, Solid State Disk, and other advancements have helped speed things up, wasted space in index can translate to wasted space in the buffer pool as well as wasting more I/O. If you have big physical hardware with defaults, then you should look at optimizing MAXDOP.

Servers 49

Servers Azure Hardware Database 49

Tim Kadlec

JULY 31, 2013

When he first gave the presentation in 2008, he was working at this massive company called Yahoo! That was 2008. So many blog posts, online publications, and presentations continually challenged me to move forward by presenting new techniques and ways of thinking about the technology I used on a daily basis. Here at Yahoo!,

Google 40

Google Website Availability Games 40

Brendan Gregg

SEPTEMBER 5, 2017

Nowadays, there are three built-in tracers that you should know about: - **ftrace**: since 2008, this serves many tracing needs, and has been enhanced recently with hist triggers for custom histograms. It's fast, but limited in places, and usually only suited as a single-user tool (there are workarounds).

Virtualization 75

Virtualization AWS Engineering Hardware 75

Brendan Gregg

FEBRUARY 28, 2023

References I've reproduced the references from my SREcon22 keynote below, so you can click on links: [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] , Jul 2008 [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] , 2010 [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

Performance 52

Performance Latency Cache Virtualization 52

Tech News Gather

NOVEMBER 5, 2023

Basics of Bitcoin and the Blockchain Technology Historical Evolution and the Rise of Bitcoin: Bitcoin, introduced in 2008 by the pseudonymous Satoshi Nakamoto, revolutionized the world of finance. However, the actual energy consumption varies based on the mining hardware and energy sources used.

Government 52

Government Blockchain Energy Innovation 52