|
- 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
- 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
- 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
- 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:
- Create First OLAP Cube in SQL Server Analysis Services
Download SalesDataAnalysis zip - 53 7 KB Download Data_WareHouse__SQLScript zip - 8 1 KB Introduction This article is created to help those technical newbies who want to learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse We will first take a glimpse at the basic introduction to
- 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
- Devs User Guide To SqlLocalDb (Sql Express) - CodeProject
It also provides us with the named pipe that we can use to connect to the server instance using SSMS (Sql Server Management Server) However to connect to this database using Visual Studio, you need to use the instance name
|
|
|