SQL Compatibility Level Checks | Compatibility issues in SQL | Change Compatibility Level in SQL

This video talks about
SQL Compatibility Level Checks
Compatibility issues in SQL
Compatibility level in sql
How to Change Compatibility Level of a Database in SQL Server

SELECT NAME, COMPATIBILITY_LEVEL FROM SYS.DATABASES;

ALTER DATABASE [Test_BackUPDB]
SET COMPATIBILITY_LEVEL =130

***************************************
MSBI Opportunities/Jobs and Packages

Please watch and subscribe for more videos..
#SQLMSBI

https://www.youtube.com/watch?v=LqRMNAJUGPQ

************
SQL DBA Tutorials | SQL DBA Interview Questions..

https://www.youtube.com/watch?v=TaQfKRvpvf0&list=PLmhoQ1nd8VnQ553GGmi2aC5tSX8MgJ7CI

********************************
Top Procedure Interview questions in SQL Server?????

Please watch and subscribe for more videos…..

https://www.youtube.com/watch?v=ZTSw89A1ZUg

*************************
What are the top SQL Query Interview Questions ?????

Please watch and subscribe for more videos..

#SQLMSBI

https://www.youtube.com/watch?v=Euf4-0R8ias

************

*******

how to compare sql databases | sql db Comparison | compare two databases of sql | sync sql databases

https://www.youtube.com/watch?v=29AqZm2yVYo

*********
How to create and access linked server in SQL Server?

https://www.youtube.com/watch?v=GKtIZjvKwfk

*********
Log shipping in SQL Server |Sql log shipping Configuration |sql disaster recovery

https://www.youtube.com/watch?v=yuKq0go6res

**************

Object Level Permissions in SQL | Permission to specific tables to user | sql login create and error

https://www.youtube.com/watch?v=EZFqL0cJPQc
*************
how to add Multiple Schedules to SQL JOB | one job with multiple schedules | sql create job custom schedules

https://www.youtube.com/watch?v=TaQfKRvpvf0
**************

***********
find sql port number | sql port issues | change port of sql server | dynamic port in sql

https://www.youtube.com/watch?v=vqxpHbeNLw0

**********

Why do we need port number of SQL Server?

https://www.youtube.com/watch?v=vqxpHbeNLw0
**************

*********
SQL job history is missing | How to check sql agent job history

https://www.youtube.com/watch?v=NT_ez_4Sgww

***********
How to identify long running queries in SQL server ??
How to identify blocking queries in SQL server ??

#SQLMSBI

https://www.youtube.com/watch?v=rqMJKqqWudQ

***************
Last Value function in sql | sql last_value examples

https://www.youtube.com/watch?v=elcH5xOzvTU
*************
How to apply Pivot in sql server???

https://www.youtube.com/watch?v=Aj1m-xSESVU

*********
What is Unpivot in sql server???

https://www.youtube.com/watch?v=UVi1SC31xKg
*************
Dynamic Pivot function in SQL Server

https://www.youtube.com/watch?v=BZ8ojeOkRUg
***********
Dynamic sql in sql server | dynamic queries in sql server | sql execute function

https://www.youtube.com/watch?v=6uREkvkO728

******

Debugging Techniques in SQL Server | Sql queries debugging

https://www.youtube.com/watch?v=Jem4-yxSqSk

***********
Stored Procedure debugging in sql | sql debugging stored procedures

https://www.youtube.com/watch?v=BDswTNxnFAA
**************
How to use Dynamic SQL in Stored Procedure

https://www.youtube.com/watch?v=qAhNNrqBDQ4

**********
Start sql job at specific step | create sql job | sql job starts

https://www.youtube.com/watch?v=nqE5kJxvCnY

**************
Attach and Detach database in SQL Server | copy databases in sql server | sql attach database

https://www.youtube.com/watch?v=CriRDP_AAYc

**************
How to rename database in sql server | SQL rename database examples | sql alter database name

https://www.youtube.com/watch?v=krSZ9tm6Th4

************
How to generate scripts of complete database in sql | sql scripts for all objects

https://www.youtube.com/watch?v=rJHk4_g9zt8

*************
sql automate database backups in one shot| Schedule SQL Database backup

https://www.youtube.com/watch?v=apJvHKsB6_I

*************
Automated backups cleanup in sql | sql old backups cleanup | Maintenance plans in sql

https://www.youtube.com/watch?v=rX4Qb8HPXk0
***************
Move data files to another drive in sql | move mdf files to other drives in sql | sql dba tutorials

https://www.youtube.com/watch?v=UvWpOamx_eI
***************