Understanding MERGE to Insert, Update, and Delete Data Simultaneously
Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]
SQL
Managed Instance Gotchas – Error Conditions
I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]
Fabric Analytics for SQL folks: Part 1 – Fabric demystified
Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and […]
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Writing an Efficient Query
SQL is easy to start writing. The basic syntax to start returning data is very simple. This […]
EsProc SPL and SQL, Complimentary , But Different Technologies
Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your […]
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by […]
Will AI end with SQL, Is this the end of ...
Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI […]
SQL Window Functions Series: NTILE()
Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […]