SQL-Articles

Tag: scripts

  • Get Azure Function AzureWebJobsDashboard Storage Usage Script

    Last week on the Twitter while checking I noticed a thread related to the Azure web job storage size. The issue is that the Azure storage used has grown tremendously, close to 2 TB. By default, this storage account is supposed to be used for storing checkpoints, trigger and metadata related to the functions, so […]

  • Batch script to deploy multiple SQL files

    I was working on a project where I’m supposed to deploy lots of SQL Server script files (.sql). It’s very tedious job either to manually execute or to write a batch script each time when the deployment moves to another environment. So I decided to write a batch script which should be dynamic in nature […]

  • Startup procedure to check SQL Server status when restarted

    I’ve written a startup procedure to check SQL Server status when the SQL Server gets restarted. Most of the time as a DBA when a Server gets rebooted or SQL Services is restarted we need to make sure everything is fine in SQL server to make sure SQL server is running healthy. Some companies will […]

  • Script to Check SQL Server Connectivity

    Use this VB script to check SQL Server connectivity. You can add N number of SQL Server instances to verify its status.

  • Attach all user databases

    I was doing an upgrade of one of our development servers to SQL Server 2008. To minimize the downtime I decided to attach all the user databases using script. Basically, I am attaching the db from the same location there were present earlier to being detached. Consider the following example, If I have a database […]