data-nerd.blog
3 FOLLOWERS
Hands-on with SQL Server
data-nerd.blog
4M ago
Disclaimer: This image was generated with DALL-E by OpenAI. Hey Y’all! I want to share something I’ve been thinking about a lot lately. You know how our lives today are basically swamped with social media? Instagram, TikTok, Snapchat, Facebook, Twitter – you name it, we’re on it. And let’s not even get started on the ..read more
data-nerd.blog
5M ago
मेरा बैग पैक करते हुए, मेरे आसपास की जगह सिर्फ मेरे सामान से नहीं भरी है—यहाँ आभार और यादों की गहराई भी भरी हुई है। मेरी कानपुर की यात्रा ने मुझे फिर से उन रिश्तों और यादों के करीब ला दिया जो मेरी ज़िंदगी की नींव हैं। कई सालों बाद जब मैंने अपने घर तो … ..read more
data-nerd.blog
11M ago
Two years back, I wrote a blog post titled “PostgreSQL – Mastering UPSERT“, in which I explored the nuances of the INSERT ON CONFLICT command that allows conditional inserts or updates of rows. Continuing its database technology innovation, PostgreSQL 15 has introduced an exciting new feature – the MERGE command. This command offers a more ..read more
data-nerd.blog
1y ago
I’m excited to be speaking at Citus Con 2023 on April 18-19 on reducing your PostgreSQL costs on Azure managed Postgres. In my talk, I’ll be sharing tips and tricks that can help you save money without sacrificing performance. Join me at the upcoming conference to learn more about how you can optimize your Azure ..read more
data-nerd.blog
1y ago
It’s that time of year when I am excited to share the books I have read! It’s one of the self-created traditions that I look forward to every year. This year in 2022, I’ve read some great books and watched a few amazing documentaries — some are new releases, some older, but each one of ..read more
data-nerd.blog
1y ago
1 paragraph summary: The Burnout Fix delivers practical advice on how to thrive in the dynamic work environment we revolve around every day by setting realistic goals, keeping a work-life balance, and prioritizing our well-being. We recently started a book club in my team, with a simple objective to connect with each other on topics ..read more
data-nerd.blog
2y ago
Whenever you are dealing with pattern matching in PostgreSQL, it is often required to write queries to match string patterns. The conventional wisdom to do pattern match was using the LIKE operator, which is not very effective for many reasons. PostgreSQL now offers more advanced pattern matching options such as SIMILAR TO expressions, POSIX regular expressions, and ..read more
data-nerd.blog
2y ago
This far in the Window Function in PostgreSQL series I have covered window function basics, how to use aggregate window functions, ranking window function and value window functions. While you’re here, I’ll recommend to you check the previous posts on this topic. In this post, we’ll learn a new concept i.e. frame_clause. Let’s jump right in! What is frame? Windows ..read more
data-nerd.blog
2y ago
This is 4th post in my series featuring Window Function in PostgreSQL. In this post, I’ll explain how to use Value window functions – that we can use to calculate various value type aggregations such as Lag, Lead, First_Value and Last_Value within each window or partitions. Let’s create our test dataset If you already have Postgres installed on your computer ..read more