|
- 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
- Learn to Write Custom MDX Query First Time - CodeProject
Using SQL Server Management Studio (SSMS), we can only browse values on two axis, Columns (Axis 0) and Rows (Axis 1) Getting Started With MDX 1 Start with Simple MDX Query Syntax:
- How to Create SQL Server Management Studio 18 (SSMS) Extension . . .
Tutorial on how to start developing SSMS extensions
- Options for Database Backup and Restore - CodeProject
This article describes the options to restore and backup database in SQL Server and explains how to Export BACPAC from SQL Server Management Studio
- 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
- Data Mining: An Introduction to Neural Networks in SQL Server
You can also use a DMX query in SQL Server Management Studio (SSMS), as shown in the below screenshot I personally prefer using a query rather than a user interface
- 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
|
|
|