Blogs

What is Database Normalization in SQL Server – MS SQL Server – Zero to Hero Query Master – Part 4

What is Database Normalization Database normalization is the step by step process of organizing data to minimize data redundancy i.e. Data duplication which in turn ensures data consistency Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divide larger tables into smaller…
Schema Comparisons using Visual Studio SQL Data Tools

Introduction There are many occasions where we may need to compare the schema between two databases. For example, comparing Development and Production databases against each other, or comparing a database against a SQL Server Database project. Microsoft Visual Studio SQL Data Tools provides functionality that allows us to compare the structure of the database tables,…
Link a SQL Server Database Project to a Git Repository

Introduction Continuous Integration has become practice to many development project. Did you know, we can achieve that in SQL Server Project in Visual Studio as well!!. Much needed one !!! There is a relatively easy path to get our databases into Database Projects (which we discussed in previous article), and ultimately source control. Implementing proper database…
Create and Publish SQL Server Database Project With Visual Studio

Introduction Databases plays an important role in any project these days. It becomes too difficult to manage the objects such as Tables, Views, Procedures and Functions increases over the time and also difficult to manage when number of team members works in Database at the same time. And even after that when we manage the…
Build Progressive Web Applications with Blazor WebAssembly

Introduction How many of us know, Blazor WebAssembly applications has offline support?. They can convert our Web Application into a Desktop or Mobile Applications, and that is called Progressive Web Application (PWA). In this article, we will discuss how to convert our WebAssembly Application into a Progressive Web Application (PWA), How do a PWA application…
Customize Azure Data Studio with Dashboard Widgets

Introduction Azure Data Studio is a free multi-platform database tool with built-in support for both SQL Server on-premises and Azure SQL Databases. These databases can be accessed in Azure Data Studio for numerous tasks like query editing, data development, built-in charting of T-SQL queries, etc. Database developers or Database Administrators often have a need to…