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.

8. DBCC SHRINKFILE: Unleash & Deep Dive

by
DBCC ShrinkFile

The DBCC SHRINKFILE is a potent SQL Server tool that lets you recover unused space from data files. Effective storage utilization is an issue that cannot be ignored in the constantly changing world of database administration. Understanding DBCC SHRINKFILE is essential whether you’re a database administrator attempting to optimize disc consumption or a developer trying to handle … Read more

Top 5 Usage of DBCC FreeSessionCache

by
dbcc freesessioncache in SQL Server

DBCC FREESESSIONCACHE is one of a database administrator’s most effective tools. Performance optimisation is a never-ending goal in the changing world of database administration. By removing cached sessions, this operation can potentially improve your database’s performance. In this article, we look closely at DBCC FREESESSIONCACHE, exploring its history, learning how it works, and identifying its … Read more