Kumar GD

Hello Friends, Thanks for visiting on my blog. My name is Kumar GD and I am currently working as Associate Consultant in IT company which provides IT services to multiple organisation worldwide. I have around 16+ years of experience on Microsoft Technologies. I have worked in multiple big organisations in IT pure development, E-Commerce, Asia's biggest entertainment company, Healthcare domain etc. I have started my career as .Net developer (Windows as well as Web Apps). After few years, moved in database administration. Both experience helped me to understand user problem & provide solution. I just started this blog to help new comers, freshers, IT guys who just started career to learn & understand client issues and provide solution as soon as possible. Thanks for visiting my blog & hope you'll help/ encourage me to continue this blog for new comers, freshers, IT guys. Thanks a lot. Kumar GD.

Explore DBCC CheckAlloc: Top 5 Features

by
Explore DBCC CheckAlloc in SQL Server

One essential SQL Server command that ensures structural data integrity is the DBCC CHECKALLOC command, which checks the consistency of a database’s allocation structures. Data pages need to be validated to find potential corruption in a database. For SQL Server administrators looking to maintain database performance, this article thoroughly examines DBCC CHECKALLOC, including its background, … Read more

Explore Activity Monitor in SQL Server

by
Explore Activity Monitor in SQL Server

A powerful feature of SQL Server is the Activity Monitor (AM), which allows us (developers, administrators, and managers) to monitor the performance and activities of a SQL Instance. The AM helps us get real-time data on various processes, queries, utilization of resources, network utilization, etc., which helps identify and fix performance bottlenecks. Introduction The AM … Read more