Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier

A SQL Server (tSQL) based cron implementation using stored-procedures

This procedure can be used to generate a CREATE TABLE script for a given table in SQL Server

Cargo_Service_Database

An exploratory analysis on covid19 cases and deaths. Other interesting factors which are available in the dataset like, Stringency Index, Human Development Index, Percentage of smokers in population etc., are also explored in this analysis

full-featured Restaurant Management API built with Node.js, Express, and SQL Server. It provides seamless communication between a desktop system (cashier) and an Android app (captain/waiter), allowing both sides to manage tables, categories, and orders efficiently

Example of Entity Framework (Code First) MVVM

Modélisation et développement d’une application E-Commerce, Technologies utilisées : C#, ADO .NET, SQL Server, Razor, CSHTML, CSS, BOOTSTRAP, JS, AJAX

Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier

Transact-SQL (T-SQL) is a programming language used to manage and manipulate relational databases. It is a proprietary language developed by Microsoft and is the primary language used for programming Microsoft SQL Server

One-button SQL Server configuration to implement commonly-accepted best practices.

Develop a .NET Core console solution in C# that reads a *.csv file stored in an Azure storage account and inserts its content into a local SQL Server DB.

SQL Workouts

A high school database project for Microsoft SQL Server, written in Transact-SQL. Made for a hypothetical delivery company, so that they can manage their orders, clients, couriers, recipients, addresses and more.

App store database design

It is intended for database professionals, students, and anyone interested in deepening their understanding of complex SQL queries, performance optimization, and database design.

A useful collection of T-SQL procs, functions and views.

LTHFT Data Model - A structured SQL Server data model from the LTH Daily Management System (DMS), including the full schema, database project, and Snowflake-integrated DataHub objects for downstream use.