Канал: DB Topics and Tech

tempdb System Database importance and configuration

tempdb System Database importance and configuration

SQL Server Trouble Shooting using Single User Mode

SQL Server Trouble Shooting using Single User Mode

Performance optimization using wait stats( an important technique for performance related issues)

Performance optimization using wait stats( an important technique for performance related issues)

Constant Folding (optimization of some constant expressions )

Constant Folding (optimization of some constant expressions )

Select Query process & optimization through Database Engine

Select Query process & optimization through Database Engine

Query Optimization and Select Query Analysis

Query Optimization and Select Query Analysis

Select Query Operators and Logical Operators Precedence

Select Query Operators and Logical Operators Precedence

Batch Model Execution (Query Execution Methods in Query Plan)

Batch Model Execution (Query Execution Methods in Query Plan)

Query Execution Methods(Row Execution Method) in SQL Server

Query Execution Methods(Row Execution Method) in SQL Server

Alter Index Rebuild (Index maintenance method)

Alter Index Rebuild (Index maintenance method)

Comparison between Rebuild VS Reorganize Index method.

Comparison between Rebuild VS Reorganize Index method.

Alter Index Rebuild Demo using SQL Server management studio

Alter Index Rebuild Demo using SQL Server management studio

Alter Index Reorganize Demo using SSMS.

Alter Index Reorganize Demo using SSMS.

Alter Index Reorganize(Index maintenance method)

Alter Index Reorganize(Index maintenance method)

Index Maintenance Methods

Index Maintenance Methods

Low page density and its problems(index Performance Issue)

Low page density and its problems(index Performance Issue)

Low Page Density ( a big Index Performance Issue)

Low Page Density ( a big Index Performance Issue)

Demo of Index Fragmentation ( An Index Scan Problem)

Demo of Index Fragmentation ( An Index Scan Problem)

Fragmentation problems in SQL Server index

Fragmentation problems in SQL Server index

logical/External Vs Internal Fragmentation in SQL Server Index

logical/External Vs Internal Fragmentation in SQL Server Index

Fragmentation in SQL Server Index

Fragmentation in SQL Server Index

Read-Ahead Demo (how it works in SQL Server using Index Scan)

Read-Ahead Demo (how it works in SQL Server using Index Scan)

Read-ahead mechanism for Index Scanning

Read-ahead mechanism for Index Scanning

Allocation Order Scans or Physical Scan in SQL Server Index Structure

Allocation Order Scans or Physical Scan in SQL Server Index Structure

Ordered Scan Or Key Order or Logical Index Scan in SQL Server

Ordered Scan Or Key Order or Logical Index Scan in SQL Server

Index Scan Access Method

Index Scan Access Method

Practical Demo for singleton lookup/Seek(Index)

Practical Demo for singleton lookup/Seek(Index)

Singleton Lookup/Seek Access Method (Repeated)

Singleton Lookup/Seek Access Method (Repeated)

Singleton Lookup/Seek Access method in Index Structure

Singleton Lookup/Seek Access method in Index Structure

Index Structure Demo

Index Structure Demo

Index Structure

Index Structure

Indexes and Index maintenance in SQL Server

Indexes and Index maintenance in SQL Server

SQL Injection- Prevention

SQL Injection- Prevention

SQL Injection and Example

SQL Injection and Example

Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE)

Demo for Certificates creation ,Encryption & Decryption of Data in SQL Server

Demo for Certificates creation ,Encryption & Decryption of Data in SQL Server

What is Certificate in SQL Server, protection of keys using Certificate

What is Certificate in SQL Server, protection of keys using Certificate

Asymmetric Encryption Demo

Asymmetric Encryption Demo

What is Asymmetric Encryption and how it differs from Symmetric Encryption

What is Asymmetric Encryption and how it differs from Symmetric Encryption

Data Encryption Demo using Symmetric Key (Update the Column in a Table).

Data Encryption Demo using Symmetric Key (Update the Column in a Table).

Symmetric Encryption Demo

Symmetric Encryption Demo

Symmetric Encryption Overview and Demo ,SQL Security

Symmetric Encryption Overview and Demo ,SQL Security

Cryptography in SQL Server used to encrypt and decrypt the data for SQL Server Security.

Cryptography in SQL Server used to encrypt and decrypt the data for SQL Server Security.

SQL Server impersonation/context switching using EXECUTE AS statement

SQL Server impersonation/context switching using EXECUTE AS statement

Permission implementation (SQL Server Security)

Permission implementation (SQL Server Security)

SQL Server Authorization Component(Securable) Demo

SQL Server Authorization Component(Securable) Demo

SQL Server Authorization Component (Principal) Demo

SQL Server Authorization Component (Principal) Demo

Authorization Process in SQL Server Security

Authorization Process in SQL Server Security

SQL Server Authentication Modes and Demo

SQL Server Authentication Modes and Demo

How to Hide SQL Server instance (SQL Server Security Concerns) and PowerShell

How to Hide SQL Server instance (SQL Server Security Concerns) and PowerShell

SQL Server Browser Service Demo(SQL Client connection with SQL Server)

SQL Server Browser Service Demo(SQL Client connection with SQL Server)

SQL Server Security Overview

SQL Server Security Overview

Service Broker Security Implementation When both Services in different instances of SQL Server

Service Broker Security Implementation When both Services in different instances of SQL Server

Service Broker Transport Security

Service Broker Transport Security

Service Broker Dialog Security

Service Broker Dialog Security

Overview of Sys Transmission Queue in Service Broker

Overview of Sys Transmission Queue in Service Broker

Troubleshooting Service broker using sys.transmission_queue

Troubleshooting Service broker using sys.transmission_queue

SQL Server Service Broker - Internal Activation

SQL Server Service Broker - Internal Activation

Service Broker Application where Initiator and Target services are in different databases .

Service Broker Application where Initiator and Target services are in different databases .

Implement of SQL Server Service Broker Application when all object in one Database.

Implement of SQL Server Service Broker Application when all object in one Database.

SQL Server Service Broker Components

SQL Server Service Broker Components

SQL Server Service Broker Architecture

SQL Server Service Broker Architecture

When to Use SQL Server Service Broker

When to Use SQL Server Service Broker

SQL Server Service Broker Introduction

SQL Server Service Broker Introduction

SQL Server Database Mail Demo using SSMS

SQL Server Database Mail Demo using SSMS

SQL Server Database Mail configuration Steps

SQL Server Database Mail configuration Steps

SQL Server Database Mail Architecture

SQL Server Database Mail Architecture

SQL Server Database Mail Introduction

SQL Server Database Mail Introduction

SQL Server automatic database backup Job Schedule considerations

SQL Server automatic database backup Job Schedule considerations

SQL Server database backup schedule configuration using SQL Server Agent Job

SQL Server database backup schedule configuration using SQL Server Agent Job

SQL Server Backup Job configuration using SQL Server Maintenance Plan Wizard

SQL Server Backup Job configuration using SQL Server Maintenance Plan Wizard

Comparing SSAS Tabular and Multidimensional model

Comparing SSAS Tabular and Multidimensional model

SSAS Install prerequisites

SSAS Install prerequisites

OLAP vs OLTP (SSAS Module)

OLAP vs OLTP (SSAS Module)

SSAS- Introduction

SSAS- Introduction

Incremental Data Load using CDC control(Video CDC-3)

Incremental Data Load using CDC control(Video CDC-3)

Change Data Capture (SSIS)(CDC-1)

Change Data Capture (SSIS)(CDC-1)

Initial Load using CDC control(Video CDC-2)

Initial Load using CDC control(Video CDC-2)

SSIS-PIVOT Transformation Control

SSIS-PIVOT Transformation Control

Data Warehouse Basic concepts(SSIS- Module)

Data Warehouse Basic concepts(SSIS- Module)

Transaction Handling in SSIS Package

Transaction Handling in SSIS Package

Slowly Changing Dimension- Transformation and Type 1 and Type 2 Change(SSIS)

Slowly Changing Dimension- Transformation and Type 1 and Type 2 Change(SSIS)

SSIS Project Deployment (Lecture-13)

SSIS Project Deployment (Lecture-13)

SSIS-Parameter Creation and Project Deployment(lecture-) (Lecture-14)

SSIS-Parameter Creation and Project Deployment(lecture-) (Lecture-14)

Checkpoint implementation in SSIS- Project (Lecture-12)

Checkpoint implementation in SSIS- Project (Lecture-12)

SSIS-Project Error handling using Redirect Rows (Lecture-11)

SSIS-Project Error handling using Redirect Rows (Lecture-11)

Basic ETL Package (Data Flow Task )(Lecture-9)

Basic ETL Package (Data Flow Task )(Lecture-9)

ETL package (Data flow task using Transmission) (Lecture-10)

ETL package (Data flow task using Transmission) (Lecture-10)

Control Flow Tasks and designing the Control Flow (Lecture-8)

Control Flow Tasks and designing the Control Flow (Lecture-8)

Creation of SSIS-Project and introduction to Folders and Files (Lecture-7)

Creation of SSIS-Project and introduction to Folders and Files (Lecture-7)

SSISDB-Catalog Properties (Lecture-6)

SSISDB-Catalog Properties (Lecture-6)

creating and configuring SSISDB-Catalog (Lecture-5)

creating and configuring SSISDB-Catalog (Lecture-5)

SSISDB-Catalog Introduction (Lecture-4)

SSISDB-Catalog Introduction (Lecture-4)

SSIS Architecture and Designer introduction(lecture-3)

SSIS Architecture and Designer introduction(lecture-3)

MSBI(Microsoft Business Intelligence) Introduction Lecture-2

MSBI(Microsoft Business Intelligence) Introduction Lecture-2

SQL Server Integration Services(SSIS) Introduction

SQL Server Integration Services(SSIS) Introduction

Transactions Concurrency Problems in SQL Server

Transactions Concurrency Problems in SQL Server

Isolation Level---Read Uncommitted in SQL Server

Isolation Level---Read Uncommitted in SQL Server

Isolation Level---Read Committed in SQL Server

Isolation Level---Read Committed in SQL Server

Isolation Level--Repeatable Read

Isolation Level--Repeatable Read

Isolation Level--- Serializable /Snapshot in sQL Server

Isolation Level--- Serializable /Snapshot in sQL Server

Overview of In-Memory OLTP Technology (SQL Server)

Overview of In-Memory OLTP Technology (SQL Server)

Basic Components of In-Memory OLTP

Basic Components of In-Memory OLTP

Architecture of In-Memory OLTP Technology

Architecture of In-Memory OLTP Technology

Usage Scenarios for In-Memory OLTP

Usage Scenarios for In-Memory OLTP

SQL SERVER In-Memory OLTP Technology Demo

SQL SERVER In-Memory OLTP Technology Demo

SQL Server Extended events overview

SQL Server Extended events overview

Extended Events Architecture

Extended Events Architecture

Extended Event Demo using New Session

Extended Event Demo using New Session

Extended Event Demo using New Session Wizard

Extended Event Demo using New Session Wizard

MS SQL Server Query Store Overview ,Setup and Configurations

MS SQL Server Query Store Overview ,Setup and Configurations

MS SQL Server Query Store Architecture

MS SQL Server Query Store Architecture

MS SQL Server Query Store Reports and Demo

MS SQL Server Query Store Reports and Demo

Regressed Query Demo in Microsoft SQL Server Query Store

Regressed Query Demo in Microsoft SQL Server Query Store

Discussion(Career plan ) with Rizwan Majeed (Head of Development/Smart agriculture Siemens . PART-1

Discussion(Career plan ) with Rizwan Majeed (Head of Development/Smart agriculture Siemens . PART-1

PART-2 with Rizwan Majeed (Head of Development/Smart agriculture Siemens LTD.

PART-2 with Rizwan Majeed (Head of Development/Smart agriculture Siemens LTD.

Introduction to Backup and Recovery Model and Full Recovery Model Details

Introduction to Backup and Recovery Model and Full Recovery Model Details

Copy-Only Backup in SQL Server

Copy-Only Backup in SQL Server

Tail Log Backup in SQL Server

Tail Log Backup in SQL Server

Transaction Log Backup in SQL Server

Transaction Log Backup in SQL Server

Differential Backup in SQL Server

Differential Backup in SQL Server

Full Backup and Recovery in SQL Server

Full Backup and Recovery in SQL Server

Bulk-Logged Recovery Model in SQL Server

Bulk-Logged Recovery Model in SQL Server

Simple Recovery Model in SQL Server

Simple Recovery Model in SQL Server

Policy-Based Management Overview and Introduction

Policy-Based Management Overview and Introduction

On Demand Evaluation Mode (SQL Server Policy-Based Management)

On Demand Evaluation Mode (SQL Server Policy-Based Management)

On Schedule Evaluation Mode (SQL Server Policy-Based Management)

On Schedule Evaluation Mode (SQL Server Policy-Based Management)

On Change: Log Only Evaluation Mode (SQL Server Policy-Based Management)

On Change: Log Only Evaluation Mode (SQL Server Policy-Based Management)

On Change: Prevent (Evaluation Mode in SQL Server Policy-Based Management )

On Change: Prevent (Evaluation Mode in SQL Server Policy-Based Management )

Export & Import Policies in Policy-Based Management (SQL Server)

Export & Import Policies in Policy-Based Management (SQL Server)

Category in Policy-Based Management( SQL Server)

Category in Policy-Based Management( SQL Server)

Central Management Servers(CMS) in SQL Server Policy-Based Management

Central Management Servers(CMS) in SQL Server Policy-Based Management

Online Interview with Mr. Shahid Nawaz (software consultant) from USA

Online Interview with Mr. Shahid Nawaz (software consultant) from USA

SQL Server Stored Procedures, features and implementation of stored procedures

SQL Server Stored Procedures, features and implementation of stored procedures

SQL Server Triggers, DML and DDL Triggers

SQL Server Triggers, DML and DDL Triggers

SQL Server Views , types and purpose of views

SQL Server Views , types and purpose of views

SQL Server Functions ,Uses of Functions and Types of Function

SQL Server Functions ,Uses of Functions and Types of Function

SQL Server constraints

SQL Server constraints

SQL Indexes, their types and Structure of an Index

SQL Indexes, their types and Structure of an Index

Explanation of Query Execution Plan with its steps

Explanation of Query Execution Plan with its steps

Simple Demo for Query Execution Plan

Simple Demo for Query Execution Plan

Demo for Query Execution Plan

Demo for Query Execution Plan

Statistics

Statistics

DBMS SQL SERVER AND Technology Evangelist Live Stream

DBMS SQL SERVER AND Technology Evangelist Live Stream

Login, Database User, Roles, Principal and Schema in SQL SERVER English

Login, Database User, Roles, Principal and Schema in SQL SERVER English

Network/System Admin interview(Part 2) for beginners

Network/System Admin interview(Part 2) for beginners

Network/System Admin interview(Part 1)for beginners

Network/System Admin interview(Part 1)for beginners

Module 5 about Database Files, FileGroup, Principal, Login, User,Role, Schema URDU/HINDI

Module 5 about Database Files, FileGroup, Principal, Login, User,Role, Schema URDU/HINDI

Module 4 Part 2 SQL Server 2017 Server Level configurations ,Service and master Database URDU/HINDI

Module 4 Part 2 SQL Server 2017 Server Level configurations ,Service and master Database URDU/HINDI

DB Module4 Part1 URDU/HINDI(Configuration Manager, SSMS, Authentication and login, System Databases)

DB Module4 Part1 URDU/HINDI(Configuration Manager, SSMS, Authentication and login, System Databases)

Module 3 :SQL Server Architecture in Urdu, Hindi

Module 3 :SQL Server Architecture in Urdu, Hindi

SQL Server Module 2 Part 1(SQL Server Versions and Editions Features comparison, Installation)

SQL Server Module 2 Part 1(SQL Server Versions and Editions Features comparison, Installation)

SQL Server Module 2 Part 2(SQL Server Services and Accounts) Urdu, Hindi

SQL Server Module 2 Part 2(SQL Server Services and Accounts) Urdu, Hindi

DBMS Module 1 Part 2 (DBMS,ACID Properties, SQL Server) Urdu, Hindi

DBMS Module 1 Part 2 (DBMS,ACID Properties, SQL Server) Urdu, Hindi

DBMS Module 1 Part 1(DBMS,ACID, SQL Server) Urdu, Hindi

DBMS Module 1 Part 1(DBMS,ACID, SQL Server) Urdu, Hindi