The idea is to create a blog to document solutions for most of the common issues that people come across while working on SQL Server. In the IT world everyone believes in reusability. This is where I document (whenever I can) the most commonly answered questions, sometimes unique solutions and frequently used scripts. Not only does this end up helping the community but also provides me with a ready to use repository in case my grey cells fail me at any given point of time.
The views expressed on this website/blog are mine alone and do not reflect the views of my company. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.
The following disclaimer applies to all code, scripts and demos available on this site:
This Sample Code is provided for the purpose of illustration only and is not intended to be used in a production environment. THIS SAMPLE CODE AND ANY RELATED INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. We grant You a nonexclusive, royalty-free right to use and modify the Sample Code and to reproduce and distribute the object code form of the Sample Code, provided that You agree: (i) to not use Our name, logo, or trademarks to market Your software product in which the Sample Code is embedded; (ii) to include a valid copyright notice on Your software product in which the Sample Code is embedded; and (iii) to indemnify, hold harmless, and defend Us and Our suppliers from and against any claims or lawsuits, including attorneys’ fees, that arise or result from the use or distribution of the Sample Code.
Amit Banerjee (Twitter)
I currently work as a Senior Premier Field Engineer at Microsoft specializing in proactive and advisory assistance for SQL Server environments.
I was part of the SQL Server Escalation Services team at Microsoft. This involved fixing/troubleshooting complex issues related to SQL Server over a varied range of environments which could be a deployment handling just 100 users or 10 million users. Over the years, I have learnt various ways of slicing and dicing diagnostic data collected for troubleshooting and picked up a few tricks & tid-bits about the internals of this ever-evolving product called SQL Server. My attempt on this blog is to share these nuggets of knowledge with the community at large and at the same time enjoy writing the posts.
My interests: Compulsive tweeting, Movie marathons in Fast Forward, Refined gluttony (only for sumptuous food), Sporadic Blogging, Avid gamer (PC, Mobile, XBOX), Highway driving, Cricket fanatic, Obsessed with music (no particular genre).
Specialty Area: SQL Performance, Storage Engine, Scripting (WMI/T-SQL/Powershell), Tools, VDI/VSS, Database Mirroring, SQL Server Internals
Contributor to the SQL Server performance data analysis Tool on CodePlex: SQL Nexus
Owner of SQL Server Backup Simulator available on Microsoft Code Gallery
Editor of SQL Diag/PSSDIAG Configuration Manager on Codeplex
Speaker for Microsoft Talking Tech, 2009 (Cochin | Delhi | Bangalore | Chennai)
Microsoft Virtual Tech Days – May 2011
Microsoft Virtual Tech Days – September 2011
SQL Saturday #116 (Bangalore) – January 2012
SQL Saturday #76 (Auckland) – January 2012
Microsoft India TechEd (Bangalore) – March 2012
SQL Bangalore UG Meet (Bangalore) – December 2012
The webcasts that I have delivered are tagged under Webcasts category on my blog.
Co-author of Professional SQL Server 2012 Internals and Troubleshooting
My other publications:
SQL Server FAQ – A MSDN blog where CSS engineers post about common SQL related issues. All my posts on SQLServerFAQ posts available here.
SSWUG – I have recently started writing for SSWUG as a guest author. My list of SSWUG articles are available here.
My Scribblepad – This is my personal non-technical blog on which I dish out my cynicism, satire or just plan rantings of the day.