Come see my inaugural presentation at the Lexington PASS User Group meeting, Tuesday, Nov 13th, at 6:30 PM at the Blue Stallion Brewing Co.
Azure Data Studio [pptx 6MB]
Presenting at the SQL Server PASS Detroit User Group in November
In or around Detroit? Come see my Getting Started with Machine Learning session at the Detroit PASS User Group, Thursday, November 8th at 6 PM.
Power Point [8MB]
Demo [225KB]
SQL Saturday Denver 2018
Come see my presentation on Machine Learning Server for SQL Server at SQL Saturday Denver
Third times the charm…back at SQL Saturday Indy and Louisville three years in a row!
Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my session on Getting Started with Machine Learning
Backup VisualSVN using PowerShell
Quick and easy backup for VisualSVN. Wraps the svnadmin.exe and performs a hotcopy of all repositories in the $source_path, dumping them to the $backup_path
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
param ( [string]$backup_path = $(throw "backup_path is required"), [string]$source_path = $(throw "source_path is required"), [string]$svnadmin = "C:\Program Files (x86)\VisualSVN Server\bin\svnadmin.exe" ) # Validate paths exist if (!(Test-Path $backup_path -PathType Container)) { Write-Host "-backup_path $backup_path does not exist" exit -1 } if (!(Test-Path $source_path -PathType Container)) { Write-Host "-source_path $source_path does not exist" exit -1 } if (!(Test-Path $svnadmin -PathType Leaf)) { Write-Host "-svnadmin $svnadmin does not exist" exit -1 } # Root user/non-repository data $files = Get-ChildItem $source_path | Where {!$_.PsIsContainer} | Select-Object Name foreach ($file in $files) { Copy-Item (Join-Path $source_path $file.Name) (Join-Path $backup_path $file.Name) } # List of repository names (sub-directories under source path $repositories = Dir $source_path | Where {$_.mode -match "d"} | Select name ForEach ($repo in $repositories) { Write-Host $repo.Name # Remove existing backup directory for the repository if (Test-Path (Join-Path $backup_path $repo.Name)) { Remove-Item -path (Join-Path $backup_path $repo.Name) -recurse -force } # Perform hot copy & $svnadmin "hotcopy" (Join-Path $source_path $repo.Name) (Join-Path $backup_path $repo.Name) } |
SQL Saturday Wheeling 2018
Third time in a month, I will be presenting Machine Learning Server, this time at SQL Saturday Wheeling
Machine Learning Server at the CBusPass User Group
Come out Thursday, April 12 to learn how to leverage Microsoft Machine Learning Server.
Machine Learning Server
HopATopBikeShop BACPAC and Demo Scripts
SQL Saturday Madison 2018
Come out to see how to leverage Microsoft Machine Learning Server
Back at SQL Saturday Louisville and Indy
Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my SQL Server 2017 (Linux and Beyond) and Stretch Database and Managed Backups
SQL Saturday Chattanooga 2017
Second of the year, I will be presenting at SQL Saturday Chattanooga 2017. Come see my SQL Server 2017 (Linux and Beyond) session