Create Your Own SQL Server Management Studio 17 (SSMS) Extension The process for extending older versions of SSMS should be similar though Background All I wanted was to create a simple SQL Server Management Studio (SSMS) extension to simplify what was already a simple action that I repeat a couple of times a week I thought, how hard could it be… it’s just a simple action
Create a SQL Server Management Studio Extension - CodeProject For years I’ve been using excel or dynamic SQL to generate SQL scripts to do data loads and updates and to generate IN predicates For a small number of rows or values this is quicker than importing the required data into SQL Server A few days ago I idly wondered how difficult it would be to create a SQL Server Management Studio extension to do these jobs directly in SSMS The answer was
Easy Way to Change Collation of All Database Objects in SQL Server To use, put SSMS into "results in text" mode and run the script The output will be a formatted script that you can cut and paste to use elsewhere Don't forget to configure the maximum text size before using The default is 256 characters--not enough for many cases Tools->Options->Query Results->Results to Text->Maximum number of characters->8192
How to Migrate SQL Database to Azure SQL Database using SSMS Deploy As a next step, this article tells about migrating SQL Database to Azure SQL Database using SQL Server Management Studio (SSMS) deploy In the next few articles, we are going to discuss other methods of SQL database migration to Azure Portal Please don’t forget to give your valuable comments for the article
Execute SQL Query on Mutiple SQL Servers or Databases Simultaneously The downside I felt about SSMS is that it is available for free till SQL Server 2008 R2 SQL Server 2012 onwards, one need to purchase a license of the same I feel if we use both of these of the mentioned features, we can reduce the chances of making mistakes while running the same query on Multiple Servers or Multiple Databases