Category: Scripts

  • dbfs init script – depreciated – databricks

    Starting from 1st of April 2024 dbfs init scrips are depreciated. They do provide an option to extend this function until end of September 2024. In any case its the customer responsibility to migrate out of dbfa init scripts which are ow called as legacy init script. The other alternate approach is to host the…

  • 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 (Version 2)

    I took very long break to keep the site up to date with my learning. Few years back I wrote an article to deploy multiple scripts using batch files. Refer https://sql-articles.com/scripts/batch-script-to-deploy-multiple-sql-files/ for the older version in command prompt. Thanks for all the users and lot of comments for improvements.

  • Backup Report

    I was working on one the project and they were looking for a backup report which should specify whether it’s physical or logical and few more details. Whatever data I fetched looks good and I felt the same can be helpful for you guys to pull it as a report. If you need any more…

  • Identify Orphan Users in All the databases

    There are lot of scripts available in the internet to find orphan users across the database. This will be my version fo script to find out orphan users in all the databases excluding system databases.