phil-factor Goto Github PK

adventureworks

It is about time we put this in source control

buildandfill

centralmanagementserverscripts

A collection of scripts that demonstrate the use of PowerShell with Central Management 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

converttopson

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

converttoyaml

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

customerssampledatabase

dacpacdetectchanges

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

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

distributionhistogram

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

flywayandadworks

flywaygithubdemo

flywaypubsdemo

flywayteamwork-pubs

foreach-databaseinservers

The sourcce code for an article about OPowershell and SMO

jsonsqlserverroutines

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

jsonupserttosqlserver

languagespoofing

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

pubsflywaymigration

Testing out Flyway

pubsrevival

Updating Pubs for a new generation

pubsrevived

scripting_routines

Various scripts that create database build scripts

sql-code-smells

sql-utility-routines

sqlclonefamily