RandyKnight · Founder and Principal Consultant

Comments

  • I use ChatGPT on my desktop as a search engine replacement almost exclusively. It's pretty dang good and reminding me of syntax or how to do a certain thing. And I have CoPilot in Azure Data Studio which does reasonably well. My take is that these tools are an awesome force multiplier when used appropriately.
    in GenAI, writing T-SQL and Automation Comment by RandyKnight April 2024
  • This is SQL Server specific. Type Native Backups vs. VSS Snapshot based unless the database is too large to make native backups possible. Schedule Weekly FULL, Daily DIFF on the other 6 days, HOURLY Transaction Logs Target S3/Azure Blob if in the public cloud. If on-prem, written to a local file share (off server usually)…
    in Database Backups (& Restores) Best Practices Comment by RandyKnight January 2024
Avatar