Tip #20 – Putting the Pieces of .NET Together – Part 6 of 8 – SQL Server


Tip #20 – Putting the Pieces of .NET Together – Part 6 of 8 – SQL Server

LearnVisualStudio is currently having a Summer Sale on all of its memberships. Click on the link below to receive your discount now:

Get LearnVisualStudio at 15% off now

Tip #20 – Putting the Pieces of .NET Together – Part 6 of 8 – SQL Server

What is SQL Server?

SQL Server is a database server that listens for SQL commands and returns information from SQL databases

Where is SQL Server?

Programs – Program Files/Microsoft SQL Server/100/MSSQL10.MSSQLServer/MSSQL/Binn

Databases – Program Files/Microsoft SQL Server/100/MSSQL10.MSSQLServer/MSSQL/Data

What File Level Security is needed to access a database?

You have to give access rights for SQL Server database to either yourself (if you connect in mixed mode) or to username (if you use SQL Server Authentication)

How do you create an instance of SQL Server?

This happens in the setup process for SQL Server – the default instance for SQL Express is machinename/SQLEXPRESS

How do you start and stop an instance of SQL Server?

You can use SQL Configuration Manager which is in Program Files/

What is SSMS?

SSMS is SQL SERVER Management Studio – it allows you to connect to a server , run commands, and edit tables.

(P.S. You can download the 48-page PDF for this series at: Putting the Pieces of .NET Together )

Putting the Pieces of .NET Together - Part 6 of 8 - SQL Server

Click the following link to get your 15% discount on LearnVisualStudio now:

Get LearnVisualStudio at 15% off now