-
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
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
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)
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)
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)
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.…