Visual Studio - Swagger and Swashbuckle with ASP.NET Core 2

Swagger and Swashbuckle with ASP.NET Core 2

Swagger is a specification used to document an API. As I am sure we all know API documentation tends to get out of date fast and a lot of times is a low priority.

MS SQL Server - Query Designer

Query Designer

1. Open SQL Server Management Studio.
2. Select the database you want to query from in the drop down list of the SQL Editor tool bar, in our case 'NORTHWIND'.
3. Navigate to the Query menu and select the 'Design Query in Editor...' option. Alternatively, press Ctrl+Shift+Q.
4. The Query Designer will load and follow the steps in next section to select the needed tables, then build and test the query.

MS SQL Server - Backup database

Backup database

This topic describes how to create a full database backup in SQL Server using SQL Server Management Studio.

MS SQL Server - Restore database

Restore database

1. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. 2. Right-click Databases and select Restore Database... 3. On the General page, use the Source section to specify the source and location of the backup sets to restore. Select one of the following options: Device 4. Click the browse (...) button to open the Select backup devices dialog box. 5. Add then OK, OK

IIS - How to Install on Windows 8 or Windows 10

How to Install Internet Information Services on Windows 8 or Windows 10 1. Search "windows features" and enter 2. Click on the Internet Information Services check box. 3. Click OK

Visual Studio - Adding or removing workloads and components

Modify Visual Studio by adding or removing workloads and components 1. Open Visual Studio 2. Go to Tools - Get Tools and Features 3. Select workloads or components 4. Click in Modify

MS SQL Server - Prevent saving changes that require the table to be re-created

Prevent saving changes that require the table to be re-created

1. Go to Tools -- Options -- Designers 2. Uncheck " Prevent saving changes that require table recreation ".