|
- How to Create SQL Server Management Studio 18 (SSMS) Extension
The SSMS team at Microsoft finally decided to remove the constraint that allowed only extensions with whitelisted package ids to be loaded into SSMS Now you just develop your extension and it just works Will be using Visual Studio 2017 this time around Because the updated SSMS 18 is now based on the VS 2017 Isolated Shell
- 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
- 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
- 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
- Options for Database Backup and Restore - How to Export BACPAC using SSMS?
This article describes the options to restore and backup database in SQL Server and explains how to Export BACPAC from SQL Server Management Studio
- Decrypt SQL Server Objects - CodeProject
The two objects will be decrypted using Optillect, then altered in SSMS, and the changes applied to the database Create the Database Schema The script for creating this schema and the associated SQL Server objects used in this article can be downloaded from this zip file The table relationship is as follows: A User can belong to more than one
- What is a SQL Server Data Dictionary? - CodeProject
What is a Data Dictionary? In SQL Server, the data dictionary is a set of database tables used to store information about a database’s definition The dictionary contains information about database objects such as tables, indexes, columns, datatypes, and views The data dictionary is used by SQL server to execute queries and is automatically updated whenever objects are added, removed, or
- Learn to Write Custom MDX Query First Time - CodeProject
Learn to write custom MDX queries for the first time with this comprehensive guide on Code Project
|
|
|