Follow SQL SERVER DBA and Azure on Feedspot

Continue with Google
Continue with Facebook

This blog is to learn and share SQL DBA and Azure knowledge among people ..
SELECT DB_NAME() AS DbName,name AS FileName,size/128.0 AS CurrentSizeMB,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS ..read more
Migrate Reporting Services Database to another Instance for 2008/2012Let suppose there are two SQL Server Instances: ..read more
Analyzing Linux Logs: 1)Searching with Grep One of the simplest ways to analyze logs is by performing plain text searches using grep. ..read more
select a.id as 'ObjectID', isnull(a.name,'Heap') as 'IndexName', b.name as 'TableName',stats_date (id,indid) as stats_last_updated_time,st ..read more
If you have hundreds of sql jobs scheduled  to run everyday in SQLserver.  How quickly you can find the stored procedure used by sql job ..read more
When you Setting Database Mirroring if you will get the error message like  "The mirror database has insufficient transaction log data" ..read more
When you try to restore/verifyonly SQL backup you may be found this error some time because the backup may be corrupted.Solution : Make ..read more
Message:BACKUP failed to complete the command BACKUP DATABASE db_name. Check the backup application log for detailed messagesSolution:  ..read more
You can run the below system stored procedure to find the list of linked servers configured on instance of sql servers.sp_linkedservers ..read more
When i try to take image of sql server for installation to new server  i could not restart sql server service on new server due to tempdb ..read more

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview