top of page

All Posts


Automate Data Security: Azure Logic Apps for SFTP Uploads
In the digital age, protecting data at every stage is essential, particularly for organizations handling sensitive or regulated information. One crucial aspect of data security is ensuring that files entering an organization’s system are safe from malware and other threats. Automated file scanning at the point of entry is a robust strategy that can secure business workflows and reduce risk exposure. In this article, we’ll explore how Azure Logic Apps can automate file securit
dhanasekar palani
Jan 104 min read


Twenty Years with SQL: The Language That Never Goes Out of Style
Twenty years ago, I had zero programming experience. Today, I'm a architect who has watched countless technologies rise and fall, while SQL remains the unshakeable foundation of the data world. Here's how one query language became my career superpower.
dhanasekar palani
Jan 84 min read


From Documents to Rows: Our Journey Migrating MongoDB to SQL Server in AWS
When I received a migration requirement back in 2019, I'll be honest—I had to pause for a moment. "We need to move from MongoDB to SQL Server," they said. "And oh, by the way, the source is on-premises and the target is in AWS." After years of handling database migrations, this was a first for me. Most of my previous work involved moving data between similar systems—Sybase to SQL Server, MySQL to SQL Server, MS Access to Oracle, and similar relational-to-relational migrations
dhanasekar palani
Jan 86 min read


Optimize Delta Lake Storage with VACUUM Command
As a data engineer managing batch file processing with Databricks, I recently encountered a storage issue that many teams face: rapidly increasing storage volume. In this blog, I'll share the challenge I faced with my Delta Lake storage, how I resolved it, and the benefits I gained by implementing Databricks' VACUUM command to manage storage more efficiently.
dhanasekar palani
Jan 83 min read
bottom of page