|
- SQL Table Dependency Diagram Generator (SSMS 18,19 20)
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server
- 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
- Retrieve Unsaved Lost SQL Script Files due to SSMS Crash . . . - CodeProject
This is a guide for recovering the SQL Script files that are lost when SSMS crashed or system crashed or because of any other reason Sometimes, user by mistake closes the SQL Script window and loses the script that is written
- 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
- Debug Stored Procedures in Visual Studio and SSMS
Conclusion With the use of a sample project and database, this article demonstrated how Visual Studio and SSMS can be configured to allow the debugging of stored procedures Debugging in Visual Studio is particularyy handy as it is possible to see the exact parameter values being passed from the code, and to determine if these values are as
- 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
- Query Excel or CSV files with T-SQL - CodeProject
Download source code - 234 6 KB Introduction Sometimes, it is useful to query Excel or CSV files using SQL statements without having to import them into a table through BulkInsert This article shows in detail how and it uses Microsoft Access Database Engine which should be working on all editions of SQL Server since 2005 SQL Server Setup (must be done once) Enable Ad Hoc Distributed Queries
- 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
|
|
|