Pinned Repositories
ag-sync
Utilities to synchronize server-level objects (currently just logins) across availability groups.
calendar
A comprehensive set of calendar table value functions, for use in calendar dimensions or other applications.
imdb-to-sqlserver
Create your own SQL Server database from the IMDB dataset
presentations
Slides and demo materials for my presentations
recurringdates
A T-SQL function to calculate recurring dates
saturday-checklist
A handy checklist for Data Saturday/SQL Saturday organizers
session
A script that displays currently active sessions along with server and session information
shock-absorber
A Hekaton-based shock absorber pattern to ingest bursty/high-throughput data flows
sp_ctrl3
Drop-in replacement for SQL Server's sp_help procedure.
sp_help_permissions
sqlsunday.com's Repositories
sqlsunday/ag-sync
Utilities to synchronize server-level objects (currently just logins) across availability groups.
sqlsunday/calendar
A comprehensive set of calendar table value functions, for use in calendar dimensions or other applications.
sqlsunday/sp_ctrl3
Drop-in replacement for SQL Server's sp_help procedure.
sqlsunday/sp_help_permissions
sqlsunday/session
A script that displays currently active sessions along with server and session information
sqlsunday/imdb-to-sqlserver
Create your own SQL Server database from the IMDB dataset
sqlsunday/shock-absorber
A Hekaton-based shock absorber pattern to ingest bursty/high-throughput data flows
sqlsunday/recurringdates
A T-SQL function to calculate recurring dates
sqlsunday/saturday-checklist
A handy checklist for Data Saturday/SQL Saturday organizers
sqlsunday/azure-cost
Azure automation script to alert you on Slack when a resource cost runs away
sqlsunday/t-sql-math
Practical T-SQL math functions
sqlsunday/querystore
A simple view to extract basic metrics from the QueryStore
sqlsunday/script-dbobjects
PowerShell script to generate database object files and directories
sqlsunday/presentations
Slides and demo materials for my presentations
sqlsunday/sqlagent-proxy-procedures
A method for creating proxy stored procedures for SQL Server Agent jobs