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.
#Awesome#Useful links, scripts, tools and best practice for Microsoft SQL Server Database
Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.
Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting
SQL Server Performance Monitor
#安全# The most comprehensive SQL guide from a real-world expert! Learn everything from basics to advanced queries, optimizations, and real-world SQL
A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.
Babelfish for PostgreSQL provides the capability for PostgreSQL to work with applications written for Microsoft SQL Server. Babelfish understands the SQL Server wire-protocol and T-SQL, the Microsoft ...
A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.
Инструменты обслуживания и разработки для Microsoft SQL Server, а также другие интересности
Ferramentas e Scripts úteis para DBAs e Dev SQL
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
Database Project with generic procedures to consume API through GET/POST methods.
Data Analyst portfolio project that deals with business KPIs, cleaning and transforming data and visualizing it to create a dashboard. The tools used are: SQL Server, T-SQL, Excel and Power BI.
This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.
a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.
Repository for lab exercises and instructions for Microsoft DP-300 learning content