SQLadmin/tsqltools

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

Language: TSQL - Size: 45.9 KB - Last synced at: about 2 months ago - Pushed at: 11 months ago - Stars: 44 - Forks: 38

BeginTry/SQL-Server-Data-Obfuscation

Stored procedures for overwriting existing data with randomly generated data.

Language: TSQL - Size: 105 KB - Last synced at: about 2 years ago - Pushed at: over 4 years ago - Stars: 9 - Forks: 3

veenapaul/SQL-Basics-to-Advanced

Language: TSQL - Size: 395 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 6 - Forks: 3

kgeorge314/tSQLcron

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

Language: PLpgSQL - Size: 125 KB - Last synced at: about 1 year ago - Pushed at: almost 5 years ago - Stars: 6 - Forks: 1

EitanBlumin/sp_GenerateTableDDLScript

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

Language: TSQL - Size: 30.3 KB - Last synced at: about 2 months ago - Pushed at: over 3 years ago - Stars: 5 - Forks: 1

MehrajLatifli/BookStore---Entity-Framework-Code-First-MVVM

Example of Entity Framework (Code First) MVVM

Language: C# - Size: 30.3 KB - Last synced at: 3 days ago - Pushed at: over 3 years ago - Stars: 3 - Forks: 1

shine-jayakumar/Covid19-Exploratory-Analysis-With-SQL

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

Language: TSQL - Size: 13.2 MB - Last synced at: over 2 years ago - Pushed at: almost 4 years ago - Stars: 3 - Forks: 0

anismtl/IkeyPro-ASP-.NET-Core

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

Language: C# - Size: 6.71 MB - Last synced at: over 2 years ago - Pushed at: over 5 years ago - Stars: 3 - Forks: 0

ARYANKAUSHIK/tsqltools Fork of SQLadmin/tsqltools

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

Language: PLpgSQL - Size: 51.8 KB - Last synced at: over 2 years ago - Pushed at: about 7 years ago - Stars: 3 - Forks: 0

fou1100ouacus/Database-Level2-Concepts-T-SQL

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

Language: TSQL - Size: 1.95 MB - Last synced at: about 2 months ago - Pushed at: 8 months ago - Stars: 2 - Forks: 0

sthossan/sql-query

Language: TSQL - Size: 65.4 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 2 - Forks: 1

vladperchi/CsvImporterDapper

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.

Language: C# - Size: 287 KB - Last synced at: almost 2 years ago - Pushed at: about 3 years ago - Stars: 2 - Forks: 3

it21208/Data_Engineer_Code_Challenge

𝐔𝐬𝐞𝐫𝐬 𝐨𝐟 𝐜𝐞𝐭𝐚𝐢𝐧 𝐨𝐫𝐠𝐚𝐧𝐢𝐬𝐚𝐭𝐢𝐨𝐧 𝐟𝐫𝐨𝐧𝐭-𝐟𝐚𝐜𝐢𝐧𝐠 𝐬𝐢𝐭𝐞 𝐬𝐞𝐞 𝐭𝐡𝐞 𝐜𝐥𝐚𝐬𝐬𝐢𝐟𝐢𝐞𝐝𝐬 𝐭𝐡𝐚𝐭 𝐚𝐫𝐞 𝐞𝐧𝐭𝐞𝐫𝐞𝐝 𝐢𝐧 𝐭𝐡𝐞 𝐬𝐲𝐬𝐭𝐞𝐦𝐬 𝐛𝐲 𝐭𝐡𝐞𝐢𝐫 𝐜𝐮𝐬𝐭𝐨𝐦𝐞𝐫𝐬. 𝐖𝐡𝐞𝐧 𝐚 𝐜𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐜𝐫𝐞𝐚𝐭𝐞𝐬 𝐚 𝐜𝐥𝐚𝐬𝐬𝐢𝐟𝐢𝐞𝐝, 𝐭𝐡𝐞 𝐬𝐲𝐬𝐭𝐞𝐦𝐬 𝐞𝐦𝐢𝐭 𝐚 𝐫𝐞𝐜𝐨𝐫𝐝 𝐨𝐟 𝐢𝐭 𝐚𝐧𝐝 𝐩𝐮𝐛𝐥𝐢𝐬𝐡 𝐢𝐭 𝐭𝐨 𝐚 𝐊𝐚𝐟𝐤𝐚 𝐭𝐨𝐩𝐢𝐜. 𝟏. 𝐂𝐫𝐞𝐚𝐭𝐞 𝐚𝐧 𝐚𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐭𝐡𝐚𝐭 𝐜𝐨𝐧𝐬𝐮𝐦𝐞𝐬 𝐭𝐡𝐞𝐬𝐞 𝐫𝐞𝐜𝐨𝐫𝐝𝐬. 𝟐. 𝐑𝐞𝐜𝐨𝐫𝐝 𝐭𝐡𝐞𝐦 𝐢𝐧 𝐚 𝐌𝐲𝐒𝐐𝐋 𝐝𝐚𝐭𝐚𝐛𝐚𝐬𝐞. 𝟑. 𝐖𝐫𝐢𝐭𝐞 𝐚 𝐒𝐐𝐋 𝐬𝐜𝐫𝐢𝐩𝐭 𝐭𝐨 𝐚𝐧𝐚𝐥𝐲𝐬𝐞 𝐭𝐡𝐢𝐬 𝐢𝐧𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧.

Language: Python - Size: 113 KB - Last synced at: over 2 years ago - Pushed at: over 5 years ago - Stars: 2 - Forks: 0

pimbrouwers/sp_EasyButton

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

Size: 25.4 KB - Last synced at: 2 months ago - Pushed at: over 6 years ago - Stars: 2 - Forks: 0

doshiharmish/DBMS-MedicalRocket-Hospital-Management-System

This user-friendly system tackles the challenge of managing diverse hospital data by centralizing information and empowering stakeholders with intuitive access.

Language: TSQL - Size: 2.57 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

Rifat392000/TrustiMessaging

Trust iMessaging is an online messaging website that sends bulk and single messages to its customers using social media platforms like WhatsApp and stores all records in a database.

Language: HTML - Size: 11.6 MB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

markusbegerow/microsoft-tsql-toolbox

Microsoft T-SQL snippets that I use frequently

Language: TSQL - Size: 20.5 KB - Last synced at: 3 days ago - Pushed at: almost 2 years ago - Stars: 1 - Forks: 0

JessicaCasteloBranco/Biblioteca-Virtual-

Projeto usando .Net 6, Blazor, Api Minimal, MudBlazor, RestSharp, SQL

Language: HTML - Size: 207 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 1 - Forks: 0

mhasanlab/Automobile-Shop-Database

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.

Language: TSQL - Size: 17.6 KB - Last synced at: about 2 years ago - Pushed at: about 3 years ago - Stars: 1 - Forks: 0

Stobertonf/FundamentosSQL

Scripts do curso do Professor André Baltieri (Balta) na plataforma https://balta.io para revisar conceitos do SQL Server.

Language: TSQL - Size: 9.77 KB - Last synced at: 3 months ago - Pushed at: over 3 years ago - Stars: 1 - Forks: 0

vesk4000/Couriers

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.

Language: TSQL - Size: 39 MB - Last synced at: about 2 years ago - Pushed at: over 3 years ago - Stars: 1 - Forks: 1

Adexandria/AdeCartAPI

A Simple E-commerce Restful API

Language: C# - Size: 146 KB - Last synced at: over 2 years ago - Pushed at: almost 4 years ago - Stars: 1 - Forks: 0

Roboticsdreams/SQL

SQL Workouts

Language: TSQL - Size: 1.02 MB - Last synced at: almost 2 years ago - Pushed at: almost 4 years ago - Stars: 1 - Forks: 0

necmettindemir/web-api-001-todo-app

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

Language: C# - Size: 37.1 KB - Last synced at: over 2 years ago - Pushed at: about 6 years ago - Stars: 1 - Forks: 0

mvfc/PBIRS-Admin-Automation

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

Language: PLpgSQL - Size: 41 KB - Last synced at: about 2 years ago - Pushed at: over 6 years ago - Stars: 1 - Forks: 0

Sigge1511/ado_sakila_testv15

School assignment in our database development course. Testing ADO and stored procedures

Language: C# - Size: 14.6 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

Imran-imtiaz48/Charity-Management-System-Database

Charity-Management-System-Database

Language: TSQL - Size: 394 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

davisduccopny/Database-project-for-bookstore

Database design project for a bookstore, using queries to set up procedures for sales, triggers to catch errors in erroneous operations

Language: TSQL - Size: 2.47 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

AlphaC137/Employee-Analytics-System

SQL-based employee management and analytics system, featuring advanced SQL concepts.

Language: TSQL - Size: 0 Bytes - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

MeePks/TSQL-Duplication-Analyzer

A stored procedure to check, identify, and manage duplicate key setups in database tables across multiple datasets, ensuring data integrity and consistency.

Language: TSQL - Size: 81.1 KB - Last synced at: 2 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

lunaF19/programacion-iv-db-universidad-sql-server

SQL Server Database of University

Language: TSQL - Size: 1.13 MB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

fou1100ouacus/AdvancedDataBaseProblems

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

Size: 51.8 KB - Last synced at: about 2 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

mahboube89/BlogPlatformDB

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

Language: TSQL - Size: 4.99 MB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

cura-re/interpolapi

Backend, database, stored procedures, and queries for the Interpol application.

Language: C# - Size: 19.6 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

FraLobbia/Database-Polizia

Creazione tabelle, query e store procedure in SQL simulando un database di una stazione di polizia per catalogare dati anagrafici, verbali ed estraendone i dati ricercati

Language: TSQL - Size: 5.86 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

katerinarologisidiropoulou/SQL-Order-Inventory-Control-System

Out of all university projects, to me this has been the most engaging and demanding one.At the same time, it was a really fun way to start exploring DBMS and learning how to code in Python.

Language: Jupyter Notebook - Size: 282 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

commited-code/db-management-system

Este é um projeto de exemplo para demonstrar as melhores práticas de gerenciamento de banco de dados com T-SQL, SQL Server, C#, e .NET Core

Size: 5.86 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

AlecStahnke/Tekton

This repo contains portions of Tekton's Front-end, Back-end, and Database that I had the pleasure of working on.

Size: 24.4 KB - Last synced at: 15 days ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

hsynadguzel/PET_CARE_DB

PET CARE DATABASE

Language: TSQL - Size: 6.84 KB - Last synced at: about 1 year ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

letiendat1002/e-commerce-hqtcsdl

Ecommerce Database Learning T-SQL Project

Language: TSQL - Size: 679 KB - Last synced at: 6 days ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

Hemantdhurve/BookStoreApp

Creation of BookStore App Backend using ASP.Net core by using Database First Approach with the implementation of Dependency Injections,3-Tier Architecture, Swagger, JWT Token, HTTP Verbs/Methods, MSMQ, RolesAuthorization, Database SQL Stored Procedures.

Language: C# - Size: 107 KB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

stpn77/svcdb

Sample database for service operations

Language: TSQL - Size: 1.48 MB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

hasanbaysal/Example-Db-Script

View- Trigger - Stored Procedure - Contraints - Tsql kavramlarını kullanarak örnek bir veri tabanını sıfırdan oluşturmak

Language: TSQL - Size: 56.6 KB - Last synced at: 3 months ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 1

pavnis/SQL

Size: 1.29 MB - Last synced at: over 1 year ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

AyhamRatrout/Doctor_Who

This repository contains my implementation of a SQL Server Database which contains data (such as episode list, doctors list, enemies list, companions list, authors list, and much more) about the Doctor Who series. This database was created in accordance with the rules, requirements, and constraints set forth by this project and which can be found in this project's README file.

Language: TSQL - Size: 1.48 MB - Last synced at: 3 months ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

Dmnk28/sql_tablePartitioner

WORK IN PROGRESS: These Procedures are made to move tables with already existing data to different filegroups/files in a convenient way.

Language: TSQL - Size: 19.5 KB - Last synced at: about 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

srogers47/Automated-Reporting

Async data-mining Nasdaq ETL sitting on ms-sql-server. Connect to power-bi for automated reporting

Language: Python - Size: 2.1 MB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0

miguelhp373/Criando_Uma_Stored_Procedure_Com_TSQL

Diretório Criado Para Ensinar a Criar Uma Procedure com SQL Server

Language: TSQL - Size: 5.86 KB - Last synced at: 3 months ago - Pushed at: about 3 years ago - Stars: 0 - Forks: 0

MehrajLatifli/ShopDB-CRUD-with-ADO.Net

A database called ShopDB and its stored procedures are used to work with ADO.Net for CRUD operation in WPF Application

Language: C# - Size: 67.4 KB - Last synced at: 3 months ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

madcoderBubt/AspNetApi

The website for the client-side project link is given below.

Language: C# - Size: 14.6 KB - Last synced at: over 2 years ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

sisakat/dqtk

T-SQL Dynamic Query Toolkit

Language: TSQL - Size: 15.6 KB - Last synced at: almost 2 years ago - Pushed at: almost 4 years ago - Stars: 0 - Forks: 0

ranton1990/SQL-Backuphelper

Procedure that makes it easy to automatically restore Backups on SQL-Server.

Language: TSQL - Size: 2.93 KB - Last synced at: over 2 years ago - Pushed at: almost 4 years ago - Stars: 0 - Forks: 0

alexandrei64/TSQLhomework

This repository holds homework assignments I completed during my T-SQL learning path.

Language: TSQL - Size: 21.5 KB - Last synced at: over 1 year ago - Pushed at: about 4 years ago - Stars: 0 - Forks: 0

alexandrei64/TSQLproject

This is a capstone project written in TSQL.

Language: TSQL - Size: 105 KB - Last synced at: over 1 year ago - Pushed at: about 4 years ago - Stars: 0 - Forks: 0

ivan-novak/UEFA-Simulator

COURSE PROJECT: Programming and administration of MS SQL Server DBMS. - 2019

Language: TSQL - Size: 1.75 MB - Last synced at: almost 2 years ago - Pushed at: over 4 years ago - Stars: 0 - Forks: 0

barryhalper/T-SQL

Misc backup of T-SQL files and stored procedures

Language: TSQL - Size: 57.6 KB - Last synced at: 12 months ago - Pushed at: over 4 years ago - Stars: 0 - Forks: 0

coreywebber/SqlCronFunctions

These are a series of functions I use to interpret the CRON parameters and produce a table with their values.

Size: 28.3 KB - Last synced at: about 2 years ago - Pushed at: over 4 years ago - Stars: 0 - Forks: 0

zq99/titanic-dataset-analysis-sql-server

This repo is for the queries I have been using to explore the Titanic dataset using SQL Server.

Language: PLpgSQL - Size: 96.7 KB - Last synced at: over 2 years ago - Pushed at: almost 5 years ago - Stars: 0 - Forks: 1

alexovidiupopa/Databases

Implementation of a small chess database containing 1:N and M:N relationships, as well as speed testing and query optimisation using indexes.

Language: TSQL - Size: 15.6 KB - Last synced at: over 2 years ago - Pushed at: over 5 years ago - Stars: 0 - Forks: 0

llouislu/tsql-diff

Compare Difference In T-SQL Queries at Runtime

Language: TSQL - Size: 32.2 KB - Last synced at: almost 2 years ago - Pushed at: over 5 years ago - Stars: 0 - Forks: 0

alexhg128/GameProjectDB

TEC - TC1020 (Databases) - Database integration to unity video game

Language: C# - Size: 116 MB - Last synced at: over 2 years ago - Pushed at: over 5 years ago - Stars: 0 - Forks: 0

onurcanyilmaz/DerivedTableIntoTempTableQuery

With Derived table inserted Temporary Table Queries using MSSQLServer

Language: TSQL - Size: 11.7 KB - Last synced at: over 2 years ago - Pushed at: almost 6 years ago - Stars: 0 - Forks: 0

madereddy/spBusyProcess

spBusyProcess helps identify and kill long running SQL Queries

Size: 18.6 KB - Last synced at: about 2 years ago - Pushed at: almost 6 years ago - Stars: 0 - Forks: 0

qwe3804132/ssasCube_PersonalProj

An Personal SSAS cube for Study and Master my MDX skill

Size: 370 KB - Last synced at: over 2 years ago - Pushed at: about 6 years ago - Stars: 0 - Forks: 0