SQL DBA Support by T. Amit Vaid S. - Knowledge Centre for DBAs: 2023

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

Wednesday, March 8, 2023

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

Sunday, March 5, 2023

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.

Sunday, February 19, 2023

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

Monday, February 13, 2023

SQL Server - Certification

Latest Course Announced by Microsoft

SQL Server - A Passionate DBA

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

Saturday, February 11, 2023

SQL Server - Other Stuff - Feb (A)

There are different ways to find disk latency issues.

- Performance Monitor (Perfmon)

- Virtual File Stats

- OS Wait Types

Tuesday, February 7, 2023

SQL Server - sqlncli11.lib Related Hyperlink

sqlncli11.lib

Sunday, February 5, 2023

SQL Server – Ultimate Pivot

Pivot

Wednesday, February 1, 2023

SQL Server - VisKey

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

Monday, January 30, 2023

SQL Server - SUM, COUNT, and AVG Functions

SUM FUNCTION

SQL Server - SA Account

Wednesday, January 25, 2023

SQL Server - 'DHYAN' An Attention

'DHYAN' An Attention

Tuesday, January 24, 2023

SQL Server - MaxDOP Configuration

Configure the max degree of parallelism Server Configuration Option

Monday, January 23, 2023

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

Friday, January 20, 2023

SQL Server - Sample and Model Database

Sample Database

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

Wednesday, January 18, 2023

SQL Server - AVG function

Average Function

Monday, January 16, 2023

SQL Server - OLE Automation Procedure

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

Sunday, January 15, 2023

SQL Server - Merge Column

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

Friday, January 13, 2023

SQL Server - G Diamonds

Some of the SQL Server 'G' Diamonds

SQL Server - Auto Delete

Auto Deletion

Thursday, January 12, 2023

SQL Server - ENTRE

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

Tuesday, January 10, 2023

SQL Server - Nomenclature

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

Monday, January 9, 2023

SQL Server - Matching Role

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