Pinned Repositories
DacPacDetectChanges
Sample PowerShell routine that daves dacpacs of all the databases of all the registered SQL servers
FlywayTeamwork-Pubs
JSONSQLServerRoutines
Various stored procedures that are used to import and export JSON Data
ParseJSON
an update to a published routine
PowerShell-Utility-Cmdlets
PSYaml
A Powershell module to convert YAML documents to and from PowerShell objects
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
SQL-Utility-Routines
SQLCodeSmells
The ASCIIDOCS version of the book
SQLMetaPhone
A SQL implementation of the original MetaPhone soundex algorithm
Phil-Factor's Repositories
Phil-Factor/PSYaml
A Powershell module to convert YAML documents to and from PowerShell objects
Phil-Factor/PowerShell-Utility-Cmdlets
Phil-Factor/JSONSQLServerRoutines
Various stored procedures that are used to import and export JSON Data
Phil-Factor/SQLMetaPhone
A SQL implementation of the original MetaPhone soundex algorithm
Phil-Factor/ParseJSON
an update to a published routine
Phil-Factor/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
Phil-Factor/FlywayTeamwork-Pubs
Phil-Factor/SQLCodeSmells
The ASCIIDOCS version of the book
Phil-Factor/DistributionHistogram
This is a SQL Table-Valued Function that allows you to peek at the way that data is distributed in a table
Phil-Factor/ConvertToPSON
To accompany the article 'Getting Data Into and Out of PowerShell Objects'
Phil-Factor/JsonUpsertToSQLServer
Phil-Factor/TheGloopSQLServerDatabaseDocumenter
the Gloop: SQL Queries that generate JSON Documentation files
Phil-Factor/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
Phil-Factor/ConvertToYAML
To acompany article 'Getting Data Into and Out of PowerShell Objects'
Phil-Factor/DeployViaToolBeltAndClone
Deploy a database from object-level scripts and create a whole set of clones on a variety of servers
Phil-Factor/Database_Comparison_And_Sync
PowerShell wrapping of SQL Compare and SQL Data Compare
Phil-Factor/LanguageSpoofing
Phil-Factor/SQL-Utility-Routines
Phil-Factor/SQLCloneFamily
Phil-Factor/The_SQL_Prettifier
An old prohject that made HTML rendering of SQL code
Phil-Factor/FlywayAndAdworks
Phil-Factor/FlywayGithubDemo
Phil-Factor/TestOutConstraintsInSQLServer
A group of files for a scripted system for checking SQL Server data before enabling constraints when deploying a database.
Phil-Factor/AdventureWorks
It is about time we put this in source control
Phil-Factor/BuildAndFill
Phil-Factor/CustomersSampleDatabase
Phil-Factor/FlywayPubsDemo
Phil-Factor/PubsFlywayMigration
Testing out Flyway
Phil-Factor/PubsRevival
Updating Pubs for a new generation
Phil-Factor/PubsRevived