Blogs

Getting Started With Python – Part One

Introduction Python is a popular high-level programming language known for its simplicity, versatility, and readability. It is widely used in various domains, such as web development, data analysis, scientific computing, artificial intelligence, and machine learning. Python was created in 1991 by Guido van Rossum and has since become one of the most widely used programming…
Quick Reference Guide for SQL Server DBA Daily Tasks

Introduction As a SQL Server Database Administrator (DBA), daily operations can be time-consuming and require a vast amount of knowledge and experience. From managing backups to troubleshooting performance issues, a DBA’s daily tasks can be daunting without a proper reference guide. That’s where a cheat sheet or quick reference guide can come in handy. It…
Azure Data Studio vs SSMS – Overview

Introduction When it comes to working with SQL Server, Microsoft offers two powerful tools: Azure Data Studio and SQL Server Management Studio (SSMS). While both tools are designed for managing SQL Server, they differ in several key areas. In this article, we will explore the features and benefits of each tool, and discuss which scenarios…
T-SQL Query To Find Deadlocks In MS SQL Server

Introduction As a Backend Developer, I have frequently encountered performance issues, particularly those stemming from poorly written code or lack of indexes, which can lead to blocking conditions called “deadlocks.” These situations can directly impact user experience and become more severe with frequent occurrences. This article addresses deadlock issues and reporting. Upon completion, readers will…
Introduction To Python – Part One

Introduction Python is a ‘high-level, interpreted, general-purpose programming language’ that is utilized for various purposes such as ‘web development, scientific computing, data analysis, artificial intelligence, and more.’ It is recognized for its ‘simple and easy-to-read syntax,’ making it a desirable language for novice programmers. Furthermore, Python has a thriving and dynamic community, offering an abundance…
What is Entity Framework

Introduction Entity Framework (EF) is an object-relational mapping (ORM) framework for the Microsoft .NET Framework. It allows developers to work with a database using objects, eliminating the need to write SQL commands. EF provides a set of APIs for creating, querying, and updating data in a database, and it can work with a variety of…