2017 Best Practices Servers 
SQL Performance
AUGUST 14, 2019
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.
SQL Performance
SEPTEMBER 12, 2019
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).
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
JUNE 14, 2019
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.
Percona
SEPTEMBER 1, 2023
This blog was originally published in October 2017 and was updated in September 2023. Sharding in MongoDB is a technique used to distribute a database horizontally across multiple nodes or servers, known as “shards.” MongoDB distributes data across these shard servers to ensure an even distribution.
Scalegrid
JULY 13, 2020
Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. PostgreSQL is an open source object-relational database system with over 30 years of active development. In fact, PostgreSQL is so popular, 11.5%
Dynatrace
OCTOBER 17, 2019
We’re no longer living in an age where large companies require only physical servers, with similar and rarely changing configurations, that could be manually maintained in a single Datacenter. Treating these different processes as code will ensure that best practices are followed. Dynatrace news.
SQL Server According to Bob
MARCH 18, 2018
SQL Server is designed to scale across the spectrum of small machines to enterprise class servers. The changes made in SQL Server 2017 CU4 improve resource usage on smaller machines, such as a VM or Container used for testing and development. It is a best practice keep the setting above 128.
Expert insights. Personalized for you.
108 
Let's personalize your content