Jayanth Kurup

Symmetric Key Encryption - Explained

Setting up and running packages in SSIS Scale Out

Setup Fulltext Search on Filestream -File tables & PDF Documents SQL 2014

Understanding Memory Usage in SQL Server Part 1/15

Part 2/4 Why you should continue to defrag your indexes :-What are page splits/sec

Part 3/4 Why you should continue to defrag your indexes : How use use Fill Factor Correctly

Securing SQL Server - Backup Encryption

Memory Management | SQL Server :- Memory Grant Info (5/15)

Memory Configuration - Min and Max Memory ( 3/15)

Securing SQL Server :- Transparent data encryption -TDE

DB Options – ANSI WARNINGS | ANSI PADDING and more

Lock Pages in Memory Part 2/15

Securing SQL Sever :-Data Classification & vulnerability Assesment

Part 1/4 Why you should continue to defrag your indexes :-What are page splits

Memory Management | SQL Server :- Memory Clerks

PowerBI Step By Step Tutorial - Zero Coding Experience Required

Securing SQL Server -Principle of least privileges

Securing SQL Server - Defense in Depth

Securing SQL Server :- Dynamic Data masking

DB Options :- Enabling Optimistic Concurrency in SQL Server

DB Options : Page Verify

Part 4/4 Why you should continue to defrag your indexes :- Performance impact

DB Options : -Recovery interval and Checkpoint

Using Schema Compare Option in SSDT ( Sql server data tools)

Exporting Data from SQL Server using the Wizard

Step by Step - SSIS Execute SQL Task - Part 5

Symmetric Key Encryption - Explained

Tuning SQL Server :-Identifying and Fixing the CPU issue

Creating a table , database and importing data from excel

Step by Step - Introduction to SQL Server Partitioning - Part 1

How to use partitioning to improve performance of large tables

Step by Step -Securing Azure Databases - Part 2

Step by Step- Database backups SQL Server - Part 1

DB Options: - AUTO UPDATE STATS / ASYNC

REAL WORLD DEMO of where AlwaysON connection gets established in different configurations

Tuning SQL Server :-Why table Design matters

Using PowerBI to Create a Web Banner

TDE SQL 2019 - Suspend and Resume

DB Options : ANSI NULL DEFAULT ON

NOLOCK hint can degrade performance too.

Using Bookmarks in PowerBI

DB options: ANSI Nulls ON

DB Options:- Auto Shrink =OFF and why shrinking is bad

SQL 2019 -Resumable Online Indexes SQL Server

Tuning SQL Server :- Understanding the data we are going to work with

Step by Step -Securing Azure Database Security Powershell -Part 1

User Defined Server Roles in MS SQL Server

Database Options:- FileStream

94% Compression ???? SQL Server From 1GB to 65 MB

DB Options : -Delayed Durability

Step by Step -How to use CLR Assemblies | MS SQL Server