Category Archives: Productivity

Search Windows Server patches using KBXXXX

Server http://www.catalog.update.microsoft.com using KB number to find the patch information and download link. Example: http://www.catalog.update.microsoft.com/Search.aspx?q=KB4489882 Advertisements

Posted in Productivity, Uncategorized | Tagged , , , | Leave a comment

What is azure sql database elastic pool split instance problem

Azure sql database elastic pool split instance problem is a very rare phenomena which could impact resource usage metrics of elastic pool. In this post I will cover how resource metrics are impacted, sample monitor, example of an impact. How … Continue reading

Posted in Azure, knowledge, Productivity, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , , | Leave a comment

T-SQL to find High availability configuration of all databases in MSSQL Server

 TSQL to find list of all databases in MSSQL Server with Always-ON and mirroring configuration. #mssql#tsql #AlwaysOn #Mirroring #FailoverMode #HighAvailability

Posted in Productivity, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , | Leave a comment

Add-on storage (Max storage choices) for Azure SQL Elastic Pools/ Databases – Great cost saving opportunity

If you have been using Azure SQL Elastic pools or databases (Platform As A Service – PASS), I strongly recommend to check your workload and validate Max storage choices! What change: Traditionally Each Azure Database and elastic pool had fixed … Continue reading

Posted in Azure, Productivity, SQL, Uncategorized, Useful Link | Tagged , , , , , , , , | Leave a comment

Visual Studio Code – What I liked!

Visual Studio Code is the new code editor from Microsoft. Following are few reasons why started using it and liking it! * Cross Platform availablity: VS Code is available across Windows, Linux, and mac. This provides same experience using different … Continue reading

Posted in Productivity, Referene, Uncategorized, Visual Studio | Tagged , , , | Leave a comment

Command to find domain group members

Related: https://vijredblog.wordpress.com/2016/04/21/activedirectory-group-user-membership-validation-tool/ (Active Directory Helper)

Posted in commands, Productivity, Uncategorized | Tagged , , , , , | Leave a comment

Onenote weekly backup

I have created Onenote on sharepoint, shared it across virtual team. All members of the project were actively using this. To my horror, I realize one of the section was accidentally deleted 😦 By default Onenote will be backed up … Continue reading

Posted in knowledge, Productivity, Uncategorized | Tagged , , | Leave a comment