Discover @Phil-Factor Open Source projects

Phil Factor (@Phil-Factor)

Phil-Factor

Stars
296
Global Rank 87,583 (Top 4 %)
Followers 71
Following 3
Registered almost 13 years ago
Most used languages

PowerShell
50.0 %

TSQL 37.5 %

SQLPL 4.2 %

PLSQL 4.2 %

HTML
4.2 %
Location 🇬🇧 United Kingdom
Country Total Rank 4,624
Country Ranking

SQLPL 1

TSQL 6

PLSQL 9

PowerShell
36

HTML
1,717

PSYaml

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

PowerShell-Utility-Cmdlets

JSONSQLServerRoutines

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

SQLMetaPhone

A SQL implementation of the original MetaPhone soundex algorithm

ParseJSON

an update to a published routine

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

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

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'

JsonUpsertToSQLServer

TheGloopSQLServerDatabaseDocumenter

the Gloop: SQL Queries that generate JSON Documentation files

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

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

SQLCloneFamily

CentralManagementServerScripts

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

Foreach-DatabaseInServers

The sourcce code for an article about OPowershell and SMO

TestOutConstraintsInSQLServer

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

FlywayAndAdworks

LanguageSpoofing

The_SQL_Prettifier

An old prohject that made HTML rendering of SQL code

TextAdventureWorks

Text version of adventureworks

SQL-Utility-Routines

Scripting_Routines

Various scripts that create database build scripts

FlywayGithubDemo