20 Oct

Tech-Meet by Delhi User Group | 01-Nov-2014 | Gurgaon

Hi friends!

DElhi User Group1Delhi User Group presents Tech-Meet, your chance to learn Hot technologies from Industry experts.
The half-day free event for professionals in Delhi NCR includes a great line-up of industry-recognized speakers.

The event will start at sharp 9:30 AM and security takes time so please be on time to skip the line and grab the front seat. Winking smile 

I’ll be speaking on Backup and Restore improvements in SQL Server 2014.

REGISTER | Registration required | Limited seats only

Refer the Image below for the complete agenda:



See you at the event.


Sarabpreet Singh

4 Nov

MVP Community Day \ PowerShell Day 9th Nov’2013 | Gurgaon

Dear Friends,Community_Day_9_nov_2013_Sarab

This Saturday (9th Nov’2013) South East Asia MVP Community is celebrating MVP Community Day, a day dedicated to Knowledge sharing & Learning.


On this very day New Delhi PowerShell User Group is organizing an event in Gurgaon, and luckily my session “Managing SQL Server using PowerShell” has been selected. Aman Dhally (PowerShell MVP) is also taking a session on Managing Event Logs using PowerShell.

This session is for all those who want to learn PowerShell and want to know more about its integration with Event Logs etc. Please use the below link to register for the event.

Register here : https://www.eventbrite.ie/event/9156263631

Session Details
Time Session Topic Presenter
9:30 – 10 AM Start of Registrations  
10  – 11 AM Managing SQL Server using PowerShell Sarabpreet Singh Anand
11 -11:15 AM Tea Break  
11:15 – 12:15 PM Managing Windows Event Logs using PowerShell Aman Dhally
MVP PowerShell)


See you at the event.

Sarabpreet Singh Anand & Aman Dhally

3 Jun

MS Webcast | Lunch Time – How to Monitor SQL Servers using Powershell – Part 1 | 26-June-2013

I’ll be delivering another webcast in Lunch Time series and this time its on How to Monitor SQL Servers using Powershell – Part 1. Join this webcast to learn how to create your own monitoring solution for SQL Servers using Powershell.

About the Session: Monitoring and Alerting is a vital process of every IT Pro and if you are managing more than just a couple of SQL Servers it becomes indispensable. This webcast will guide you and explain the ted-bits about creating your own Monitoring Solution. This will work as a Ice-Breaker session for those who don’t know much about PowerShell and how to use PowerShell to create your own customized monitoring\alerting solution.

To Register visit: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032555479&Culture=en-IN&community=0


12 Apr

Delhi User Group Meet | 20-April-2013 | Gurgaon

Hi there!

For the month of April, Delhi User Group brings you a chance to learn enterprise-grade Microsoft technologies like PowerShell and SQL Server.
The half-day free event for professionals in Delhi NCR includes a great line-up of industry-recognized speakers.

I’ll be speaking on Nuts and Bolts of Security in SQL Server 2012.

Registration required | Limited seats only

To read the complete agenda – click on the image below:


8 Jul

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 need to pass a value to a parameter which contains special characters, for this purpose you can use any of these it doesn’t make any difference, both will let you do the same thing.


In the above example, I used the quotes to let interpreter treat both words as a single string, a common example with File Paths and both quotes worked.

Back Quote Character ( ` ) aka Back tick

This is usually the upper leftmost key below escape. This comes to rescue the situations where you want to quote a single character.


Variable Expansion

Double Quote has a unique use\feature which is not there with single quote, if the string enclosed in double quotes contains a variable reference starting with a “$”, it will be replaced or expanded by the string representation of the value stored in the variable. It will be more clear by the following example:


As you can see in the example above when we enclosed the variable $a in single quotes the Write-Host Command treated it just as a simple string but when we enclosed the variable $a in double quotes both commands or I should say cmdlets expanded the value which was there in the variable and used it while executing the cmdlet.

How to Suppress Expansion?

Now let’s say we want to suppress expansion at one place for a single variable but not for rest of the variables in the output to achieve this we need to again use the back quote or back tick. Let’s see how to do this.


In the above example see at the first occurrence of $a and $b I specifically used the back tick so that the interpreter doesn’t expand & replace the variable values.

New Line Character ( `n )

In case you want to move a part of output to a new line you can use this special sequence. You can achieve this with a back tick and n. you can place this in either single or double quotes. Please refer the example below:


Horizontal Tab ( `t )

If you want to get a horizontal tab in your output you can use the Horizontal Tab special Sequence. Please refer the example below:


Sarabpreet Singh Anand

6 Jul

SQL with its own Powershell?

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 multiple Snappins created for SQL Server with its own custom cmdlets (pronounced as command-lets). SQLPS is a great tool to Administer, Monitor or Automate your SQL tasks provided you don’t go beyond SQL, means you can’t add other snappins to SQLPS. This makes it a “CLOSED” shell.

SQLPS uses two Snappins SqlServerCmdletSnapin100 & SqlServerProviderSnapin100. We can use Get-PSSnapins cmdlet to see all loaded\configured snapppins.

If you’ve any exposure to Linux or command prompt, Learning Powershell is very easy. Microsoft did a fabulous job and tried hard to provide the same look and feel + your (few) favorite commands are also compatible in powershell.

Yes, that means if you are coming from Windows background and love to use command prompt you can adopt powershell and start using just like another command prompt with commands like dir, cd and the same is true for Linux experts since powershell supports ls, man etc. Microsoft did this using Aliases Dir, ls are Alias for Get-ChildItem.

Sarabpreet Singh Anand

5 Jul

Powershell for SQL Server

Hi Guys,

I am going to start a new blog on “Powershell for SQL Server”.


Enjoy Smile

Sarabpreet Singh

25 Oct

SQL Server Day – Bangalore, 15 October 2011

SQLServerGeeks.com delivered its 3rd SQL Server Day event in Bangalore, the Silicon Valley of India. Sudhir Rawat from Microsoft featured in our events for the 2nd time and delivered a rocking session on Denali Business Intelligence. This was followed by Sarabpreet Singh delivering a session in PowerShell for SQL Server. His Powershell expertise was much appreciated in SSG’s last event in Gurgaon and thus, he carried on with the form. Amit Bansal delivered the 3rd and final session on the day de-mystifying a few things about Locking Architecture in SQL Server. We had a fun-filled day with the 80+ audience really participating so well. Our consistent turn out shows the popularity of our eventsSmile.  We cherish organizing such events and will continue to do so in the future for SQL Server community.


More pics on http://www.FaceBook.com/SQLServerGeeks