• HOME
  • TSQL PODCASTS
  • BLOG
  • INSTRUCTORS
  • BOOK CODE and FREE STUFF
  • AMAZON BOOKS
    • TSQL Function Primer
    • TSQL Stored Procedure
    • TSQL CTE PRIMER
    • TSQL QueryPrimer
    • DBA Handbook - VOL 1
    • DBA Handbook - VOL 2
    • Data Quality Handbook
    • Data Modeling Handbook
    • Data Stewardship Guide
    • Data Governance Guide
    • SQL Server Triggers
  • More
    • HOME
    • TSQL PODCASTS
    • BLOG
    • INSTRUCTORS
    • BOOK CODE and FREE STUFF
    • AMAZON BOOKS
      • TSQL Function Primer
      • TSQL Stored Procedure
      • TSQL CTE PRIMER
      • TSQL QueryPrimer
      • DBA Handbook - VOL 1
      • DBA Handbook - VOL 2
      • Data Quality Handbook
      • Data Modeling Handbook
      • Data Stewardship Guide
      • Data Governance Guide
      • SQL Server Triggers
  • HOME
  • TSQL PODCASTS
  • BLOG
  • INSTRUCTORS
  • BOOK CODE and FREE STUFF
  • AMAZON BOOKS
    • TSQL Function Primer
    • TSQL Stored Procedure
    • TSQL CTE PRIMER
    • TSQL QueryPrimer
    • DBA Handbook - VOL 1
    • DBA Handbook - VOL 2
    • Data Quality Handbook
    • Data Modeling Handbook
    • Data Stewardship Guide
    • Data Governance Guide
    • SQL Server Triggers

Learning the SQL Server BI stack the Grumpy Way!

Learning the SQL Server BI stack the Grumpy Way!Learning the SQL Server BI stack the Grumpy Way!Learning the SQL Server BI stack the Grumpy Way!

YOUTUBE PODCAST SQL SCRIPTS

PODCAST 01 DEMO - NAVIGATING SSMS (txt)Download
PODCAST 02 DEMO - CREATING DATABASES (txt)Download
PODCAST 03 DEMO - CREATING TABLES (txt)Download
PODCAST 04 DEMO - CREATING VIEWS (txt)Download
PODCAST 05 DEMO - TSQL DML (txt)Download
PODCAST 06 DEMO - STRING FUNCTIONS (txt)Download
PODCAST 07 DEMO - DATE FUNCTIONS (txt)Download
PODCAST 09 DEMO - GROUP BY CLAUSE (txt)Download

YOUTUBE SQL Script Downloads

ADD TABLES TO DATABASES (txt)Download
CREATE A MINI CALENDAR (txt)Download
CREATE A CALENDAR (txt)Download
CREATE CUSTOMER DATABASE (txt)Download
CREATE CUSTOMER SALES DATABASE (txt)Download
CREATE HOBBY_SHOP DATABASE (txt)Download
CREATE HR DATABASE (txt)Download
CREATE INVENTORY DATABASE (txt)Download
CREATE ORGANIZATION DATABASE (txt)Download
CREATE TEST DATABASE (txt)Download
LOAD HOBBY_SHOP DATABASE (txt)Download
LOAD ORGANIZATION DATABASE ON SQLEXPRESS (txt)Download
LOAD ORGANIZATION DATABASE (txt)Download

Amazon Book Downloads

Downloads SQL scripts and appendices for Amazon Kindle books

Data Governance Handbook (zip)Download
TSQL Triggers (zip)Download
TSQL Query Primer (zip)Download
TSQL Function Primer (zip)Download
TSQL DBA Handbook Vol 2 (zip)Download
TSQL Stored Procedure (zip)Download
TSQL DBA Handbook - Vol 1 (zip)Download
Data Modeling Appendices (zip)Download
Data Quality Handbook V1 (zip)Download
TSQL CTE Primer (zip)Download
Data Stewardship Handbook (zip)Download

FREE DATA MODELS

Example industry data models and SQL DDL code to create the databases

DERIVATIVES (zip)Download
GLOBAL_INVENTORY (zip)Download
HFT_FINANCIAL_DB (zip)Download
SERVICE_DESK (zip)Download
TELCOM_CRM (zip)Download
TRUCKING_LOGISTICS (zip)Download

Introduction to SQL Server SSMS

Lesson files for Introduction to SQL Server SSMS

SSMS Course Files (zip)Download

Copyright © 2026 grumpy old it guy - All Rights Reserved.

Powered by

  • HOME
  • TSQL PODCASTS
  • PRIVACY POLICY
  • BOOK CODE and FREE STUFF
  • Terms and Conditions