In this series of posts, we’ll see few great yet less known and under utilized tips/features that are there since earlier versions of Visual Studio and later made their way to SSMS (SQL Server Management Studio).

SSMS

How to Shrink SQL Server Database Log File

2 Nov 2019 by Ghanshyam N Patel

How to shrink SQL Server database log file

SQL

SSMS

SQL-Server

Create a SQL Server Management Studio Extension

2 Jul 2021 by Kevin Chadney

Creating a simple SSMS extension which accesses the query window and object browser.

SQL

SSMS

SQL-Server

The Content Database has a Schema Version which is Not Supported by this Version

6 Mar 2019 by Melick

How to copy your production SharePoint database to development environment

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool

24 Nov 2018 by Vivek Johari

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool Contents Introduction Microsoft Database Migration Assistant (DMA) tool Migrate SQL Server database To Azure SQL Instance using DMA tool Detecting the compatibility issues using Assessment Type

Query Plans in SQL

14 Aug 2019 by essentialSQL

Query plans in SQL

Azure – Creating an Azure SQL Database

27 Dec 2018 by Vivek Johari

Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose Elastic Pool Option Step 7: Choose Service Tier for