This directory has mishmash of different items, ranging from tips and tricks, my writings on various database topics, and a few Azure end to end demos I have created.
Many of these items are solutions to everyday problems that I encounter in my daily SQL activities. Feel free to rummage around. I've tried my best to include detailed yet brief instructions for each of my scripts.
⌨️ All SQL is written in Microsoft SQL Server T-SQL, unless otherwise noted.
The items in this directory can be grouped into three categories:
::point_right: Database Writings
- Advanced SQL Joins:
- Behavior of Nulls
👉 Cloud Demos
- Databricks Hive Demo
- Data Factory Metadata Demo
👉 Utility Scripts
- Calendar Table
- Create Constraints Temp Table
- Data Profiling
- Excel Concatenation Formula Generator
- Pivoting Data
- Subtracting Two Dates
- Table Validation
📫 If you find any inaccuracies, misspellings, bugs, dead links, etc. please report an issue! No detail is too small, and I appreciate all the help.
😄 Happy coding!
I hope you find this repository to be useful and informative and I welcome any new puzzles or tips and tricks you may have. I also have a Wordpress site where you can find my data analytics projects, Python puzzles, and blog.