Welcome to the FoxLearn
Today we will learn how to install sql server 2014
Microsoft SQL Server is a database management and analysis system for e-commerce
line-of-business, and data warehousing solutions
Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered in our prior release by providing breakthrough performance
availability and manageability for your mission critical applications
SQL Server 2014 delivers new in-memory capabilities built into the core database for online transaction processing
and data warehousing, which complement our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution on the market
SQL Server 2014 also provides new disaster recovery
backup, and hybrid architecture solutions with Microsoft Azure
enabling customers to use their existing skills with on-premise features that leverage Microsoft's global datacenters
In addition, SQL Server 2014 takes advantage of new Windows Server 2012
and Windows Server 2012 R2 capabilities to give you unparalleled scalability for your database application in a physical or virtual environment
We will login windows authentication mode
Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication
When a user connects through a Windows user account
SQL Server validates the account name and password using the Windows principal token in the operating system
This means that the user identity is confirmed by Windows
You can see databases on the left hand side and query editor on the right hand side
When using SQL Server Authentication
logins are created in SQL Server that are not based on Windows user accounts
Both the user name and the password are created by using SQL Server and stored in SQL Server
Users connecting using SQL Server Authentication must provide their credentials every time that they connect
Thank you for watching this video