MS-SQL Server - A BasThar (बसठार) from विकल्प

A BasThar (बसठार) from विकल्प

MS-SQL Server - A different approach can sometime collapse the mountain of problems

A different approach can sometime collapse the mountain of problems

MS-SQL Server - SUM, AVG & InstallShield Issue

SUM, AVG & InstallShield Issue

MS-SQL Server - समर्थ तकनीक

समर्थ तकनीक

MS-SQL Server - DMV Maintenance

DMV Maintenance

MS-SQL Server - Designate a Fail-Safe Operator

Designate a Fail-Safe Operator

MS-SQL Server - Memory High, Raiserror & Waittype Analysis

Memory High, Raiserror & Waittype Analysis

MS-SQL Server - Patindex, Rank, Joins and Linked Servers

Patindex, Rank, Joins and Linked Servers

MS-SQL Server - Divides one number by another, Physical Joins, SQLSORT_NORMMUTEX and Cycle error log

Divides one number by another, Physical Joins, SQLSORT_NORMMUTEX and Cycle error log..

MS-SQL Server - Database Urgent Scenario

Database Urgent scenario

MS-SQL Server - Topics

WLHG Operator / Clauses and Waittypes, Schedules, String functions, Virtual Machine.

MS-SQL Server - Scheduled Agent Jobs, RTM Releases, Read XML, Estimates & Build Versions 2019

Scheduled Agent Jobs, RTM Releases, Read XML, Estimates & Build Versions 2019

MS-SQL Server - Purchase, Installation, Waittype 'ERROR_REPORTING_MANAGER' and Auto Insert

Purchase, Installation, Waittype 'ERROR_REPORTING_MANAGER' and Auto Insert

MS-SQL Server - Data Validation while Replication & Join Examples

Data Validation while Replication & Join Examples

MS-SQL Server - बौदिक (Baudik of Checkpoint)

बौदिक (Baudik of Checkpoint)...

MS-SQL Server - Introducing Online Shopping Upcoming [Commercial E-Database Portal] sendmychoice.com

Respected All,

We are an upcoming portal for online shopping for WHOLESALE B2B.

MS-SQL Server - Make Endpoint Setup, Routine DBA Checklist & Visiting Error Logs

Make Endpoint Setup, Routine DBA Checklist & Visiting Error Logs

MS-SQL Server - Antivirus Exclusions, Joins & Migration to Azure SQL

Antivirus Exclusions, Joins & Migration to Azure SQL

MS-SQL Server - Port and Fresh Security Tips

Port and Fresh Security Tips

MS-SQL Server - Go Keyword, SP Rename & Joins, HKCS_PARALLEL_MIGRATION, HTBUILD

Go Keyword, SP Rename & Joins

MS-SQL Server - Modifying Scheduled Jobs

Modifying Scheduled Jobs

MS-SQL Server - तासूद

तासूद

MS-SQL Server - The 'SURMA' Occasion

The SURMA Occasion

MS-SQL Server - Rani, Pluto & D-Naming Rules

Rani, Pluto & D-Naming Rules

MS-SQL Server - Add an Index, Keys has Maintenance for Mission Critical Applications & Hotfix

Add an Index, Keys has Maintenance for Mission Critical Applications & Hotfix

MS-SQL Server - ROWCOUNT, CXPACKET & AUDIT_XE_SESSION_MGR & AUDIT_GROUPCACHE_LOCK

ROWCOUNT

MS-SQL Server - Rename Object & Understanding WKT (Well Known Text)

Rename Object & Understanding WKT (Well Known Text)

MS-SQL Server - Technique to Fetch Fragmentation

Technique to Fetch Fragmentation.

MS-SQL Server - Topics & Waittypes

Topics

MS-SQL Server - Benefits of Unique and Non Clustered Index?

Benefits of Unique and Non Clustered Index?

MS-SQL Server - Performance Impact Having Just Non Clustered Index & sqlcmd by Run

Performance Impact Having Just Non Clustered Index & sqlcmd by Run

MS-SQL Server - Network Interfaces Error, Hangs, Write-Ahead Logging & Buffer Manager

Network Interfaces Error, Hangs, Write-Ahead Logging & Buffer Manager

MS-SQL Server - तारीफ (A Praise)

तारीफ (A Praise)

MS-SQL Server - Visiting Error Logs

Visiting Error Logs

MS-SQL Server - विचार

विचार

MS-SQL Server - Variables, High Availability, Dashes & Retrieve Millions of Records

Variables, High Availability, Dashes & Retrieve Millions of Records

MS-SQL Server - TEJU - Imp. Configurations

TEJU - Imp. Configurations

MS-SQL Server - Rank, Joins, Features, Versions, Job Schedule Query & 'WHERE' (A Questionnaire)

Rank, Joins, Features, Versions, Job Schedule Query & 'WHERE' (A Questionnaire)

MS-SQL Server - विचार

विचार

MS-SQL Server - CLR & Boolean Data Type

CLR & Boolean Data Type

MS-SQL Server - MBC Of Database Architecture, Schedule Jobs & Tools

MBC Of Database Architecture, Schedule Jobs & Tools

MS-SQL Server - Keys & Constraints & Shrink a File

Keys & Constraints & Shrink a File

MS-SQL Server - Monitoring Heartbeat, Diagram & Type of Keys & Constraints

Monitoring Heartbeat, Diagram & Type of Keys & Constraints

MS-SQL Server - HEADERONLY, Max Worker Threads, Oldest_Page, HOST_NAME & Tail-Log Backup

MS-SQL Server - HEADERONLY, Max Worker Threads, Oldest_Page, HOST_NAME & Tail-Log Backup

MS-SQL Server - SSRS with HTTP & Buffer Pool extension

Buffer Pool Extension.

MS-SQL Server - Table Variable, Schedule Job, NOLOCK & Developer Edition

Table Variable, Schedule Job, NOLOCK & Developer Edition

MS-SQL Server - Goodness of Gunya

Goodness of Gunya

MS-SQL Server - खरा काम

खरा काम

MS-SQL Server - SET STATISTICS IO, CLR & MERGE

SET STATISTICS IO, CLR & MERGE

MS-SQL Server - Hardware and Software Requirements

Hardware and Software Requirements

MS-SQL Server - Identity, Parse & Failover Cluster

Identity, Parse & Failover Cluster

MS-SQL Server - Business Intelligence & Alter Index

Business Intelligence & Alter Index

MS-SQL Server - SAN

SAN

MS-SQL Server - Maintenance, Roles, Administer, Partial Bkp of a Read-only DB & Naming Standards

Maintenance, Roles, Administer, Partial Bkp of a Read-only DB & Naming Standards

MS-SQL Server - सुविचार

सुविचार

MS-SQL Server - Ultimate Pivot, TRY Catch EH & Round

Ultimate Pivot, TRY Catch EH & Round

MS-SQL Server - Current or Latest Version & A Unique Index

Current or Latest Version & A Unique Index

MS-SQL Server - These Hail from RAM & SAN

These Hail from RAM & SAN

MS-SQL Server - Lightweight Pooling & New Standard Edition

Lightweight Pooling & New Standard Edition

MS-SQL Server - Checkpoint, PLE, Scheduler, RMO Concepts & Always On

Checkpoint, PLE, Scheduler, RMO Concepts & Always On

MS-SQL Server - विचार

विचार

MS-SQL Server - अनुसरण (Part II)

अनुसरण (Part II)

MS-SQL Server - JDBC, Execute As & Min server memory

JDBC, Execute As & Min server memory

MS-SQL Server - Sum, First Value & Management Studio Installation Steps

Sum, First Value & Management Studio Installation Steps.

MS-SQL Server - Joins, Attributes, Tail Log Backup & Live Query Statistics

Joins, Attributes, Tail Log Backup & Live Query Statistics

MS-SQL Server - Configuration & Junction Table

Configuration & Junction Table

MS-SQL Server - Virtual Machine Stuck

Is SQL server installation on Azure VM is stuck?

MS-SQL Server - Uniqueidentifier

Uniqueidentifier

MS-SQL Server - Duplicate, NC Index & A Quality of Joins

Duplicate, NC Index & A Quality of Joins

MS-SQL Server - विचार

विचार

MS-SQL Server - Hang, Threads, Fix 2705 & WaitTypes

Hang, Threads, Fix 2705 & WaitTypes

MS-SQL Server - The Attraction of I (आई)

The Attraction of I (आई)

MS-SQL Server - Identity, Keys & Constraints, Schedule Job

Identity, Keys & Constraints, Schedule Job

MS-SQL Server - अंतर

अंतर

MS-SQL Server - Technicality of Zero if Null

Technicality of Zero if Null

MS-SQL Server - अनुसरण

अनुसरण

MS-SQL Server - विचार का जिक्र

विचार का जिक्र

MS-SQL Server - अनदेखा

अनदेखा

MS-SQL Server - Block एक क्षण

Block एक क्षण

MS-SQL Server - Certification Courses, LogShipping & Background Writer Pages/sec

Certification Courses, LogShipping & Background Writer Pages/sec

MS-SQL Server - विचार

विचार

MS-SQL Server - Business RFC, Waittypes, Buffer Manager & Limit

Business RFC, Waittypes, Buffer Manager & Limit..

MS-SQL Server - Smallmoney DataType & Understanding Checkpoint

Smallmoney DataType & Understanding Checkpoint

MS-SQL Server - Fix Error of Message 245 & Access Denied

Fix Error of Message 245 & Access Denied..

MS-SQL Server - Joint Mentor

Joint Mentor

MS-SQL Server - विचार

विचार

MS-SQL Server - सच से शांति (Part II)

सच से शांति (Part II)

MS-SQL Server - सच से शांति

सच से शांति

MS-SQL Server - Database Mail

Database Mail

MS-SQL Server - अनदेखा

अनदेखा

MS-SQL Server - Best Role for Key Stored Procedures & Index Maintenance

Best Role for Key Stored Procedures & Index Maintenance

MS-SQL Server - Topics for Today

Topics

MS-SQL Server - Smallint, Core Based Licensing & Upgrade

Smallint, Core Based Licensing & Upgrade

MS-SQL Server - विचार

विचार

MS-SQL Server - Mohambu 'LOAD'

Mohambu 'LOAD'

MS-SQL Server - Sync & ASYNC_NETWORK_IO Waittype

Sync & ASYNC_NETWORK_IO Waittype.

MS-SQL Server - विश्वास

विश्वास

MS-SQL Server - UTC Datetime & Network Configuration

UTC Datetime & Network Configuration

MS-SQL Server - Most Hangs by RAM, Backup, Buffer Pool Extn. & Reason for Waittypes

Most Hangs by RAM

MS-SQL Server - प्रभाव

प्रभाव

MS-SQL Server - Server Roles

Server Roles

MS-SQL Server - विचार

विचार

MS-SQL Server - Just Date & Ambiguous Column Error

Just Date & Ambiguous Column Error

MS-SQL Server - Tail Log Backup, NTLM & Joins

Tail Log Backup.

MS-SQL Server - Timestamp in Full-Text Search

 Timestamp in Full-Text Search

MS-SQL Server - SSIS एक तारा (Part 3)

SSIS एक तारा (Part 3)...

MS-SQL Server - Memory Usage

Memory Usage

MS-SQL Server - विचार

विचार

MS-SQL Server - DMV & NORECOMPUTE

DMV & NORECOMPUTE.

MS-SQL Server - Freelancing, Builds & Dynamic Data Masking

Freelancing, Builds & Dynamic Data Masking

MS-SQL Server - Special Characters & Objects

Special Characters & Objects

MS-SQL Server - Humble Request

Humble Request

MS-SQL Server - More Records

More Records

MS-SQL Server - Input Perameters & Various Data Types

Input Perameters & Various Data Types..

MS-SQL Server - विचार (A Punjabi)

A Punjabi.

MS-SQL Server - Concept of Receiving Alerts

Concept of Receiving Alerts

MS-SQL Server - Target Recovery Time & Trim

Target Recovery Time & Trim

MS-SQL Server - जैसा डेटाबेस वैसी एप्लीकेशन (एक मन का भाव)

जैसा डेटाबेस वैसी एप्लीकेशन (एक मन का भाव).

MS-SQL Server - May be dream but a story to learn

May be dream but a story to learn

MS-SQL Server - GAM, SGAM, PFS & Hung Process by Blocking

GAM, SGAM, PFS & Hung Process by Blocking

MS-SQL Server - विचार

विचार.

MS-SQL Server - Partitioning & Much of Gulal (By Waittypes)

Partitioning

MS-SQL Server - SSAS, SSIS & Business Intelligence

SSAS, SSIS & Business Intelligence...

MS-SQL Server - विचार

विचार 

MS-SQL Server - हिसाब ने दिया बड़ा जवाब

हिसाब ने दिया बड़ा जवाब

MS-SQL Server - Best and Some Key System Procedures

Best and Some Key System Procedures

MS-SQL Server - विचार

विचार

MS-SQL Server - Virtual Machine & Prerequisites for FC

Virtual Machine & Prerequisites for FC..

MS-SQL Server - इक्यावन से शुरुवात

इक्यावन से शुरुवात

MS-SQL Server - SUM & AVG Functions

SUM & AVG Functions

MS-SQL Server - Raiserror, Diagram & Type of Joins

Raiserror, Diagram & Type of Joins

MS-SQL Server - Mechanism of Database

Mechanism of Database

MS-SQL Server - विचार

विचार

MS-SQL Server - Structure by Database Diagram

Structure by Database Diagram.

MS-SQL Server - AdventureWorks Sample

AdventureWorks Sample

MS-SQL Server - Azure Guidance for Sarbanes Oxley (SOX)

Azure Guidance for Sarbanes Oxley (SOX).

MS-SQL Server - DBA Role to Monitor

DBA Role to Monitor....

- Buffer Cache Hit Ratio

- Disk I/O by Average Disk Queue Length

MS-SQL Server - Make DB Read Only

Make DB Read Only..

MS-SQL Server - Alter Index {MaxDOP}

Alter Index {MaxDOP}

MS-SQL Server - Most Incoming Calls

Most Incoming Calls

MS-SQL Server - Ansi_Warnings

ANSI_WARNINGS

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver16

MS-SQL Server - विचार

विचार

MS-SQL Server - A Satisfied Client

A Satisfied Client

MS-SQL Server - Core Basic Ornaments of Enterprise Edition

Core Basic Ornaments of Enterprise Edition

MS-SQL Server - Shrink, Pivot, Maintenance & Mark

Shrink, Pivot, Maintenance & Mark

MS-SQL Server - Generate GUID on Insert

Generate GUID on Insert

MS-SQL Server - विचार

विचार..

MS-SQL Server - विचार

विचार

MS-SQL Server - विचार का शिष्टाचार

विचार का शिष्टाचार..

MS- SQL Server - Tail-Log Backup

Tail-Log Backup

MS-SQL Server - CHIP-CAL (A Desired Configuration)

CHIP-CAL (A Desired Configuration)

MS-SQL Server - Advertisement

Respected Blog Readers,

MS-SQL Server - Restore & Opinion

Restore..

MS-SQL Server - Technical Agenda

Technical Agenda

MS-SQL Server - Sharding & Character

Sharding & Character

MS-SQL Server - Color Illustration

Color Illustration

MS-SQL Server - Jor Jemry & Joins

Jor Jemry & Joins

MS-SQL Server - A Core Points of SQL Azure

A Core Points of SQL Azure

MS-SQL Server - चित्र (A Design from Architecture)

चित्र (A Design from Architecture)

MS-SQL Server - SSIS एक तारा (Part 2)

SSIS एक तारा (Part 2)..

MS-SQL Server - Backup Retention Policy

Backup Retention Policy

MS-SQL Server - Ghada (A Kalash, Full of Unique Things)

Ghada (A Kalash, Full of Unique Things)

MS-SQL Server - विचार

विचार

MS-SQL Server - Import Export, OEM & CREAM Alerts

Import Export, OEM & CREAM Alerts...

MS-SQL Server - An English Vision

An English Vision 

MS-SQL Server - DEV, TRI & Purchase

DEV, TRI & Purchase

MS-SQL Server - Dhai (A Numeric 2.5)

Dhai (A Numeric 2.5)

MS-SQL Server - Fantastic Old Driver

Related Link...

MS-SQL Server - OLE DB

OLE DB

MS-SQL Server - ReOrganize

MS-SQL Server - ReOrganize

MS-SQL Server - MUSHK & OLTP

MUSHK & OLTP

MS-SQL Server - Business Intelligence Tips (PEARL, Our Offline Assignment)

Business Intelligence Tips (PEARL, Our Offline Assignment)....

MS-SQL Server - विश्वास

विश्वास

MS-SQL Server - Cost Base of Editions - Aim of Article

Cost Base of Editions - Aim of Article

MS-SQL Server - SSIS एक तारा

SSIS एक तारा

MS-SQL Server - Should-Kani

 Should-Kani

MS-SQL Server - Best Seller Industry

Best Seller Industry.

MS-SQL Server - See Bak & Diff

See Bak & Diff

MS-SQL Server - DNS Server

DNS Server..

MS-SQL Server - अनदेखा (एक जुनून)

अनदेखा

MS-SQL Server - MIG On Idea

MIG On Idea.

MS-SQL Server - धाक (A REPUTATION)

धाक (A REPUTATION)

MS-SQL Server - UJAJWA & Logs

UJAJWA & Logs..

MS-SQL Server - Dense Rank

Dense Rank

https://learn.microsoft.com/en-us/sql/t-sql/functions/dense-rank-transact-sql?view=sql-server-ver16

MS-SQL Server - Truncate, Delete & TAT

Truncate, Delete & TAT

MS-SQL Server - क्रम & छोर of Database

क्रम & छोर of Database

MS-SQL Server - Lokyash and EndPoints

Lokyash and EndPoints

MS-SQL Server - A Basic Side

A Basic Side..!

MS-SQL Server - SHLIVA, Slab & Ultimate Pivot

SHLIVA, Slab & Ultimate Pivot..

MS-SQL Server - DT-CITL & परिदृश्य

DT-CITL & परिदृश्य

MS-SQL Server - Memory Leak / High & Cu-Updates

Memory Leak / High & Cu-Updates..

MS-SQL Server - GoFrag 'Resume Performance'

GoFrag 'Resume Performance'

MS-SQL Server - Article for Utility and Unique Indexes

Article for Utility and Unique Indexes

MS-SQL Server - Attribute & JEAVE & WaitTypes

Attribute, JEAVE & WaitTypes

MS-SQL Server - A PK Mandatory

A PK Mandatory

MS-SQL Server - Exam for Tuning & Tracing

Exam for Tuning & Tracing

MS-SQL Server - For Tune 6000 Series

For Tune 6000 Series

MS-SQL Server - Spatial, Rank, Locks & Ondemand eBook

Spatial, Rank, Locks & Ondemand eBook

MS-SQL Server - Gain Your Knowledge on JRH

Gain Your Knowledge on JRH

MS-SQL Server - Fast & SSIS

Fast & SSIS

MS-SQL Server - प्राचीन आर

Deprecated Features starting from R....! 

MS-SQL Server - Neash-Adro

Neash-Adro

MS-SQL Server - Hex and Tune-art

Hexagon

MS-SQL Server - M-J-M

M-J-M

MS-SQL Server - Reason DB

Reason DB

MS-SQL Server - Ponk - ABC

Ponk - ABC

MS-SQL Server - Manclute Practical

Manclute Practical

MS-SQL Server - विचार - Devotion

Devotion

MS-SQL Server - Voisy Network Team

Voisy Network Team

MS-SQL Server - Dhab & Raid

Dhab & Raid

MS-SQL Server - Victory for Sure

Victory for Sure...

MS-SQL Server - Opposite

Opposite

MS-SQL Server - Materialised View & MTA

MS-SQL Server - Materialised View

MS-SQL Server - A Divine Technology

A Divine Technology

MS-SQL Server - Partitioned Table and Indexes

Partitioned Table and Indexes

MS-SQL Server - Understand Hangs

Understand Hangs

MS-SQL Server - SME-Aligned Index

SME-Aligned Index

MS-SQL Server - Architecture of Flush Cache

Architecture of Flush Cache 

MS-SQL Server - Backup One Liner

Backup One Liner

MS-SQL Server - Linked Server & ROBO

Linked Server & ROBO

MS-SQL Server - A HAS MAZIK

A HAS MAZIK

MS-SQL Server - Basic Business

 Basic Business

MS-SQL Server - विचार - Truth vs Lie

May be a dream but a story to learn...

MS-SQL Server - Language

Language

MS-SQL Server - NEANJ

NEANJ

MS-SQL Server - Replication Waittype & HostName

Replication Waittype & HostName

MS-SQL Server - Restore Headeronly

Restore Headeronly

MS-SQL Server - Index Update

Index Update

MS-SQL Server - I 'BA' Meant

I 'BA' Meant

MS-SQL Server - Basic Help of RKJ

Basic Help of RKJ

MS-SQL Server - अंतर

अंतर 

MS-SQL Server - Re-CLAIM Space

Re-CLAIM Space

MS-SQL Server - Basic Help on 'Workbench'

Basic Help on 'Workbench'

MS-SQL Server - Always Encrypted

Always Encrypted

MS-SQL Server - How? You Ask Me!

How? You Ask Me !

MS-SQL Server - Not a Bit Datatype

Not a Bit Datatype

MS-SQL Server - An Option of Retry Attempts

Retry Attempts

MS-SQL Server - Update Statistics

Update Statistics

MS-SQL Server - Determination

Determination

MS-SQL Server - My Urgent Items

My Urgent Items

MS-SQL Server - String_Agg

Aggregate Functions

MS-SQL Server - Show Table

Show Table

MS-SQL Server - MAH of OS! Why?

MAH of OS! Why?

MS-SQL Server - Ghorak

Ghorak

MS-SQL Server - Race Conditions and Deadlocks

Race Conditions and Deadlocks

MS-SQL Server - SANSQL And AD

SANSQL And AD

MS-SQL Server - Dhurbi

Dhurbi

MS-SQL Server - Thank God I am Busy!

Thank God I am Busy!

MS-SQL Server - Communication

Communication

MS-SQL Server - Why I Need Filestream Storage?

Why I Need Filestream Storage?

MS-SQL Server - अतिरिक्त सेवाएं

May be Dream but a story to learn.

MS-SQL Server - Ganga

Ganga

MS-SQL Server - Query JOANS

Query JOANS

MS-SQL Server - Allocating Space for Job History

Allocating Space for Job History

MS-SQL Server - Patching

Patching

MS-SQL Server - Lakshya (A Target)

Lakshya (A Target)

MS-SQL Server - First Well Key Role

First Well Key Role

MS-SQL Server - Best Working DBA

Best Working DBA

MS-SQL Server - Key Transactions

Key Transactions

MS-SQL Server - 'I Had' - A Cure

I Had - A Cure

MS-SQL Server - Architect Level

Architect Level

MS-SQL Server - Cycle Error Log

Cycle Error Log

MS-SQL Server - कर्ता (A Worker)

कर्ता (A Worker)

MS-SQL Server - BI Talk or BAAT

BI Talk or BAAT

MS-SQL Server - Peer to Peer Replication

Peer to Peer Replication

MS-SQL Server - विचार

May be Dream but A Story to Learn

MS-SQL Server - Understood

Understood

MS-SQL Server - B-Comp

B-Comp

SQL Server - Job work is active... How?

Job work is active! How?

SQL Server - Shiksha of The Power of Port

Shiksha of The Power of Port

SQL Server - व्यवसाय का विस्तार

आदरणीय सभी,

SQL Server - AU_Kit- -A Space_Impact

AU_Kit- w -A Space_Impact

SQL Server - Quick DBA

Quick DBA

SQL Server - T-RAM - And - YAN_ART Configuration

T-RAM - And - YAN_ART Configuration

SQL Server - Benefits of The YCA

Benefits of The YCA

SQL Server - Composer

Composer

SQL Server - O-Tips

O-Tips

SQL Server - What's new in this Application?

What's new in this Application?

SQL Server - Path to Purchase

Just Another Article.....

SQL Server - SHAAR Permissions

SHAAR & ERRORS

SQL Server - L&W

Lookup Transformation

SQL Server - Phaot_Optimisation

Performance of High Availability and Optimisation Techniques

SQL Server - Global Temp Table

Global Temp Table

SQL Server - TEEJ

- Table Partitioning

https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16

- Enterprise Edition Features

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16

Job Schedule

https://learn.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver16

Best Regards

Amit Vaid

SQL Server - मर्द (Mard, A Man of Database

M a r d , A Man of Database....

SQL Server - Khopra

Khopra

- Keys and Constraints

- High Availability features

- OLTP

- Profiler

- Roles

- Authentication

Note:- This is also known as dry coconut in India.

Best Regards

Amit Vaid

SQL Server - क्रीड़ा (A Game)

All Blog Readers and Visitors,

I will be happy to have a game page to learn with fun on this blog.

Please share your valuable feedback to initiate the same.

Best Regards 

Amit Vaid

SQL Server - Cluster

Related articles...

SQULERVERY

Respected Blog Readers,

We are just trying to make a difference for MSSQL Database and going forward would soon be calling 'Squlervery' to SQL specific database server in our blog.

Feel free to share your opinion on the same.

Please advice.

Sincerely,

Amit Vaid

amitvaid81@gmail.com

SQL Server - Substring (Managed Services)

Substring (Managed Services)

SQL Server - Critical Events IDs and Keywords T-SQL

Where can I find critical/important event IDs to monitor in SQL Server?

with its definition explained?

Please send an email to amitvaid81@gmail.com

Additionally,

1. Reserved Keywords (Transact-SQL)

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver16

2. Granting permissions

GRANT SELECT ON dbo.myTable TO amitv

GRANT VIEW ANY DEFINITION TO amitv

Best Regards

Amit Vaid

SQL Server - ABC

The meaning of ABC always differs for level of experience.

For Beginners and Juniors

A - Architecture and ACID definition

B - Begin Tran and Backup types

C - Checkpoint and CheckDB (DBCC)

For Seniors and Leadership

A - Automation and Analysing Performance

B - Builds, Bulk Logged and other recovery models

C - Collation and Configuration Settings

While learning A-to-Z we will reach SQL Azure 🌹🙏🌞

Best Regards, 

T. Amit Vaid S.

SQL Server - Checkpoint

SQL Server Checkpoint

- Causes for Checkpoint

Please call me anytime to discuss the same.

https://learn.microsoft.com/en-us/sql/relational-databases/logs/database-checkpoints-sql-server?view=sql-server-ver16

Best Regards

Amit Vaid

SQL Server - Certification

Latest Course Announced by Microsoft

SQL Server - A Passionate DBA

1. Three Tables, Two Views ...... (a dba has created)

SQL Server - Other Stuff - Feb (A)

There are different ways to find disk latency issues.

- Performance Monitor (Perfmon)

- Virtual File Stats

- OS Wait Types

SQL Server - sqlncli11.lib Related Hyperlink

sqlncli11.lib

SQL Server – Ultimate Pivot

Pivot

SQL Server - VisKey

There are so many short cuts one can quickly learn to recall their routine DBA activities.

SQL Server - SUM, COUNT, and AVG Functions

SUM FUNCTION

SQL Server - SA Account

SQL Server - SA Account

SQL Server - 'DHYAN' An Attention

'DHYAN' An Attention

SQL Server - MaxDOP Configuration

Configure the max degree of parallelism Server Configuration Option

SQL Server - LAG Funtion

SQL Server - LAG (Transact-SQL)

https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16

SQL Server - Sample and Model Database

Sample Database

https://learn.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16

SQL Server - AVG function

Average Function

SQL Server - OLE Automation Procedure

How to enable OLE automation procedures to be able to execute OA procedures

SQL Server - Merge Column

Here we will learn on how can we combine two or more columns in a SQL query.

 

SQL Server - G Diamonds

Some of the SQL Server 'G' Diamonds

SQL Server - Auto Delete

Auto Deletion

SQL Server - ENTRE

'ENTRE'  is nothing but one thing in common as it starts from 'E' and ends at 'E' only.

SQL Server - Nomenclature

       Are you KEEN to know major components from SDS's Nomenclature while FACING performance issue?

SQL Server - Matching Role

Its quite common that sometime we give role that doesn't suit with the actual requirement.

SQL Server - Dedicated Admin Connection

DAC

SQL Server - Stored Procedure Into table

Here some steps to capture the procedure's output into temp table.  

SQL Server - Remove Existing Column

Remove Existing Column