The Lync Call Quality Methodology (CQM) is a practical approach that applies the broad guidance we have published in the Lync Networking Guide. CQM is a data driven framework backed by SQL queries and an operational process to systematically improve and maintain call quality. CQM was derived from Microsoft and some of our largest customer deployments. CQM was published in v2 of the Networking Guide complete with queries and an updated set of 2010/2013 KHIs. This session will go through the individual components of CQM, describe our recommended process for implementing it, show findings from using CQM and go into detail on how the SQL queries work and how you can customize them for you or your customer's needs.
You may think that there is much in SQL Server that appears to work as if by magic? And you would be right! But despite this magic, everything is actually quite easy to understand. This 500-level report contains information about the internal data storage format in SQL Server (MDF files), as well as about how you can work with the data using only a hex editor. You will learn about how SQL Server stores internal metadata for objects and about how you can find and read the data on the disk.