Microsoft’s SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from the Sybase SQL Server 4.x codebase and Transact-SQL dialect (t-sql), but it has forked significantly since then.
SQL Server is available in multiple versions (typically identified by release year), each of which are subdivided into editions to distinguish between product functionality. The latest released version is SQL Server 2019 which was released on November 4th, 2019.
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting
I chose 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data for analysis & visualization. The query editing was done in 'Microsoft SQL Server Management Studio' and the visualization part was using 'Microsoft Power BI'. Also for analysis, I used MS Excel and PowerBI's query tool.
A collection of cool and useful tools, procedures and scripts for the discerning DBA
Comprehensive training resources for SQL and Microsoft BI tools. Includes setup guides, installation videos, tutorials on data integration, transformation, architecture, visualization, and performance. Expand your data consulting skills with PowerBI, SSIS, SSAS, and beyond, with plans to cover AWS and Python for advanced use cases.
Implementation of ULID generator For Microsoft SQL Server
This repo is the home of various SQL-Server-Tools
sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.
Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse
Ce projet est une base de données relationnelle pour gérer les opérations d'une bibliothèque : auteurs, livres, membres et emprunts. Il inclut des fonctionnalités avancées comme procédures stockées, triggers et index pour une gestion optimisée.
Necmettin Erbakan University 3nd year Database Systems lecture notes and assignments.
Add-on to Ola Hallengren's maintenance solution, focusing on managing database file size growth and shrink.
Queries and reports to visualize your SQL data and transaction log page allocations. See which pages are reserved for which objects, and which pages are not used.
This procedure can be used to generate a CREATE TABLE script for a given table in SQL Server
SQL practice exercises using the Microsoft Northwind database
Manage your business rules in T-SQL
Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures
Implement a simple data warehouse to store Saklia data - Create data pipelines for extract, transform and load data from source to warehouse - Retrieve data in warehouse to explore and do several analysis
Created by Sybase, Ashton-Tate, and Microsoft.
Released 1989