kevinmartintech Goto Github PK

date-time-number-dimension

SQL Server T-SQL scripts to create the data warehouse dimensions or business intelligence tables and load the tables with data.

just-the-docs

A modern, high customizable, responsive Jekyll theme for documention with built-in search.

kevinmartintech

sp_crudgen

sp_CRUDGen is a free open-source SQL Server stored procedure that generates stored procedures for you based on your tables and metadata like foreign keys and data types. The generated stored procedure code utilizes the SQL Server community best practices.

sp_develop

sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.

sql-docs

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc.

sql-server-database-development-best-practices

A novella size of SQL Server database best practices, all for free.

sql-server-delete-data-or-drop-objects

This script allows the deletion of SQL Server table data without worrying about constraints by deleting in a specific table order. The script also allows you to delete any or all the SQL Server objects like tables, views, stored procedures, functions, user data types, sequences, and synonyms.

sql-server-temporal-table-changes-get

This stored procedure exists to return results of column values that have changed from a Temporal table (also known as system-versioned temporal table). It generates dynamic SQL and either executes it or outputs it with the debug parameter.