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.