Phil-Factor/JSONSQLServerRoutines

Stars
44
Rank 634,578 (Top 13 %)
Language TSQL
Created about 6 years ago
Updated about 4 years ago

Phil-Factor/JSONSQLServerRoutines

Phil-Factor

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Various stored procedures that are used to import and export JSON Data

PSYaml

A Powershell module to convert YAML documents to and from PowerShell objects

PowerShell-Utility-Cmdlets

SQLMetaPhone

A SQL implementation of the original MetaPhone soundex algorithm

ParseJSON

an update to a published routine

PubsAndFlyway

This is all the code, both SQL and PowerShell to demonstrate how to use various aspects of Flyway. The articles are linked to in the ReadMe file. There are also explanations about each file

DacPacDetectChanges

Sample PowerShell routine that daves dacpacs of all the databases of all the registered SQL servers

SQLCodeSmells

The ASCIIDOCS version of the book

FlywayTeamwork-Pubs

DistributionHistogram

This is a SQL Table-Valued Function that allows you to peek at the way that data is distributed in a table

ConvertToPSON

To accompany the article 'Getting Data Into and Out of PowerShell Objects'

TheGloopSQLServerDatabaseDocumenter

the Gloop: SQL Queries that generate JSON Documentation files

JsonUpsertToSQLServer

DeployViaToolBeltAndClone

Deploy a database from object-level scripts and create a whole set of clones on a variety of servers

CompileTableComments

A repository of code to compile all the block comments and end of line comments into extended properties of the table or its components in a live SQL Server Database

ConvertToYAML

To acompany article 'Getting Data Into and Out of PowerShell Objects'

Database_Comparison_And_Sync

PowerShell wrapping of SQL Compare and SQL Data Compare

SQLCloneFamily

CentralManagementServerScripts

A collection of scripts that demonstrate the use of PowerShell with Central Management Servers.

LanguageSpoofing

Foreach-DatabaseInServers

The sourcce code for an article about OPowershell and SMO

The_SQL_Prettifier

An old prohject that made HTML rendering of SQL code

SQL-Utility-Routines

TestOutConstraintsInSQLServer

A group of files for a scripted system for checking SQL Server data before enabling constraints when deploying a database.

FlywayAndAdworks

TextAdventureWorks

Text version of adventureworks

Scripting_Routines

Various scripts that create database build scripts

FlywayGithubDemo