The KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent tables. Therefore, if changes to temporary tables are causing many recompilations, this query hint can be used.

Disable xp_cmdshell unless it is absolutely required.

MS Webcast | Lunch Time – Implementing SQL Server AlwaysOn | 15-May-2013

I’ll be delivering a Webcast on AlwaysON in the new Lunch Time series.

Lunch Time is a new talk series scheduled for every alternate Wednesday exactly during the Lunch Time. And the presenters of this talk series are the Most Valuable Professionals. This would give the audience a good platform to learn from these exceptional technical leaders and give product feedback to Microsoft through them.

Hurry up Register Now!

To Register: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032545159&culture=en-IN

LunchHour-ALWAYSON Webcast

SQL Server Backups | BarCamp 9 | Delhi | 27-April-2013

Barcamp is not new to Delhi as this city hosted the first Barcamp in Asia seven years ago on 4th March 2006. This iteration of Barcamp Delhi will be 9th in the long series, and we welcome you to participate.

Barcamp is a tech oriented unconference which is organized by the attendees for the attendees. It is an event where people in the tech community come together to share ideas, knowledge, experiences with each other to benefit from the collective wisdom of peers

And This time i’ll be speaking about SQL Server backups in BarCamp Delhi

Description: In this demo heavy session Sarabpreet Singh Anand will brief you about the internals of Backups. He’ll also demonstrate the power of a good backup strategy by Corrupting a Database live in front of audience and recover the same. So do register for the session and learn the most Vital task of any DBA.

Time: Saturday, April 27, 2013 10:30 AM  11:30 AM –(Updated Time)

Venue: SAP Lab Room 1  ~at~ SAP Labs India Pvt. Ltd.
Vatika Towers, 4th Floor, Sector 54, Golf Course Road
Gurgaon, Haryana – 122002, India

To Register: http://connect.barcampdelhi.org/Account/Register.aspx

The full Agenda is as follows:

final-BarCamp-9

image

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:

image