People and Culture Blog

Read permission on secondary replica in always-on AG

How to give read permission on secondary replica in always-on AG    Purpose of Log shipping:     Always On availability groups feature is a high-availability and disaster-recovery solution that provides an…

Read More

Permission on secondary database in loginshipping

How to give read permission on secondary server in log shipping    Purpose of Log shipping:   SQL Server Log shipping allows databases to automatically send transaction log backups from a…

Read More

Convert Comma-Separated Values from a Single Row into Multiple Rows in MSSQL

Introduction:-         Handling comma-separated values (CSV) is a common requirement in database management, especially when working with data that needs to be parsed into multiple rows for…

Read More

Seamlessly Integrating Python with Power BI Using Anaconda: A Comprehensive Guide

Introduction/Issue  Integrating Python with Power BI using Anaconda can sometimes be challenging due to compatibility issues and configuration complexities. This blog aims to provide a comprehensive guide to overcoming these…

Read More

Power BI Row-Level Security (RLS)

Introduction: Row-Level Security (RLS) in Power BI controls data access at the row level based on user identity. It restricts users to viewing only the data that aligns with their…

Read More

Power BI File Types Demystified: Your Guide to PBIX, PBIT, and PBIP

Introduction/Issue  Understanding the different Power BI file types—PBIX, PBIT, and PBIP—can be confusing for users. This blog aims to clarify the distinctions between these file types and provide guidance on…

Read More

Enabling Navigation Menu Adjustments in Oracle APEX

Introduction : The navigation menu is a critical part of the user interface, enabling users to easily access various features and pages of the application. However, the default navigation options may…

Read More

Best Practices for Data Modeling in Power BI

Introduction In this blog post, we’ll explore the best practices for building effective and efficient data models in Power BI. Data modeling involves creating visual representations of data structures and…

Read More

Auto-Format Aadhaar Numbers in Oracle APEX Using Java Script

Introduction : Oracle APEX simplifies web app development, while JavaScript adds real-time interactivity. Together, they offer a powerful solution for capturing and validating Aadhaar numbers—India’s unique 12-digit ID. Why we need…

Read More

Balamurugan: From Humble Beginnings to Inspiring Leadership Starting the Journey

Balamurugan, fondly known as Bala, hails from Keezha Eral village in Thoothukudi district. Born in 1981, he grew up in Puliyanthope, a bustling neighborhood in North Chennai. His early years…

Read More