1. SQL Server Create Database with GUI and TSQL
2.How to Rename a Database in MSSQL Server using GUI and TSQL?
3. How to Attach and Detach Databases in MSSQL server and detach database without log file.
4.How to Shrink Database log files And Database Files using TSQL and GUI .
5.How to Take Database Offline and Bring it Online using TSQL and GUI .
6.How to Script out an Entire Database in MS SQL Server Using GUI .
7. How to change Compatibility level of a database Using GUI
8.How to Take Database Single User Mode and Multi User Mode in MSSQL Server Using GUI?
9.How do I change the ownership of a database and how find the database owner in mssql ?
10.Auto growth setting and initial size setting Database in SQL Server?
To know about patching of SQL server using installer ,Configuration manager settings and know about CU,SP and KB in details .
How to avoid restart using RegEdit .
Part 1 :- • What is MSSQL and how it works
Part 2 :- • MSSQL Server versions and updates
Db configuration :- • How to create database Rename databas...
Database security Video :- • Server and database security in Micro...
MSSQL database Backup Restore :- • How to take Full Backup , Diff Backup...
MSSQL collations :-