Skip to content

Glenn Pepper

SQL Server Database Administration

Primary Menu
  • Home
  • About
  • Resources
    • GitHub
    • Links
    • Downloads
  • Music
  • Contact

VARIABLES

SQLCMD and SQL Variables

Posted on 11th September 201511th September 2018 by GPepper

I recently worked on a little project that involved outputting some workflow user stats from a database every hour. The scripts must produce an output file that will be transferred via SFTP to a separate database in another domain. The main bulk of the process was contained within a stored Continue Reading

Posted In T-SQLTagged In SQLCMD, T-SQL, VARIABLES

Recent

  • Troubleshooting Performance Problems
  • Cluster Quorum PowerShell Commands
  • Creating Fake Data for Testing
  • SSRS Database Migration – Cannot View Subscriptions
  • Automating SQL Installs

Tag Cloud

AlwaysOn Automation Availability Groups Backups BATCH UPDATES Best Practice Best Practices BULK IMPORT Clusters Communication Corruption Disaster Recovery DR Email Execution Plans Foreign Keys HTML Indexes Interviews Migration Monitoring Music Off Topic OPENROWSET PHP Post-Rock PowerShell Processing Quorum Random Rant Reference Restores sp_whoisactive SQL Agent SQLCMD SQL Installations sqlps SQL Security SQL Server SQL Server 2012 T-SQL Troubleshooting UPDATE VARIABLES

Categories

  • Always On Availability Groups
  • Automation
  • Azure
  • Best Practices
  • Disaster Recovery
  • Maintenance
  • Monitoring
  • Music
  • Off-Topic
  • PowerShell
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • T-SQL
  • Troubleshooting
  • Uncategorised
Copyright All rights reserved | Theme: Flash Blog by Unitedtheme.