Learn SQL Server with Free Lessons & Tips

• In-Memory OLTP.
• Enhanced In-Memory ColumnStore for DW.
• Buffer Pool Extension to SSDs.
• Enhanced Query Processing.
• Resource Governor adds IO governance.
• SysPrep at cluster level.
• Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2.

A deadlock occurs when two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs. SQL Server handles deadlocks by terminating and rolling back transactions that were started after the first transaction.

To connect to a named instance, the SQL Server Browser service must be running. In SQL Server Configuration Manager, locate the SQL Server Browser service and verify that it's running. If it's not running, start the service. The SQL Server Browser service isn't required for default instances.

SQL is a query programming language that manages RDBMS. MySQL is a relational database management system that uses SQL. SQL is primarily used to query and operate database systems. MySQL allows you to handle, store, modify and delete data and store data in an organized way.

Both Oracle and Microsoft SQL Server are great RDBMS options, and can both be used in similar ways. Both offer enterprise-level solutions, both make it easier to recover data than the rest of the competition. Microsoft's might be easier to learn, but that simplicity comes with some drawbacks.

1. Install SQL Server.
2. Install Analysis Services (SSAS)
3. Install Integration Services (SSIS)
4. Install Reporting Services (SSRS)
5. Download SQL Server Management Studio (SSMS)
6. Download SQL Server Data Tools (SSDT)
7. Download Azure Data Studio.