SQL-BOX.COM

HOW TO VERIFY IF A BACKUP FILE IS CORRUPTED?

There are times when we do a backup as a DBA, we come across problems when we restore the backup

There are times a DBA gets a request to see the user account got locked or the user is unable

There are many ways to transfer logins between instances under the same domain like 1. Scripting out logins 2. Logins

After several CTP releases of code named “denali ” is now official released as SQL Server 2012. You can download the RTM

Click on Image below to check out the recorded training videos from experts for who missed it out…

Using STUFF function in sql serevr a column values can be retrieved as single value row, values seperated by comma’s.

Today I was messing with the SQL Server root folder in program files in looking for tablediff .exe utility that

I have been asked several times to delete multiple logins in a day in my environment then initially I was

Would you ever asked to find all administrators with sysadmin access in your server then there is a very symple

This script is very useful when you have large tables and queries against those table usually runs slow then you