Category: PowerShell

  • Backup of OLAP Database using Powershell

    Backup of OLAP Database using Powershell

    In this article I would like to explain another method to take the backup of OLAP databases via PowerShell. It will help out to take the backup of multiple OLAP databases with a specified retention period. In Tsql, XMLA function is applied however it is a bit puzzling to initiate the similar process for more than…

  • PowerShell : Copy a table from one server to another

    PowerShell : Copy a table from one server to another

    In general, a DBA like us gets requests to copy a table data from one SQL Server instance to another. In that case, a DBA first sees the amount of data present in the table and then he decides a method to transfer. Normally, a DBA selects Import Export method or SSIS and of course that is a suggested way to transfer data…

  • Learn Powershell with Vimal Lohani

    Learn Powershell with Vimal Lohani

    Vimal Lohani sharing his knowledge and experience of Powershell in an exclusive series “Introduction to Windows PowerShell” SN Topic Description Posted On 1 Introduction to Windows PowerShell (Part1) Windows PowerShell is a configuration management framework.. June 12, 2015 2 Introduction to Windows PowerShell (Part2) In this session, We will learn how you can control the result.. June…

  • Introduction to Windows PowerShell (Part3)

    Introduction to Windows PowerShell (Part3)

    Hi guys, I am sorry for late due to busy work schedule. But now i am here to fulfill my promise – Today we will discuss about PowerShell scripts & there execution- If you are new to PowerShell Please read previous blogs- Introduction to Windows PowerShell (Part 1) Introduction to Windows PowerShell (Part 2) Lets…

  • Introduction to Windows PowerShell (Part2)

    Introduction to Windows PowerShell (Part2)

    In this session, We will learn how you can control the result or output of command prompt & will also learn few more commands- If you are new to PowerShell, Please read previous blog Introduction to Windows PowerShell (Part1) You can start from command prompt or from PowerShell- Now Control the result of cmd prompt-  …

  • Introduction to Windows PowerShell (Part1)

    Introduction to Windows PowerShell (Part1)

    Windows PowerShell is a configuration management framework to perform administrative tasks.This tool is developed by Microsoft & available from 2006.This is one of the best tool for SQL DBA’s.It is a command line shell and associated scripting language. There are so many sites availabe giving knowledge on powershell, I will not go on theory part.…