SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. For many years I've found users making the same mistakes. DBCC CHECKDB.

Servers 49

Servers Azure Hardware Database 49

Smashing Magazine

MAY 16, 2022

To my surprise, web performance monitoring conversations rarely surface Server-Timing or cover a very shallow understanding of its application — despite it being out for many years. For this article, that’s all we’ll need to start exposing the value and leave other more specific articles to go deeper. More after jump!

Servers 92

Servers Monitoring Cache Network 92

Testsigma

FEBRUARY 3, 2021

People won’t even waste a chance to leave a negative review if they found a little error in the app, whether it’s performance glitches, a weak user interface, or a crash. The testing of mobile apps includes testing their functionality, performance, loading, security, and usability. Deployment of app becomes faster.

Mobile 52

Mobile Testing Testing Tools Open Source 52

Smashing Magazine

NOVEMBER 2, 2021

Users who opened a PWA from a smartphone’s browser might even not be aware that they’re using a progressive web app, assuming that it’s just a well-performing site. Far from perfect site speed and performance are common pain points for many Magento stores, which are usually massive and complicated. Large preview ).

Code 74

Code Cache Retail Mobile 74

KeyCDN

OCTOBER 2, 2018

Its videos and blog articles address issues such as web performance, extensible component development and the intersection of CSS with other technologies, like HTML and JavaScript. features collected articles that concentrate on what makes JavaScript work and what doesn’t. Visit website 3. Visit website 6.

Development 75

Development Website Design Code 75

Smashing Magazine

JANUARY 11, 2021

Front-End Performance Checklist 2021. Front-End Performance Checklist 2021. This guide has been kindly supported by our friends at LogRocket , a service that combines frontend performance monitoring , session replay, and product analytics to help you build better customer experiences. Web performance is a tricky beast, isn’t it?

Performance 145

Performance Cache Media Metrics 145

SQL Performance

APRIL 17, 2020

Along with a large number of restrictions on what is even possible with this command, there is always the question of performance. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only. ( SELECT.

Servers 63

Servers Database Testing Efficiency 63

Testsigma

MARCH 6, 2020

This bug once reported, is going to be referred to by the all other teams that need to know the status of a project, including the testing team, development team, product owner, managers, clients and business analysts. Note: In this article, we will be using defect and bug interchangeably. Example – Spelling mistakes on the webpage.

Website 52

Website Testing Systems Development 52

CSS - Tricks

OCTOBER 10, 2019

WebPageTest is an online tool and an Open Source project to help developers audit the performance of their websites. As a Web Performance Evangelist at Theodo , I use it every single day. I am constantly amazed at what it offers to the web development community at large and the web performance folks particularly — for free.

Performance Testing 51

Performance Testing Testing Performance Open Source 51

SQL Performance

SEPTEMBER 9, 2020

This article is the sixth part in a series about table expressions. The empid column represents the employee ID of the subordinate (the child node), and the mgrid column represents the employee ID of the manager (the parent node). Last month in Part 5 I covered the logical treatment of nonrecursive CTEs. Employees ; GO.

C++ 143

C++ Code Servers Availability 143

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. In my 15+ years of coding, every single time I've dealt with legacy code, fear, anger, hate, and suffering were pretty common. These oversights might end up as costly mistakes later. You've managed to isolate it. Code that had duplication all over the place?

Architecture 49

Architecture Database Code Systems 49

Smashing Magazine

JULY 2, 2021

Unfortunately, email testing is often underestimated and leads to email testing mistakes that kill all your effort spent on creating a great email sequence. In this article, we’ll explain how a proper email testing workflow can help you improve email sending efficiency. Let’s talk email testing! Email template. Spam checks.

Testing 109

Testing Servers Social Media Automotive 109

Highly Scalable

SEPTEMBER 18, 2012

As such, it encompasses distributed system coordination, failover, resource management and many other capabilities. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. Scalability is one of the main drivers of the NoSQL movement. Consistency.

Database 213

Database Latency C++ Scalability 213

Alex Russell

SEPTEMBER 20, 2020

In '07, safety implied an unacceptable performance hit on slow single-core devices with 128MiB of RAM. For applications that need peak compute performance, the effective tax rate of excellent runtime security is now in the 5-10% range, rather than the order of magnitude cost a decade ago. Nobody's proposing to make native's mistakes.

Hardware 64

Hardware Mobile Java Programming 64

Smashing Magazine

FEBRUARY 8, 2022

With detailed code walkthroughs , hands-on examples and common gotchas — all broken down into short, manageable lessons. Statoscope processes the stats, performs analysis and provides a visual representation to interpret the results in a convenient form: ( Large preview ). Jump to table of contents ?. Large preview ).

Storage 79

Storage Code Metrics C++ 79

Smashing Magazine

SEPTEMBER 24, 2021

From the moment we went live, we experienced performance issues. performance improvement can lead to a 10% increase in conversion. To mitigate the performance issues, we had to add a lot of (unbudgeted) extra servers and had to aggressively cache pages on a reverse proxy. Plan For Performance And Measure Performance.

Website 113

Website Code Servers Analytics 113

O'Reilly

NOVEMBER 28, 2023

Automating the process of building complex prompts has become common, with patterns like retrieval-augmented generation (RAG) and tools like LangChain. The most common reason, by a significant margin, was difficulty finding appropriate business use cases (31% for nonusers, 22% for users). Is generative AI the answer? Perhaps not yet.

Open Source 107

Open Source Artificial Intelligence Google Infrastructure 107

O'Reilly

JULY 25, 2023

This article summarizes what I learned from that experience. The inspiration (and title) for it comes from Mike Loukides’ Radar article on Real World Programming with ChatGPT , which shares a similar spirit of digging into the potential and limits of AI tools for more realistic end-to-end programming tasks.

Programming 98

Programming Code Design Benchmarking 98

Smashing Magazine

JULY 12, 2021

There is also the matter of convincing the management or project stakeholders to invest the time and resources into the refactoring process. In just three weeks, they’ve managed to improve the overall health of the CSS codebase, reduce the CSS file size, improve render performance on mobile, etc. “A

Best Practices 145

Best Practices Website Architecture Media 145

Smashing Magazine

JULY 14, 2021

It’s not necessarily just the sheer amount of data that is difficult to make sense of though; it’s the complexity and lack of consistency that the data usually entails which requires some filtering — such a common scenario in data grids, enterprise dashboards, vaccine tracking and public records registries. Part Of: Design Patterns.

Design 142

Design Retail Ecommerce Mobile 142

Smashing Magazine

AUGUST 22, 2021

HTTP/3: Performance Improvements (Part 2). HTTP/3: Performance Improvements (Part 2). In this second part, we will zoom in on the performance improvements that QUIC and HTTP/3 bring to the table for web-page loading. HTTP/3 performance features ( current article ). Robin Marx. 2021-08-23T06:20:00+00:00.

Performance 105

Performance Network Latency Servers 105

Smashing Magazine

SEPTEMBER 6, 2021

If after the previous two parts — HTTP/3 history and core concepts and HTTP/3 performance features — you’re convinced that starting to use the new protocols is a good idea (and you should be!), HTTP/3 performance features. Practical HTTP/3 deployment options ( current article ). This is more in-depth and technical.

Network 104

Network Servers Cache Traffic 104

Strategic Tech

JUNE 23, 2018

Loosely-coupled teams enabled by loosely-coupled software architecture is one of the strongest predictors of continuous delivery performance and organizational scaling. The best we can do is to be aware of the fundamental challenges we will face and avoid the common mistakes. So how do we find the right boundaries?

Systems 40

Systems Social Media Design Media 40