Useful links, scripts, tools and best practice for Microsoft SQL Server Database
An ongoing & curated collection of awesome software libraries, learning tutorials, Useful links & scripts, tools, resources and cool stuff about Microsoft SQL Server
A collection of scripts to use with indexes in SQL Server
Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse
In this repository, you can find some stored procedures, triggers, views and t-sql examples with both their explanations and implementations.
This automation has been designed to eliminate manual efforts on Space Capacity ESC tickets where DBA has to add new data or log files on new volume, and restrict data or log files on old volume. Apart from this, this procedure can be used for variety of tasks related to capacity management.
About The most comprehensive SQL guide from a real-world expert! Learn everything from basics to advanced queries, optimizations, and real-world SQL
a data warehouse for an online course shop
This repository contains sql studies, stored procedures ,triggers, etc and sample databases.
Syracuse University, Masters of Applied Data Science - IST 722 Data Warehouse
SQL queries and resources for working with the Stack Overflow 10GB database provided by Brent Ozar.
This repository contains sql studies, stored procedures ,triggers, etc and sample databases.
This example shows how to use the SQL Server Temporal Tables with Entity Framework Core to create a Time Machine for our data
A PowerBI dashboard to explore the raw sales data for an online retailer of bicycles and bicycle components in order to obtain insights into its sales performance, customers, and products.
This Business Case was a project for my University for the module of Business intelligence and visualization about Data warehouses, Relational Databases and ETL.
🇫🇷 Travaux Pratiques en Système de Gestion de Base de Données avec SQL Server.
SQL Server database tips and tricks. Docker deployment, execution plan analytics, performance, managing locks, data modeling, DDL, DML, DQL, DTL, DCL and other topics about relational databases
Add a description, image, and links to the sql-server-database topic page so that developers can more easily learn about it.
To associate your repository with the sql-server-database topic, visit your repo's landing page and select "manage topics."