The EOMONTH() function is one of the most commonly used functions in reporting and data analysis. For a given date, it returns the month’s last
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Conditional Function IIF – SQL Server
Depending on whether the Boolean expression in SQL Server evaluates to true or false, the conditional function IIF returns one of two values. For ease
Min vs Least in Azure SQL
In this post, we will discuss the similarities and differences between two Azure SQL functions, MIN and LEAST. Using both functions, we get the least/minimum/lower
Max vs Greatest in Azure SQL
In this post, we will discuss the similarities and differences between two Azure SQL functions, MAX and GREATEST. Using both functions, we get the largest
STUFF Function in SQL Server
The STUFF function combines two strings into one. It deletes a specified number of characters from the beginning of the first string, then inserts the
SQL Server Mathematical Functions-2
SQL Server’s mathematical functions assist in calculating values. The functions will assist with fundamental addition, subtraction, multiplication, and division, among other things. Let’s take a
Big Data & SQL 