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

Cargo_Service_Database

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

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

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

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

a comprehensive SQL Server-based database project designed for a blogging platform. The database supports blog post management, user roles, comments, notifications, and more. Developed using SQL Server Management Studio (SSMS), the project includes custom stored procedures, functions, and triggers to ensure implement business logic

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.

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.

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

SQL Workouts

In this MS SQL Database project I am creating an Automobile Shop Management System database. On this Database project I have tried to apply all the functions of MS SQL.

App store database design

Web API for todo list developed including login, register, add/upd todo and list todo

SQL Serverのサンプルクエリです。拙著「SQL Server 実践開発ガイド」に掲載されているSQLスクリプトファイルをダウンロードすることができます。