Profile cover photo
Profile photo
hanuman devineni
81 followers
81 followers
About
Posts

Post has attachment
Good tool to compare SQL tables data between 2 servers(TableDiff GUI)
Recently I went through good and simple application to compare SQL table data using Simple GUI and Microsoft SQL component Tablediff.exe file. If you are not aware please use it.. its uses Microsoft component tablediff,exe file to compare the data and send ...
Add a comment...

Post has attachment
Query to Find Disk Alllocated and Free space on Server
Disk Space Alert and Report Below query is useful to get an report to Mail like each drive info as in bottom of the page. You need to replace DB Mail and Mail ID in below Script to get Report. We can execute this job as response to any Disk Space Alert so i...
Add a comment...

Post has attachment
SQL Alert for Disk space issues
I believe creating an SQL Alert for Disk space Alerts will definetly be useful for SQL Database Admins, Especially this is benificail if we doesn't have any monitoring tool and SQL Admins may not have access to RDP server to setup windows level alerts and c...
Add a comment...

Post has attachment
SQL DBA Check list
I have prepared check list for SQL DBA collecting information from many blogs and best practices of SQL DBA's. Please find the attached check list below. SQL DBA Check list.xls
Add a comment...

Post has attachment
How to change Schema from DBO to user created schema for all objects
Move
all database objects from DBO schema to user created (PRD in below queries)
schema. Recently i got a request to change the dbo schema to user created schema PRD. So please find the below steps to do the changes. Ex: PRD is the schema
name Please take d...
Add a comment...

Post has attachment
Importance of DAC on SQL Server
Importance of DAC in SQL server .especially when SQL server is not responding or unable to connect to SQL server and SQL services are running... DAC  (Dedicated Admin Connection) help us to connect and run basic troubleshooting queries in cases of serious p...
Add a comment...

Post has attachment
Query to find page locks disabled for all indexes
Generally, reorganize job fails due to page locks are not enabled,  even though if we enable for specific  index, there may be chance of page lock disabled for other indexes, so we need to make sure all page locks should be enabled if we run reorganize inde...
Add a comment...
Wait while more posts are being loaded