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.

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

App store database design

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.

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

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

PS Script + TSQL Stored Procedure to make new folders on a PBIRS with Permissions