Some times there will  be a necessity of import data from a xml file and import it  into SQL Server, this can be done in 2 ways, 1)  query 2) ssis in this example we have a xml file like this and a table is created in a database as below Query to import xm […]

On   a fine day , your boss comes to your desk and says that , there are 50k records deleted from the tables, Do you know what happen So?  The only option you have is to read the transaction log file,if you don’t take transaction backup of your database, then you are left over […]