atwix.com atwix.com

How to improve your Magento Performance with a free tool

The pace of life has become much quicker. We move fast. We accomplish much. And we expect website performance to keep up with us. Performance is one of the key factors in many areas of our life therefore, and Magento’s performance is no exception.  The speed of a website affects every user experience. From first landing on the site, to searching on the site for the various products and services, to selecting and purchasing contents...

csstricks

“The Modern Web”

A couple of interesting articles making the rounds: Tom MacWrite: Second-guessing the modern webRich Harris: In defense of the modern web I like Tom’s assertion that React (which he’s using as a stand-in for JavaScript frameworks in general) has an ideal usage: There is a sweet spot of React: in moderately interactive interfaces. Complex forms that require immediate feedback, UIs that need to move around and react instantly....

simple-talk.com simple-talk.com

Heaps in SQL Server: Part 1 The Basics

The series so far: Heaps in SQL Server: Part 1 The Basics This article is the beginning of a series of articles about Heaps in Microsoft SQL Server. Heaps are rejected by many database developers using Microsoft SQL Server. The concerns about Heaps are even fuelled by Microsoft itself by generally recommending the use of clustered indexes for every table. Globally renowned SQL Server experts also generally advise that tables in...

simple-talk.com simple-talk.com

Hands-On with Columnstore Indexes: Part 1 Architecture

The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Indexes are the key to efficient performance in any relational database. Few index enhancements have been introduced that can improve query speed and efficiency as dramatically as columnstore indexes. Improvements to this feature have been introduced in each subsequent version of SQL Server and have transformed columnstore indexes into the go-to method of...

simple-talk.com simple-talk.com

Key Insights from the 2020 State of SQL Server Monitoring Report

This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This year, 971 database professionals from around the world responded. Here are some of the key insights from the survey: Estates are growing more than ever Companies who reported over 1,000 SQL Server instances grew 9% year-on-year while those reporting fewer than 100 instances have dropped for a second year....