SQL Server 2014 Post Install Review Training Videos for Beginner

1
SQL Server 2014 Post Install Review Training
Videos for Beginner by
2
Highlights

• SQL Server Configuration Manager
• Basics of SQL Server Management Studio

3
SQL Server Configuration Manager

• It is a SQL server tool.
• Manages the services related with SQL Server.
• Configures the network protocols.
• Assists network connectivity configuration from
  SQL Server client computers.
• Available from the Start menu of  Microsoft
  Management Console snap-in.
• Microsoft Management Console (mmc.exe) uses the
   SQLServerManagerltversiongt .msc to open
  Configuration Manager.

4
SQL Server Configuration Manager

•  SQL Server installation paths on windows
  systems.

Source https//msdn.microsoft.com
5
SQL Server Configuration Manager

• Uses Window Management Instrumentation (WMI) to
  view and modify some server settings.
• It is useful to initiate, hold, resume, and stop
  the services to view and change service
  properties.
• Also useful to start the Database Engine using
  startup parameters.
• SQL Server or SQL Server agent services uses it
  for changing the password of user accounts.

6
SQL Server Configuration Manager

• Manages server and client network protocols,
  protocol encryption, view alias properties, and
  also useful to enable or disable protocols.
• Creates or removes an alias, and views properties
  for a server alias includes
• Server Alias is a server alias used for the
  computer to which the client is connecting.
• Protocol is a network protocol useful for the
  configuration entry.
• Connection parameters are the parameters linked
  with the connection address for the network
  protocol configuration.

7
Basics of SQL Server Management Studio

• Initially released in 2005 and stable SQL Server
  Management Studio version 13.0.16000.28 released
  on October 26, 2016.
• It is an integrated environment.
• Useful to access, configure, manage,
  administrate, and to develop the components of
  SQL Server and Azure SQL Database.
• Merges graphical tools with script editors to let
  the developers to access to SQL Server.

8
Basics of SQL Server Management Studio

• Provides one location for enterprise manager,
  query analyzer, and analysis manager features.
• Works with reporting services and integration
  services components.
• Latest SSMS version works with all SQL Server
  versions.
• Provides great support to work with the modern
  cloud features in Azure SQL database and data
  warehouse.

9
Feedback
Like It ? Hate It?
We would love to hear from you whatever you think
about the course.
Click HERE to share what you think!
10
Thank you
Thank You for Watching SQL Server 2014 Post
Install Review Training Videos for Beginner by
http//www.courseing.com