SnowPro Core -Snowflake Cloud Data Platform: Features and Architecture, the course offered by Pluralsight, is a comprehensive guide .
SQL SERVER – Understanding Maximum Server Memory
When optimizing your SQL Server for superior performance, understanding and correctly implementing the ‘maximum server memory’ setting is crucial.
Celebrating 17 Years of SQL Authority: A Beautiful Journey of Learning and Sharing
I am feeling very thankful and a bit surprised. It’s been 17 years since I started SQL Authority. This journey was about learning, sharing.
SQL SERVER – Understanding Minimum Server Memory
When configuring your SQL Server for optimal performance, understanding and correctly implementing the ‘minimum server memory’ setting is crucial.
SQL SERVER – An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
This article takes a deep dive into these modifications, with a particular focus on the MIXED_PAGE_ALLOCATION property.
Snowflake’s Pruning Capabilities – Faster Query Performance
In this post, we’ll explore how Snowflake’s pruning features can optimize complex queries for blazing-fast results. Pruning Capabilities
SQL SERVER – Comparing LIKE vs LEFT for Column Comparisons
Let us learn to compare LIKE vs LEFT for Column Comparisons. When writing SQL queries, developers have a myriad of options.
SQL SERVER – Exploring SQL Graph Pattern Matching with MATCH
One of the powerful features of SQL Graph is the ability to search and traverse these graph pattern relationships easily using the MATCH clause.
SQL SERVER – Exploring PIVOT and UNPIVOT
The SQL Server PIVOT and UNPIVOT operators are powerful tools that provide an easy way to transform your data in SQL.
Function in the WHERE Clause – SQL in Sixty Seconds 201
Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.