SQL Depository

PowerShell For DBA Part - 9.1 (SQL Server Backups)

PowerShell For DBA Part - 9 / Start writing meaning scripts in powershell

Resolve SSL Provider Error - certificate verify failed:self signed certificate

SQL Server Linux - connect using command line tool (sqlcmd)

SQL Server installation on ubuntu

Deploy Linux (Ubuntu) server

SQL Server on Linux - Deploy VM

Why delete is DML while truncate is a DDL

SQL Server Index Basics - Part 1

CxPacket - When and Why

CxPacket - Cost Threshold For Parallelism and Query Plan

CxPacket wait type - part 1 - Parallelism

7.6 - Postgres Administration - Error Logs

3. Postgres Administration - Postgres Installation

PowerShell - Error Handling

Performance Tuning - SQL Server - IMPLICIT CONVERSION

PowerShell FOR DBA Part-4 (Monitor Disk Space and send Alerts)

8. Postgres Administration - Tablespace

7.4 - Postgres Administration - Basic postgres commands

Performance Tuning - SQL Server - Indexes on temporary table

Configure And Administer SQL Server Reporting Service-1(Configure SSRS)

7.1 Postgres Administration - postgresql.conf

New Developments in SQL Server 2019 - Scalar functions

day 4 - MySQL Tablespace

Performance Tuning - SQL Server - SET NOCOUNT ON

day 2 - Install MySQL using config file

MySQL - day 9 - Blocking

New Features in SQL server 2019 - Table Variables

SQL Server installation using command prompt

7.3 - Postgres Administration - Host Based Authentication - pg_hba.conf

Troubleshoot blocking chain in SQL server

Tips to create effective indexes - SQL Server

SSIS Project Deployment model

7.4.3 - Postgres Administration - Basic postgresql terminal commands

7.2 Postgres Administration - postgresql.auto.conf

PowerShell For DBA Part-8 (Write PowerShell output in email body and send as attachment)

Performance Tuning - SQL Server - Key Look up

SQL Server Wait Types

5 . Postgres Administration - Background processes

8.2 Postgres Administration - Move and Drop Tablespaces

Index seek - Are they always optimal?

6. Postgres Administration - Restore database - dvdrental

2. Postgres Administration - Deploy Ubuntu VM - AWS EC2

Performance Tuning - Unicode Datatypes

day 3 - MySQL System Databases(Schema), Storage Engines , Default MySQL files and table files

PowerShell - Beginner to Advance 4

4. Postgres Administration - Postgres Architecture

7.3.2 - Postgres Administrator - pg_hba.conf