PowerShell

Powershell to Automate Reindexing on Azure SQL DB

by

I was working on Azure SQL DB and got the task of running reindexing over several Azure SQL DB… I thought of why not automating it instead of running the script over the Azure SQL dbs one by one …

PowerShell to export data from a SQL Server table to csv in chunk of 15 days

by

A client had a table which was storing data since 11 years, and he wanted to export all that data into csv files in a chunk of 15 days data per csv file. So I developed a PowerShell script to do the same. Hope it helps in different scenarios.

PowerShell Script to get\download latest SQL backup file from S3 bucket

by

Introduction: In today’s data-driven world, businesses rely heavily on robust database management systems to ensure the integrity and availability of their valuable information. As part of this process, regular backups are crucial to safeguard data against unforeseen events. Recently, we received a customer request to download the latest SQL backup file from their S3 bucket. … Read more

PowerShell – Basics Concepts and Variables

by

In this series, we will learn basics of PowerShell. This Blog will focus on some of the basic terminology and how we can work with Variables in PowerShell. Introduction to PowerShell PowerShell was introduced with Windows 2008/R2. Since then, many versions of PowerShell have launched and with every new version, new features have been introduced. … Read more