Category Archives: Powershell

Python 101 – may be 100.01 :)

  While investigating a problem related to Python programs with open transactions I end up experimenting with Python today! It took a few hours to install Python, required libraries, execute first program and complete my actual investigation related to pyodbc … Continue reading

Posted in Powershell, Python, Uncategorized | Tagged , | Leave a comment

Capture ping results with time – ping test

This captures ping results along with time, adds to file and displays results on the window.

Posted in Powershell, Productivity | Tagged , , , , | Leave a comment

How to Point in time Restore Azure SQL Database after deleting the database

Azure SQL Database has feature to restore the database to point in time when the database is live. When we have to move the database to different Server we end up deleting the database from old server, we can not … Continue reading

Posted in Azure, Powershell, SQL, SQL Server, Uncategorized | Tagged , , , , | 2 Comments

catalog

Most frequently used articles AZURE – SQL – Frequently User SQL Commands: https://vijredblog.wordpress.com/2016/10/27/sql-commands-in-azure/ Azure – comonly used Powershell Commands: Frequently used Azure SQL Powershell Commands: https://vijredblog.wordpress.com/2017/07/27/frequently-used-azure-powershell-commands/

Posted in Azure, Powershell, SQL, Uncategorized | Tagged , | Leave a comment

Powershell Workflow for Runbooks, Inline Script

Powershell workflow is the best way to program parallel processing using Powershell and/or in Azure run books. Though the syntax is similar, there are few differences you need to be aware of. Start with below link when you create your … Continue reading

Posted in Azure, Powershell, Uncategorized | Tagged , , , , , , | Leave a comment

DBATools.IO – Powershell for SQL DBAs

DBATools.IO was one of the best things I started using in 2017 and I wanted to master this in 2018! https://dbatools.io/functions/ includes the list of all commands in dbatools module! Start using it if you have not started already.

Posted in Powershell, SQL, Uncategorized | Tagged , , | Leave a comment

Frequently used Azure powershell commands

Few of my frequently used powershell commands on Azure Ref: https://docs.microsoft.com/en-us/azure/search/search-manage-powershell

Posted in Azure, Powershell, Uncategorized | Tagged , , , | 1 Comment