article thumbnail

Site reliability done right: 5 SRE best practices that deliver on business objectives

Dynatrace

Uptime Institute’s 2022 Outage Analysis report found that over 60% of system outages resulted in at least $100,000 in total losses, up from 39% in 2019. Aligning site reliability goals with business objectives Because of this, SRE best practices align objectives with business outcomes. Service-level indicators (SLIs).

article thumbnail

T-SQL bugs, pitfalls, and best practices – window functions

SQL Performance

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. In our query plan, we have exactly two rows written to the spool per underlying row, so SQL Server uses the in-memory spool.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

T-SQL bugs, pitfalls, and best practices – pivoting and unpivoting

SQL Performance

This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. Here I'll describe the trap, the potential bug, and a best practice that prevents the bug. Previously I covered determinism , subqueries , joins and windowing. This month I cover pivoting and unpivoting. 830 rows affected).

article thumbnail

T-SQL bugs, pitfalls, and best practices – Joins

SQL Performance

This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. All of these bugs are related to T-SQL querying fundamentals, and are easy to avoid if you follow simple best-practices.

article thumbnail

Easily monitor your SAP ABAP platform and user experience with Dynatrace (GA)

Dynatrace

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. Dynatrace news. Why SAP ABAP platform monitoring in Dynatrace?

article thumbnail

O’Reilly serverless survey 2019: Concerns, what works, and what to expect

O'Reilly

Rather than buying racks and racks of servers that need to handle the maximum potential traffic and be idle most of the time, it seems that serverless’ method of paying by compute is proving to be beneficial to the bottom lines of organizations. The third stand-out issue was “no server maintenance.” 1 reported benefit.

article thumbnail

What is web application security? Everything you need to know.

Dynatrace

A web application is any application that runs on a web server and is accessed by a user through a web browser. According to the 2019 Verizon Data Breach Investigations Report, web application attacks were the number one type of attack. SAST tools identify problematic coding patterns that go against best practices.