May 102013
 

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. Related posts: Using Covering Index Best Practice No.1 Best Practice No.3

May 012013
 
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 [Read More]

Apr 232013
 
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. [Read More]

Apr 122013
 
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 [Read More]