Канал: Jayanth Kurup

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

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

Memory Management | SQL Server :- Memory Clerks

Memory Management | SQL Server :- Memory Clerks

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

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

Lock Pages in Memory Part 2/15

Lock Pages in Memory Part 2/15

Understanding Memory Usage in SQL Server Part 1/15

Understanding Memory Usage in SQL Server Part 1/15

Securing SQL Sever :-Data Classification & vulnerability Assesment

Securing SQL Sever :-Data Classification & vulnerability Assesment

Securing SQL Server :- Transparent data encryption -TDE

Securing SQL Server :- Transparent data encryption -TDE

Securing SQL Server - Backup Encryption

Securing SQL Server - Backup Encryption

Securing SQL Server :- Dynamic Data masking

Securing SQL Server :- Dynamic Data masking

Securing SQL Server -Principle of least privileges

Securing SQL Server -Principle of least privileges

Securing SQL Server - Defense in Depth

Securing SQL Server - Defense in Depth

PowerBI Step By Step Tutorial - Zero Coding Experience Required

PowerBI Step By Step Tutorial - Zero Coding Experience Required

When does SQL Cache a Plan?

When does SQL Cache a Plan?

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

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

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

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

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

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

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

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

DB Options : -Recovery interval and Checkpoint

DB Options : -Recovery interval and Checkpoint

Database Options:- FileStream

Database Options:- FileStream

DB Options :- PARAMETERIZATION

DB Options :- PARAMETERIZATION

DB Options : Page Verify

DB Options : Page Verify

DB Options : -Delayed Durability

DB Options : -Delayed Durability

DB Options :- Enabling Optimistic Concurrency in SQL Server

DB Options :- Enabling Optimistic Concurrency in SQL Server

DB Options – ANSI WARNINGS | ANSI PADDING and more

DB Options – ANSI WARNINGS | ANSI PADDING and more

DB options: ANSI Nulls ON

DB options: ANSI Nulls ON

DB Options : ANSI NULL DEFAULT ON

DB Options : ANSI NULL DEFAULT ON

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

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

DB Options: - AUTO UPDATE STATS / ASYNC

DB Options: - AUTO UPDATE STATS / ASYNC

DB Options: Auto Create Incremental Statistics ON

DB Options: Auto Create Incremental Statistics ON

DB Options : Auto Create Stats and why should I set it ON

DB Options : Auto Create Stats and why should I set it ON

DB Options : Auto Close and why should I set it OFF

DB Options : Auto Close and why should I set it OFF

Using Bookmarks in PowerBI

Using Bookmarks in PowerBI

Loading CSV Files into SQL Server in minutes

Loading CSV Files into SQL Server in minutes

Example of how partitioning improves performance

Example of how partitioning improves performance

NOLOCK hint can degrade performance too.

NOLOCK hint can degrade performance too.

TDE SQL 2019 - Suspend and Resume

TDE SQL 2019 - Suspend and Resume

Step by Step -Securing Azure Databases - Part 2

Step by Step -Securing Azure Databases - Part 2

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

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

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

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

SQL Server Security principals and the public role

SQL Server Security principals and the public role

Setting up and running packages in SSIS Scale Out

Setting up and running packages in SSIS Scale Out

SQL 2019 -Resumable Online Indexes SQL Server

SQL 2019 -Resumable Online Indexes SQL Server

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

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

Using PowerBI to Create a Web Banner

Using PowerBI to Create a Web Banner

Using Alexa to save money !! Using AI to track and manage expenses

Using Alexa to save money !! Using AI to track and manage expenses

Tuning SQL Server :-Why table Design matters

Tuning SQL Server :-Why table Design matters

Tuning SQL Server :-Identifying and Fixing the CPU issue

Tuning SQL Server :-Identifying and Fixing the CPU issue

Tuning SQL Server :-Simulating Performance Issues

Tuning SQL Server :-Simulating Performance Issues

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

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

Symmetric Key Encryption - Explained

Symmetric Key Encryption - Explained

SQL 2017 - Smart Transaction Log backups in MS SQL Server 2017

SQL 2017 - Smart Transaction Log backups in MS SQL Server 2017

SQL 2017 Graph database explained

SQL 2017 Graph database explained

Talking to PowerBI using Cortana

Talking to PowerBI using Cortana

When to use InMemory tables vs Columnstore Indexes for Reporting.

When to use InMemory tables vs Columnstore Indexes for Reporting.

Power Map for MS Excel

Power Map for MS Excel

POC :- MPW - Missing persons website

POC :- MPW - Missing persons website

Introduction to PowerBI - Creating your first report

Introduction to PowerBI - Creating your first report

STEP by STEP AWS S3 creating , securing and automating uploads/downloads

STEP by STEP AWS S3 creating , securing and automating uploads/downloads

How does a Clustered Index B tree look ?

How does a Clustered Index B tree look ?

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

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

SQL Server and the 3 Vs of BIGDATA

SQL Server and the 3 Vs of BIGDATA

Memory optimization SSIS

Memory optimization SSIS

MS SQL Server Data mining- decision tree

MS SQL Server Data mining- decision tree

SQL 2016 - Temporal table Bug

SQL 2016 - Temporal table Bug

Does TempDB actually get dropped and recreated , Proof !!

Does TempDB actually get dropped and recreated , Proof !!

How to use partitioning to improve performance of large tables

How to use partitioning to improve performance of large tables

Does partitioning Improve performance ? Explained

Does partitioning Improve performance ? Explained

MS SQL Server Performance Tuning Tempdb Spills

MS SQL Server Performance Tuning Tempdb Spills

SSIS task -Fuzzy grouping

SSIS task -Fuzzy grouping

SSIS Starter kit :- Integrate and Report with PowerView for Excel

SSIS Starter kit :- Integrate and Report with PowerView for Excel

SSIS Starter kit- basics of using few common SSIS tasks

SSIS Starter kit- basics of using few common SSIS tasks

Performance Comparison of ETL Methods

Performance Comparison of ETL Methods

Fill Factor and page splits explained:- Primer

Fill Factor and page splits explained:- Primer

Comparison of Hashing vs Encryption in MS SQL Server

Comparison of Hashing vs Encryption in MS SQL Server

Autogrowth | Trace flag | proportional filling | MS SQL

Autogrowth | Trace flag | proportional filling | MS SQL

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

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

User Defined Server Roles in MS SQL Server

User Defined Server Roles in MS SQL Server

Performance Tuning CPU issues with indexes

Performance Tuning CPU issues with indexes

Delayed Durability vs Optimistic Concurrency which is better for write performance?

Delayed Durability vs Optimistic Concurrency which is better for write performance?

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

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

Export database from Windows Azure

Export database from Windows Azure

MS SQL Server Database mirroring

MS SQL Server Database mirroring

Introducing AlwaysOn in Microsoft SQL Server - Part 1

Introducing AlwaysOn in Microsoft SQL Server - Part 1

Step by Step - Setup and configure AlwaysON - Part 2

Step by Step - Setup and configure AlwaysON - Part 2

Step by Step - SSIS Execute SQL Task - Part 5

Step by Step - SSIS Execute SQL Task - Part 5

Step by Step - SSIS Merge Join, lookup Task -Part 4

Step by Step - SSIS Merge Join, lookup Task -Part 4

Step by Step - SSIS term extraction -Part 3

Step by Step - SSIS term extraction -Part 3

Step by Step - Partitioning Piece Meal Restores Vs Distributing IO - Part 3

Step by Step - Partitioning Piece Meal Restores Vs Distributing IO - Part 3

Step by Step - SSIS Exporting data to Excel - Part 2

Step by Step - SSIS Exporting data to Excel - Part 2

Step by Step - SSIS Import Data - Part 1

Step by Step - SSIS Import Data - Part 1

Step by Step - Creating Partition Tables using T-SQL - Part 2

Step by Step - Creating Partition Tables using T-SQL - Part 2

Step by Step - Upgrade and AWS EC2 instance after attaching a Drive - Part 2

Step by Step - Upgrade and AWS EC2 instance after attaching a Drive - Part 2

Step by Step - Upgrade a EC2 Instance and Add a HDD - Part 1

Step by Step - Upgrade a EC2 Instance and Add a HDD - Part 1

Creating and scheduling Maintenance Plans - SQL Server

Creating and scheduling Maintenance Plans - SQL Server

Implementing Login and Users - principle of least privileges.

Implementing Login and Users - principle of least privileges.

Connecting using Excel In built drivers

Connecting using Excel In built drivers

Connecting to MSSQL via Excel

Connecting to MSSQL via Excel

Step by Step - Creating a Profiler Trace - Part 1

Step by Step - Creating a Profiler Trace - Part 1

Step by Step - Creating a Server Side trace - Part 3

Step by Step - Creating a Server Side trace - Part 3

Step by Step - Profiler templates - Part 2

Step by Step - Profiler templates - Part 2

Step by Step- Database backups SQL Server - Part 1

Step by Step- Database backups SQL Server - Part 1

Step by Step - Backups and restoring end to end - Point in time Recovery SQL Server - Part 3

Step by Step - Backups and restoring end to end - Point in time Recovery SQL Server - Part 3

Step by Step - Transaction Log backup and restore - Part 4

Step by Step - Transaction Log backup and restore - Part 4

Step by Step - Restoring a database SQL Server - Part 2

Step by Step - Restoring a database SQL Server - Part 2

Working with Maintanence Plans in MS SQL Server

Working with Maintanence Plans in MS SQL Server

Configure Listener, Failover and troubleshoot AlwaysOn - Part 3

Configure Listener, Failover and troubleshoot AlwaysOn - Part 3

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

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

TrainXL.com : A whole new way to train.

TrainXL.com : A whole new way to train.

Connecting and viewing SQL data in MS Excel

Connecting and viewing SQL data in MS Excel

Creating your first report using SSRS

Creating your first report using SSRS

Create a cube

Create a cube

Create a procedure and view within MS SQL Server and access tables , views etc within Excel

Create a procedure and view within MS SQL Server and access tables , views etc within Excel

Creating a table , database and importing data from excel

Creating a table , database and importing data from excel

Exporting Data from SQL Server using the Wizard

Exporting Data from SQL Server using the Wizard