Data Integrity in Azure SQL Database

%3CLINGO-SUB%20id%3D%22lingo-sub-113554%22%20slang%3D%22en-US%22%3EData%20Integrity%20in%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-113554%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20takes%20data%20integrity%20very%20seriously.%20While%20there%20are%20some%20traditional%20techniques%20used%20by%20DBAs%20in%20SQL%20Server%20to%20monitor%20data%20integrity%20(e.g.%20DBCC%20CHECKDB)%20and%20various%20methods%20to%20recover%20from%20database%20corruptions%2C%20the%20Azure%20SQL%20Database%20engineering%20team%20has%20been%20able%20to%20develop%20new%20techniques%20that%20can%20handle%20some%20classes%20of%20corruption%20automatically%20and%20without%20data%20loss.%20These%20techniques%20are%20used%20as%20part%20of%20the%20service%20to%20avoid%20data%20loss%20and%20downtime%20in%20the%20cases%20where%20they%20can%20be%20avoided.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20blog%20post%20outlines%20some%20of%20those%20techniques%2C%20how%20they%20work%2C%20and%20what%20impact%20it%20has%20on%20customers%20concerned%20with%20what%20steps%20they%20should%20take%20to%20safeguard%20their%20data%20in%20Azure%20SQL%20Database.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Slide1.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21597iA166A848EAE87CA6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Slide1.PNG%22%20alt%3D%22Slide1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERead%20about%20it%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fdata-integrity-in-azure-sql-database%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20blog%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-113554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20%26amp%3B%20Storage%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Community Manager

Microsoft takes data integrity very seriously. While there are some traditional techniques used by DBAs in SQL Server to monitor data integrity (e.g. DBCC CHECKDB) and various methods to recover from database corruptions, the Azure SQL Database engineering team has been able to develop new techniques that can handle some classes of corruption automatically and without data loss. These techniques are used as part of the service to avoid data loss and downtime in the cases where they can be avoided. 

 

This blog post outlines some of those techniques, how they work, and what impact it has on customers concerned with what steps they should take to safeguard their data in Azure SQL Database.

 

Slide1.PNG

 

Read about it in the Azure blog.

0 Replies