Канал: Server Codex

1 Course Introduction

1 Course Introduction

7 How to Write Computer Codes with ChatGPT

7 How to Write Computer Codes with ChatGPT

8 Handling Error Messages with ChatGPT

8 Handling Error Messages with ChatGPT

9 How to Write Short Stories with ChatGPT

9 How to Write Short Stories with ChatGPT

10 How to Write an eBook in Minutes

10 How to Write an eBook in Minutes

12 How to Write Cover Letter and Resume

12 How to Write Cover Letter and Resume

13 Conclusion

13 Conclusion

031 Backup database using Maintenance plan

031 Backup database using Maintenance plan

045 Demonstration of Users Logins Roles

045 Demonstration of Users Logins Roles

009 Installing Service Packs and Fixes SP2

009 Installing Service Packs and Fixes SP2

011 Introduction to System Databases

011 Introduction to System Databases

048 Accessing SQL Server using SQL Login

048 Accessing SQL Server using SQL Login

028 Recovery state in restores

028 Recovery state in restores

026 Restore database with GUI

026 Restore database with GUI

010 Touring SQL Server Management Studio SSMS

010 Touring SQL Server Management Studio SSMS

023 Transactional Log Backups

023 Transactional Log Backups

040 Setting up alerts Severity Errors from 17 to 25

040 Setting up alerts Severity Errors from 17 to 25

020 Attach and detach a database

020 Attach and detach a database

042 Central Management with SQL Server Agent

042 Central Management with SQL Server Agent

049 Understanding SQL Server Roles

049 Understanding SQL Server Roles

039 Setting up SQL Database Mail Part2

039 Setting up SQL Database Mail Part2

047 Selecting Authentication or Mixed Mode security

047 Selecting Authentication or Mixed Mode security

007 Install SQL On Separate Drive with Service Accounts Part 1

007 Install SQL On Separate Drive with Service Accounts Part 1

004 Promote Domain Controller to Active Directory

004 Promote Domain Controller to Active Directory

025 Introduction to Restore

025 Introduction to Restore

021 Introduction to Backups

021 Introduction to Backups

032 Maintenance Plan Tasks

032 Maintenance Plan Tasks

038 Setting up SQL Database Mail

038 Setting up SQL Database Mail

018 Create a SQL database

018 Create a SQL database

053 Best SQL Server Practice Security

053 Best SQL Server Practice Security

041 Central Management with SQL Server Agent CORRECTION

041 Central Management with SQL Server Agent CORRECTION

033 Dont shrink a database

033 Dont shrink a database

002 Software to download and install

002 Software to download and install

050 Managing SQL Server Roles via TSQL

050 Managing SQL Server Roles via TSQL

035 Create a simple backup job using SQL Server Agent

035 Create a simple backup job using SQL Server Agent

036 The importance of DBCC CheckDB

036 The importance of DBCC CheckDB

022 Full Database Backup

022 Full Database Backup

037 Using SQL Server Agent with multiple steps

037 Using SQL Server Agent with multiple steps

043 Installing free VMware Pro Player for virtualization

043 Installing free VMware Pro Player for virtualization

013 Auto Growth and sizing of transaction log

013 Auto Growth and sizing of transaction log

003 Create Virtual Machine Domain Controller

003 Create Virtual Machine Domain Controller

006 Create Vm for SQL Server 2012 Install Part 2

006 Create Vm for SQL Server 2012 Install Part 2

008 Install SQL On Separate Drive with Service Accounts Part 2

008 Install SQL On Separate Drive with Service Accounts Part 2

029 Recovery mode with tail log backup

029 Recovery mode with tail log backup

017 What is virtual log file VLF

017 What is virtual log file VLF

014 Detail Transaction log ATM Example

014 Detail Transaction log ATM Example

030 Backup using Maintenance plan

030 Backup using Maintenance plan

019 The importance of Tempdb

019 The importance of Tempdb

044 Introduction to SQL Server Security

044 Introduction to SQL Server Security

015 Types of Recovery Models

015 Types of Recovery Models

051 SQL Server Roles Demonstration

051 SQL Server Roles Demonstration

024 Differential Backups

024 Differential Backups

005 Create Vm for SQL Server 2012 Install Part1

005 Create Vm for SQL Server 2012 Install Part1

016 Function fn dblog to view inside a transaction log

016 Function fn dblog to view inside a transaction log

012 SQL Server Data and Log Files

012 SQL Server Data and Log Files

046 Managing security with T SQL

046 Managing security with T SQL

054 SQL ADMINISTRATION PART 2 TABLE OF CONTENT

054 SQL ADMINISTRATION PART 2 TABLE OF CONTENT

027 Restore database using differential

027 Restore database using differential

052 Managing SQL Server Permissions

052 Managing SQL Server Permissions

001 What is a Domain

001 What is a Domain

034 The importance of using SQL Server Agent

034 The importance of using SQL Server Agent