Reading a CSV file and outputting its contents as a JSON file using PowerShell.

Powershell Read CSV file and out pull json file

Resolution for Error The server principal is not able to access the database under the current security context in SQL Server

The server principal is not able to access the database under the current security context in SQL Server

Aggregate Product in SQL Server

Partition SQL Server Tables with File Groups

SQL Server Database Partitioning

Delete Millions of Rows in a Table in SQL Server using

Delete Millions of Rows in a Table in SQL Server

Distributed systems are complex, requiring careful planning and design to handle challenges like data consistency, fault tolerance, and scalability. Below are 30 essential patterns in distributed systems

30 essential design patterns for distributed systems

One common challenge in software development is organizing the code to be clear and easy to work with. This is where different architectural styles, like Clean Architecture and Vertical Slice Architecture, come into play.

Clean Architecture and Vertical Slice Architecture

How to use multiple Java versions in an Azure DevOps pipeline with a Windows Server 2019 and Visual Studio 2019 build agent

Managing Multiple Java Versions in Azure DevOps Pipeline on Windows Server 2019 with Visual Studio 2019 Build Agent

How to dynamically populate option values in manual GitHub Action parameters. It uses a GitHub Action designed to update the YAML file of the main action whenever changes are pushed to the branch. It also uses a script to read the current parameter values, compare them to the dynamic values, and update the YAML file if they differ. This strategy allows for real-time updates and dynamic population of choice parameters in your GitHub Actions.

Dynamically Populating Parameters in Manual GitHub Action

Go beyond traditional logging and make logs usefull

Structured logging in C#

Imagine having a robotic helper that constantly tests your apps to ensure they work perfectly for your customers. That is synthetic monitoring. It simulates user actions to check performance of the app, like a robot testing different parts of a car. It differs from real user monitoring, which relies on actual user interactions to gather data.

What is synthetic monitoring?

The discussion about whether to test private methods in software development is ongoing, and most experts suggest avoiding it in favor of testing isolated parts of code, as highlighted in this post about C#.

Should we Unit Test Private Methods?

Unlock the power of software refinement with Extract Function.

The Power of Refactoring : Extract Function

Health check implementation in Powershell.

Implement health check n Powershell

Creating test files of different sizes in Windows is essential for various purposes, such as testing storage devices or evaluating application performance. This blog post guides you through simple techniques to generate test files of specific sizes using built-in Windows tools, ensuring efficient testing and analysis without relying on third-party software.

Create Test files with different sizes in windows

Master the art of reverting a single file in Git with precision and elegance. Learn how to effortlessly undo unintended changes, maintain a clean commit history, and restore code integrity. Take control of your files and streamline collaboration with ease.

Cleansing the Code - Mastering Single File Reversion in Git

Explore how to use the BCP utility to export data from a SQL Server database and save it to a CSV file. Provide a step-by-step guide, explaining each component of the BCP command and how to execute it successfully, offering a beginner-friendly approach to automate the export process.

Exporting SQL Server Data using BCP Utility

Azure API Management simplifies API lifecycle management, offering design flexibility, robust security features, and advanced analytics. It acts as a gateway between backend services and client applications, providing scalability and visibility into API metrics. With Azure API Management, businesses can streamline API infrastructure while ensuring security and developer productivity.

Introduction to Azure API Management: Managing APIs Made Easy

Checking installed .Net frameworks in Powershell

How to check installed .Net Framework versions in Powershell

PowerShell is a powerful scripting language that can be used to automate various administrative tasks, including data management and analysis. In this article, we will show you how to export data from a SQL database to a CSV file using a SQL query and the command-line tool.

Exporting Data to CSV using SQL Query and PowerShell

Fixing the issue of  Error System.Data.Odbc.OdbcException ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application  

The specified DSN contains an architecture mismatch between the Driver and Application

SQL query to find referencing Tables by column name

Find Tables by Column names in SQL Server

Drop all tables in a specific schema

Find Database size in SQL

Build SQL connection string in powershell using SqlConnectionStringBuilder

Build SQL connection string in powershell

Lets see how we can do the batch update in sql server without killing resources

How to batch update millions of record in SQL Server

Deploy Azure storage account with a blob container and generate connection string with SAS token and update one of the web app’s settings with generated connection strings.

Deploy storage account and output connection string with SAS token using ARM template

Introduce new columns to Existing List of Tables in SQL server from a query.

Add new Columns to List of Tables in SQL Server

Top-Level Statement - programs without Main methods in C#

Get the Decimal result from deviding Integers in SQL Server

Integer Division Result in Decimal in SQL server

Indices and Ranges in C#

Upload directory to Azure Storage using AzCopy in linux

READ UNCOMMITTED transaction isolation level and NOLOCK in SQL server

All Posts

Powershell Read CSV file and out pull json file

The server principal is not able to access the database under the current security context in SQL Server

Aggregate Product in SQL Server

SQL Server Database Partitioning

Delete Millions of Rows in a Table in SQL Server