Jul 142012
 
Where are my system databases?

Hi Friends, In last post, we saw that we can very easily use powershell to connect to SQL Server instance and see all the available databases (http://www.sarabpreet.com/?p=288), but by default powershell maintains security and hide all system level databases. Now the question arises how to list\view system databases in powershell. Well to do this, all [Read More]

Jul 132012
 
How to Connect to SQL Server using Powershell

Hi Friends, In this blog I’ll show you how to connect to SQL Server using Powershell Step-by-Step. There are basically two ways to connect to SQL Server, A. Using sqlps utility from Powershell.exe B. Using SSMS context menu option   Let’s review both: 1. Go to command prompt\cmd and type Powershell.exe & press enter. This [Read More]

Jul 082012
 
Quotes in Powershell

In General Quotes are considered to be there just to let interpreter know that the value enclosed within quotes should be treated as a single string. But in reality there are many other uses and types of quotes supported by Powershell. The two types of Quotes are Single Quotes and Double Quotes. Let’s say we [Read More]

Jul 062012
 

SMO is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. SQL Server Replication Management Objects (RMO) is a collection of objects that encapsulates SQL Server replication management. SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server. You can use SMO to [Read More]

Jul 062012
 

SQL Server 2008 and powershell are strongly integrated. In fact, SQL Server 2008 comes with its own Powershell. Microsoft SQL Server Powershell also known as SQLPS is basically a custom shell built to be used just for SQL Server. SQLPS comes preconfigured with all SQL Server extensions. Technically speaking SQLPS is a mini-custom-powershell which has [Read More]