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 )
|