TroubleshootingSQL is a blog which documents 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.
TroubleshootingSQL is owned by Amit Banerjee. He has vast experience in database management systems. He has a Bachelor’s degree in Computer Science engineering and currently works as a Senior Director at Salesforce. In the past, he was a Principal Group Manager at Microsoft leading product management for SQL Server, SQL Server on Azure VM, Azure SQL Edge and Azure Arc SQL Managed Instance. Prior to this role, he used to work as a Senior Premier Field Engineer at Microsoft specializing in proactive and advisory assistance for SQL Server environments. He has also worked for the SQL Server Support team in various capacities including the Microsoft SQL Server Escalation Services team. Here he specialized in reactive assistance which involved troubleshooting complex SQL Server issues and debugging. He has worked on environments of a varied scale which involves 100 users or 10 million users.
I do specialize in a few aspects of SQL Server
I am a community speaker
I contribute in various forms to the SQL community
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.
All the posts related to Microsoft Azure are based on the feature when the post is published. Posts related to features in PREVIEW are also based on the PREVIEW feature on the date of publishing the post unless explicitly mentioned.
Azure related posts
All the posts regarding Microsoft Azure are as of the publishing day of the post unless otherwise specified.
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.
You can get in touch with me using the contact form below:
The Session Health Events queries are nice but some extra tags seem to have snuck into the posted code
Only after removing the and tags do the queries parse and run correctly.
I will look into that. The formatting was added by the code plugin that I am using.
Pingback: Report Server Analytics with Power Pivot & Power View | Clint Huijbers' Blog