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. 2017-07-04 10248 440.00 2017-07-05 10249 1863.40 2017-07-08 10250 1552.60 2017-07-08 10251 654.06

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).

Insiders

Sign Up for our Newsletter

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

article thumbnail

The future of AI: Kelsey Hightower on how AI can raise the bar for humanity

Dynatrace

Focusing on the fundamentals Grabner recalled a 2017 tweet from Hightower that outlined how his technology career gathered steam once he started to “focus on the fundamentals.” Hightower shared his beliefs on operational best practices. In the IT world, there are constantly new concepts, terms, and technologies to learn.

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

Multi-Cloud Management Tools, Challenges and Best Practices

Simform

“By 2022, about 75% of enterprise customers using cloud infrastructure as a service (IaaS) will adopt a deliberate multi-cloud strategy, up from 49% in 2017.”. The post Multi-Cloud Management Tools, Challenges and Best Practices appeared first on Insights on Latest Technologies - Simform Blog. Gartner Research.

article thumbnail

A Tutorial on MongoDB Sharding With Best Practices & When To Enable It

Percona

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen).

article thumbnail

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

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%