SQL Server 2014 Post Install Review Tutorial Videos for Beginner - PowerPoint PPT Presentation

Loading...

PPT – SQL Server 2014 Post Install Review Tutorial Videos for Beginner PowerPoint presentation | free to download - id: 854276-MjI1M



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

SQL Server 2014 Post Install Review Tutorial Videos for Beginner

Description:

SQL Server 2014 Post Install Review Tutorial covers SQL Server Configuration Manager and Basics of SQL Server Management Studio in brief. catch experts provides various free video, online , and classroom tutorial resources. – PowerPoint PPT presentation

Number of Views:55

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: SQL Server 2014 Post Install Review Tutorial Videos for Beginner


1
CATCH EXPERTS
https//www.catchexperts.com
http//www.courseing.com
2
SQL Server 2014 Post Install Review Tutorial
Videos for Beginner by
3
Highlights
  • SQL Server Configuration Manager
  • Basics of SQL Server Management Studio

4
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.

5
SQL Server Configuration Manager
  •  SQL Server installation paths on windows
    systems.

Source https//msdn.microsoft.com
6
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.

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

8
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.

9
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.

10
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!
11
Thank you
Thank You for Watching SQL Server 2014 Post
Install Review Tutorial Videos for Beginner by
http//www.courseing.com
About PowerShow.com