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

This blog is a journey of SQL Server Professional.

I usually work as a DBA and have been working for performance tuning and high availability features. You can find some of the articles from my own personal real time experience.

Regards,
T. Amit Vaid S.
Average Study 5th Class from Govt. School, New Delhi
(not Pandit by Profession/Religion)
NickNames Goldy and Tamas
Home Page

Eg. Calculation of DB Size If 55000 KB = 53.710 MB then If 6000 MB = 5.859 GB then

Written more than 50 DBA Scripts.

Followers

Blog Archive

► 2024 (27)
- ► September (4)
- ► August (4)
- ► July (4)
- ► June (5)
- ► May (4)
- ► April (2)
- ► March (1)
- ► February (2)
- ► January (1)

▼ 2023 (316)
- ► November (3)
- ► October (12)
- ► September (10)
- ► August (1)
- ► July (9)
- ► June (30)
- ▼ May (70)
- ► April (102)
- ► March (55)
- ► February (7)
- ► January (17)

► 2022 (47)
- ► December (41)
- ► November (6)

► 2011 (1)
- ► June (1)

About Me

Amit Vaids Blog

View my complete profile

Total Page views

Labels/Tags

A Divine Technology (1) acid properties (1) aggregate (1) Aggregate functions (1) alter Index (1) Always Encrypted (1) Architect (1) architecture (2) Assessment Questions (1) Attribute (1) Backup (1) Bak (1) best practices (1) Best seller industry (1) BI Talk or BAAT (1) Business (1) Business in Standard Edition (1) collation settings (1) Communication (1) Compiler (1) configuration (1) Configuration Manager (1) CPU high (1) cumulative updates (1) Cycle Error Log (1) Database Role (1) Datatypes (1) Deadlocks (1) Delete (1) Dense Rank (1) Determination (1) Devotion (1) Dhaak (1) Dhab (1) Dhai (1) Dhurbi (1) diff (1) Distribution Database (1) DNS Server (1) drop table (1) duplicate records (1) eBook (1) Enable Filestream storage (1) Enable Trace (1) Exam for Tuning & Tracing (1) Failover Cluster (1) fatal errors (1) Filestream (1) flush cache (1) Ganga (1) Ghorak (1) Group by clause (1) Hang (1) Help (3) Hex (1) high availability (1) hostname (1) hotfixes (1) index reorganize (1) Index Update (1) isolation level (1) Isolation levels (1) Joins (2) jor jemry (1) Karta a worker (1) Lakshya (1) Language (1) latch (1) linked server (1) Lock Escalation (1) logshipping (1) Logspace (1) MAH of OS (1) Manclute (1) Materialized view (1) maxdop (1) May be Dream (14) mirroring (1) Msdb database (1) MTA Certification (1) Mushk (1) NEANJ (1) Neash-adro (1) Network Issues (1) numeric datatype (1) OLEDB (1) OLTP (1) Opposite (1) parameters (1) Partitioned tables (1) Patching and Upgrade (1) PCI compliance (1) Pearl (1) Peer to Peer Replication (1) performance (1) Pivot (1) Ponk (1) Powershell (1) Query JOANS (1) Race Conditions (1) Raid Level (1) Rank (1) Re-Claim Space (1) Reason DB (1) recommendations (1) Redundancy with Replication (1) remove column (1) Reorganize (1) Replication (1) Replication prerequisites (1) Restore Headeronly (1) Retry Attempts (1) Robocopy (1) Sample database (1) SANSQL (1) Scenario (1) SHLEIVA (1) Show Tables (1) Slab (1) Spatial (1) SQL Environment (1) SQL Profiler (1) SQL Server Agent (1) SQL Server FAQs (1) SQL Server hangs or hung (1) SQL server practical (1) SSIS (2) t-sql functions (1) table Hints (1) TABLOCKX (1) tail log backup (1) Tail-log backup (1) tech antons (1) Technical Reason for Indexing (1) timestamp autoupdate (1) Total vs Target Memory (1) Transactions (1) trn (1) Truncate table (1) Ujajwa (1) Unique index (1) Update Statistics (2) Victory for Sure (1) Vishwas (1) VM Hang (1) Voice Network Team (1) Workbench (1)