Tech News Gather

NOVEMBER 22, 2022

The application world began to move forward after Google announced Kotlin as the new programming language for Android Apps at the 2017 I/O conference. Programmers are shifting to the more result-oriented and user-friendly Kotlin programming language due to its high compatibility with Java and Objective C and its excellent tooling support.

Development 52

Development Java Programming Google 52

SQL Performance

FEBRUARY 12, 2020

According to the standard, you would use the following code with the DISTINCT predicate to handle this need: SELECT orderid , shippeddate FROM Sales. According to the standard, you would use the following code to handle such a join: SELECT T1. Here's the complete solution code: WITH C AS. ( INNER JOIN dbo.

C++ 120

C++ Code Servers Database 120

SQL Performance

OCTOBER 9, 2019

Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. As an exercise, try solving this task with a pre-SQL Server 2017 compatible solution where you cannot use TRIM and TRANSLATE.

C++ 111

C++ Database Servers Code 111

Brendan Gregg

SEPTEMBER 5, 2017

It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). Hit Ctrl-C to end. ^C

Virtualization 76

Virtualization AWS Engineering Hardware 76

O'Reilly

FEBRUARY 18, 2020

Up until 2017, the ML+AI topic had been amongst the fastest growing topics on the platform. After several years of steady climbing—and after outstripping Java in 2017—Python-related interactions now comprise almost 10% of all usage. Not necessarily: Java-related searches increased by 5% between 2017 and 2018. Coincidence?

Software Architecture 132

Software Architecture DevOps Data Engineering Architecture 132

SQL Performance

OCTOBER 14, 2020

Then, you will probably want to continue reading this section and test the code that I use as I revisit key unnesting examples that I previously demonstrated with derived tables and convert them to use CTEs. Here’s the attempted solution using a CTE: WITH C AS. ( You won’t miss anything important that you haven’t read before.

C++ 52

C++ Servers Code Efficiency 52

SQL Performance

DECEMBER 11, 2019

Like them or not, as a database practitioner you often have to deal with them, and given that NULLs do add complexity to your SQL code writing, it's a good idea to make it a priority to understand them well. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. This way you can avoid unnecessary bugs and pitfalls.

Best Practices 117

Best Practices C++ Database Code 117

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at [Kernel Recipes] in 2017 and have shared the full story here. ## 1. Next Steps I'd usually SSH to instances for deeper analysis, where I could use mpstat(1) to confirm the usr/sys breakdown and perf(1) to begin profiling on-CPU kernel code paths. I worked on this code back at Sun.

Cache 145

Cache Cloud Java Tuning 145

Brendan Gregg

SEPTEMBER 25, 2021

The broken Java stacks turned out to be beneficial: They helped group together the os::javaTimeMillis() calls which otherwise might have have been scattered on top of different Java code paths, appearing as thin stacks everywhere. Without NMI, some kernel code paths (interrupts disabled) can't be profiled. But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

The Morning Paper

SEPTEMBER 20, 2020

For example, think of the classic diamond pattern where A depends on B and C, and B and C both in turn depend on D, but there is no version of D that satisfies the constraints of both B and C. Adding a direct dependency to pin a version, even when it’s not truly a direct dependency of the project (another code smell!).

Monitoring 137

Monitoring Java C++ Strategy 137

SQL Performance

MAY 13, 2020

I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well. However, from relational theory's standpoint, there's a deeper meaning to what C represents. C is what's known as a range variable.

C++ 143

C++ Code Design Servers 143

Adrian Cockcroft

JANUARY 29, 2023

Bill Kaiser of NewRelic published this blog in 2017 which goes some way towards what I’m talking about, but since then I have figured out a new way to interpret the data. The code is written using the R statistics language and I downloaded a free copy of RStudio to run the examples below. >

Lambda 98

Lambda Latency Cache C++ 98

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. The worklogs are where the design for future releases happens, and these are opened up when their features are fully developed and source-code-pushed. 3 GA 23 May 2017 10.2.6 In-development for MySQL 8.0 (now In-development for MySQL 8.0 (now

Open Source 52

Open Source Servers Storage Scalability 52

The Netflix TechBlog

JULY 1, 2019

In a previous post , we described how our TV application consists of a C++ SDK installed natively on the device, an updatable JavaScript user interface (UI) layer, and a custom rendering layer known as Gibbon. a similar situation to the pre-2000 world before browsers auto-updated and developers had to code to specific browser versions.

Cache 166

Cache Design Testing Development 166

SQL Server According to Bob

MAY 19, 2019

As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. The reduction effort started when we shipped SQL Server 2017 ( [link].) There are a bunch of folks with compiler, linker, SQL Server code, testing and other disciplines who provided input. SQL Server 2017.

IoT 61

IoT Servers Development Cache 61

SQL Performance

SEPTEMBER 5, 2019

CREATE CLUSTERED COLUMNSTORE INDEX c ON #T WITH ( MAXDOP = 1 ) ; Run the following test queries against the new columnstore table: SELECT. c = COUNT_BIG ( * ) FROM #T AS T WHERE 1 = ( SELECT 1 ) -- Avoid trivial plan. You can skip the WHERE clauses if you are running SQL Server 2017. c1 = @Start + N.

Performance 81

Performance C++ Storage Servers 81

Enprowess

NOVEMBER 2, 2021

Code Maintainability. Bloomberg – Efficient, simple-to-access, personalized content for end-users with automatic code refreshing options. Its first release was in May 2017 and was rarely used by developers, but it continues its speedy growth and becomes more and more popular in the developer community. Performance comparison.

Development 52

Development Social Media Mobile Code 52

SQL Performance

MAY 1, 2020

availability_databases_cluster AS c ON s. group_id = c. You could also not be lazy like me, and run the code in Powershell instead of a CMS query window, where you could easily filter out databases given any number of properties before ever hitting compile-time issues. AND is_read_only = 0. AND NOT EXISTS. (

C++ 58

C++ Database Servers Storage 58

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at Kernel Recipes in 2017; it is an old story that's worth resharing here. Next Steps I'd usually SSH to instances for deeper analysis, where I could use mpstat(1) to confirm the usr/sys breakdown and perf(1) to begin profiling on-CPU kernel code paths. I worked on this code back at Sun.

Cache 52

Cache Cloud Java Tuning 52

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be The trace flag does not apply to SQL Server on Linux SQL 2017 RTM thru CU5.

Servers 90

Servers Media Cache Storage 90

Brendan Gregg

SEPTEMBER 25, 2021

The broken Java stacks turned out to be beneficial: They helped group together the os::javaTimeMillis() calls which otherwise might have have been scattered on top of different Java code paths, appearing as thin stacks everywhere. Without NMI, some kernel code paths (interrupts disabled) can't be profiled. But I'm not completely sure.

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at [Kernel Recipes] in 2017; it is an old story that's worth resharing here. ## 1. Next Steps I'd usually SSH to instances for deeper analysis, where I could use mpstat(1) to confirm the usr/sys breakdown and perf(1) to begin profiling on-CPU kernel code paths. I worked on this code back at Sun.

Cache 40

Cache Cloud Java Tuning 40

Randon ASCII

JANUARY 22, 2017

The savings this time are less important as they are mostly in the.BSS segment, but there are also some modest code-size savings, and some interesting lessons. It’s also peculiar because log2f is a C Run-Time (CRT) function, which shouldn’t be supplied by Blink anyway. This worked, I closed the bug, and got on with my life.

C++ 56

C++ Code Systems Processing 56

The Morning Paper

NOVEMBER 21, 2019

And in your application code you would interact with PlanOut like this: my_exp = MyExperiment(userid=42) color = my_exp.get('button_color') text = my_exp.get('button_text'). Causal sufficiency errors. Allowing an unrecorded variable to bias treatment assignment§. Analysing PlanOut experiments at Facebook.

Programming 52

Programming Internet Internet Design 52

SQL Server According to Bob

FEBRUARY 10, 2019

SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. – -c the control file. We then found a few code paths in find login that did not switch to preemptive before making a call to SSSD or LDAP for Linux, AD activities. Unpredictable when failures occur. · xel files. .

Servers 40

Servers Network Database Systems 40

O'Reilly

MARCH 23, 2023

It can explain code that you don’t understand, including code that has been intentionally obfuscated. Sydney The internal code name of the chatbot behind Microsoft’s improved search engine, Bing. Bard Google’s code name for its chat-oriented search engine, based on their LaMDA model, and only demoed once in public.

Google 103

Google Open Source Programming Code 103

Brendan Gregg

AUGUST 8, 2017

Nowadays, the source code to old operating systems can also be found online. TABLE OF EXP(-T/C) FOR T = 5 SEC. EXPFF: EXP 0.920043902 ;C = 1 MIN EXP 0.983471344 ;C = 5 MIN EXP 0.994459811 ;C = 15 MIN. Linux is also hard coding the 1, 5, and 15 minute constants. This, too, was a dead end.

Latency 111

Latency Metrics C++ Systems 111

SQL Performance

SEPTEMBER 2, 2021

I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT(). SQL Server Split String Replacement Code with STRING_SPLIT. all_columns AS c WHERE EXISTS. ( WHERE Item = c. ) ORDER BY c. [

C++ 59

C++ Servers Testing Database 59

Randon ASCII

APRIL 17, 2018

When you own all of the code then this may involve some back of the envelope estimates, competitive benchmarking, or intuition tuned by experience. VsChromium is a Visual Studio extension that keeps all of the source code in a monitored directory loaded into RAM. We know that this code is running too slow.

Monitoring 43

Monitoring C++ Code Processing 43

SQL Server According to Bob

JANUARY 29, 2017

Launch: lldb -c core.sqlservr.8917 Taking a closer look at the log and stepping though the LLDB code I found the read failure occurring because the memory address could not be located in the tracked VM map. The change is now under review so it can be added back to the LLDB code base. FEB 1, 2017 UPDATE – CHANGE ACCEPTED.

Servers 40

Servers Programming Media Open Source 40

SQL Performance

JANUARY 8, 2020

Another option is to explicitly replace NULL inputs with an empty string using the ISNULL or COALESCE functions, but this usually results in lengthy verbose code. A much more elegant option is to use the CONCAT_WS function, which was introduced in SQL Server 2017. 3 C NULL 4 D 150.00 Contacts ; GO. CREATE TABLE dbo. Contacts. (

Design 65

Design C++ Code Database 65

SQL Server According to Bob

JANUARY 28, 2018

SQL Server also supports XA based transactions but has no code in the SQL Server engine to engage in XA transactions. MSDTC can also be used as the XA TM if so desired (see example code at end of this post.). This means there are no DTC components available for SQL Server 2017 on Linux. include “stdafx.h”

Servers 40

Servers Azure Engineering Java 40

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? The first render tends to warm up a bunch of lazily compiled code, which a larger tree can benefit from when it scales.

Performance 104

Performance Cache Network Metrics 104

O'Reilly

MARCH 2, 2020

It’s not about getting software developers to write code faster. I don’t care what you call it, but large projects (a) are rarely successful, regardless of the methodology, because they (b) get overloaded with a lot of features that nobody needs but that sound good, and (c) forget what the customer or user really needs or wants.

Artificial Intelligence 20

Artificial Intelligence Software Architecture Programming Infrastructure 20

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing).

Latency 40

Latency Hardware Code Testing 40

Smashing Magazine

JANUARY 21, 2019

A component is simply a set of pieces of HTML, JavaScript and CSS code put all together to create an autonomous entity. I will demonstrate this by re-imagining how this example coded for React would fare in a component-based API. Recommended reading : A GraphQL Primer: Why We Need A New Kind Of API. Building A Site Through Components.

Social Media 64

Social Media Database Media Website 64

SQL Server According to Bob

FEBRUARY 13, 2020

Note:​​ My colleague, Pat, enhanced the SQL Server VDI feature allowing VDI backup/restore utility support on Linux for SQL Server 2017 so you always have your choice in backup/restore storage providers on Linux and Windows. ​​ For now keep it simple. vValue);     VariantInit(&propLogon[1].vValue);

Servers 40

Servers Availability Transportation Database 40