SQL Server Database Migration | Sql server migration issues | Upgrade sql 2012 to sql 2016



SQL Server Database Migration | Sql server migration issues | Upgrade sql 2012 to sql 2016

SQL Server Database Migration | Sql server migration issues | Upgrade sql 2012 to sql 2016

This video talks about
SQL Server Database Migration
Sql server migration issues
Backup and restore
Database mirroring
Log shipping
Transactional replication
Always On availability
Bulk load

SQL 2012 to SQL 2016 :
.Backup and restore / attach and detach option — sql objects
. Linked servers
. proxies / credentials
. mail profile
. Jobs If MSDB is part of DB migration then nothing to worry

***************************************
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
***************
SQL Compatibility Level Checks | Compatibility issues in SQL | Change Compatibility Level in SQL

https://www.youtube.com/watch?v=L6-Oe6whdUA
*******************

Comments are closed.