• Performance,  SQL party

    T-SQL best practice SQL server

    SQL server T-SQL best practice This month’s TSQL Tuesday party is being hosted by Amit Banerjee (Blog | Twitter). He is working with Microsoft and see here his online activities MSDN. The topic this month is T-SQL best practice. It’s the both DBA and developers Topic/Job. Transact SQL is the best tool to improve the SQL server overall performance. You write your code efficiently then you no need to spend lots of money to buy extra resources like hardware, RAM etc… So the coders/developers have to know the best practice. He or She does a good job (writing correct codes) then, There is no work for the DBAs. There is lots of T-SQL best practice available…

  • Backup/Restore,  DBA

    SQL server Database backup restores Steps

    SQL server Database restores sequence Steps I have seen many people are still unclear about the database restoration sequence. Recently I have answered a number of database restoration questions SSC, MSDN… I got a comment from Anonymous user. It’s a simple task to the experienced DBAs. However it’s very important to know the database restoration sequence. It’ll help number of situations. For example, Your database got damaged in any one of the reasons. (Or) You may get a request from the DEV team to restore a database from production to development. I have already written an article about Step by step backup/restore using T-SQL. But it’s not fully focus the restoration sequence. Here I…