Skip to content

@sqlsunday sqlsunday.com

Change the repository type filter

All

    Repositories list

    15 repositories

    • imdb-to-sqlserver

      Public
      Create your own SQL Server database from the IMDB dataset
      TSQL
      •1•8•0•0•Updated Nov 17, 2024Nov 17, 2024

    • presentations

      Public
      Slides and demo materials for my presentations
      TSQL
      •0•2•0•0•Updated Nov 2, 2024Nov 2, 2024

    • sqlagent-proxy-procedures

      Public
      A method for creating proxy stored procedures for SQL Server Agent jobs
      PLpgSQL
      •0•0•0•0•Updated Sep 10, 2024Sep 10, 2024

    • t-sql-math

      Public
      Practical T-SQL math functions
      PLpgSQL
      •0•3•0•0•Updated Aug 3, 2024Aug 3, 2024

    • saturday-checklist

      Public
      A handy checklist for Data Saturday/SQL Saturday organizers
      1•5•0•0•Updated Jul 8, 2024Jul 8, 2024

    • sp_ctrl3

      Public
      Drop-in replacement for SQL Server's sp_help procedure.
      PLpgSQL
      •1•13•7•0•Updated May 5, 2024May 5, 2024

    • sp_help_permissions

      Public
      PLpgSQL
      •5•12•0•0•Updated Mar 27, 2024Mar 27, 2024

    • script-dbobjects

      Public
      PowerShell script to generate database object files and directories
      PowerShell
      •1•1•0•0•Updated Jul 21, 2021Jul 21, 2021

    • shock-absorber

      Public
      A Hekaton-based shock absorber pattern to ingest bursty/high-throughput data flows
      PLpgSQL
      •2•5•0•0•Updated Jul 15, 2021Jul 15, 2021

    • querystore

      Public
      A simple view to extract basic metrics from the QueryStore
      0•1•0•0•Updated Jun 1, 2021Jun 1, 2021

    • ag-sync

      Public
      Utilities to synchronize server-level objects (currently just logins) across availability groups.
      PLpgSQL
      •12•14•1•0•Updated Jan 28, 2021Jan 28, 2021

    • calendar

      Public
      A comprehensive set of calendar table value functions, for use in calendar dimensions or other applications.
      PLpgSQL
      •5•14•1•0•Updated Sep 10, 2020Sep 10, 2020

    • session

      Public
      A script that displays currently active sessions along with server and session information
      PLpgSQL
      •2•7•1•0•Updated Jun 23, 2020Jun 23, 2020

    • azure-cost

      Public
      Azure automation script to alert you on Slack when a resource cost runs away
      PowerShell
      •0•3•0•0•Updated Jun 23, 2020Jun 23, 2020

    • recurringdates

      Public
      A T-SQL function to calculate recurring dates
      PLpgSQL
      •4•4•0•0•Updated Jun 23, 2020Jun 23, 2020