Look for Deleted records in Log File

Look for deleted records in transaction log file. There is an undocumented function called fn_dblog which enables you to read data from your transaction log which contains very informative data about things that are happening in your database.  The function fn_dblog requires a beginning LSN and ending LSN for a transaction.  NULL is the default for this... » read more

Sample Azure SQL Price

Plan DTUs ($1.50/DTU) Data Max Size Price Basic 5 2 GB $4.99/month Standard 10 250 GB $15.00/month Standard 20 250 GB $30.00/month Can adjust plan anytime. Service tiers in the DTU-based purchase model are differentiated by a range of compute sizes with a fixed amount of included storage, fixed retention period for backups, and fixed... » read more

DBCC CHECKTABLE Fix Database Table

Examples A. Checking a specific table The following example checks the data page integrity of the HumanResources.Employee table in the AdventureWorks2012 database.SQLCopy B. Performing a low-overhead check of the table The following example performs a low overhead check of the Employee table in the AdventureWorks2012 database.SQLCopy C. Checking a specific index The following example checks a specific index, obtained... » read more