tonylrosa

AI Learning for Technical Roles: Claude & Applied GenAI For architects, engineers, and developers working with AI solutions, the following resources provide practical, hands-on learning to accelerate real-world implementation:

Core Foundations (Start Here) Establish a baseline in LLM concepts and AI fluency:

Claude 101 https://anthropic.skilljar.com/claude-101 AI Fluency: Framework & Foundations

tonylrosa

Moving the log ship secondary database

I had a challenge recently to move a very large log shipping replica to a new sql server, Without a access to a backup/diff set and only the shipped transaction logs, here is how I did it. Tested on SQL Server versions 2017, 2019. Ingredients - source secondary database, new/existing destination secondary server for the replica database

1. Create an empty database which mimics the file names and paths for the database you are trying to deploy
2. Post a small transaction log commit; table add, etc
3. Set the new database to "Standby/read only" by capturing a backup and then restoring the backup, to standby no recovery tail the trans log to a backup file

tonylrosa

PowerShell Commands

Sanity check (i.e., change term window size)

mode con:cols=150 lines=50

Set execution policy

Set-ExecutionPolicy -ExecutionPolicy RemoteSigned

Unset execution policy

Set-ExecutionPolicy -Scope CurrentUser -ExecutionPolicy Undefined