🛠️ T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.

A big collection of SQL Server Queries and documeantations to fix your SQL Server's bottle neck

SQL Server monitoring tool based on PowerShell v3 and TSQL scripts only

SQL Server scripts to help you in your daily life

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

This is a t-sql scripts repository. From complex to simple scripts. All reusable and multipurpose

SQL

postgres数据库使用，存储过程，函数，大数据量查询优化，数据库主从高可用，备份还原，日志收缩，性能监控，数据库作业，POST，GET，HTTP，xml，json

TSQL Stored Procedure which gets a ClientID and a CreditCardNo passed by parameters, encrypts this last one with a random key and it insert or update in a table, depending wheter already exists or not.

A repository for storing my some SQL exercises (sql-ex).

tsqlt-preinstalled on SQL Server

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

This is a repository where I stored all the HackerRank SQL Practices

Generic configuration script applied post-installation.

Sql script and batch file used to copy SSIS packages from one server to a new one.

Useful T-SQL scripts I often use

Sometimes it could be useful check info not with the Azure portal but via code, with tools like SQL Server Management Studio, Azure Data Studio, VS Code, ... Here you can find some queries to retrieve useful information related to Azure SQL Databases.

Databases

PL-SQL and T-SQL Exercises

PostgreSQL and SSMS (CTEs, views, window functions, subqueries, joins, procedures, functions, triggers etc); EXCEL (pivot tables, vlookup, descriptive statistics, dispersion, percentiles, quartiles, hypothesis tests, t-, z-tests).