First a huge thanks to the 341 attendees showing up at the precon, you all contributed to making this a day to remember for both Johan and I.

By now we should have answered all questions that was posted to #TEPRC10 on Tweeter.

Precon links from Johans blog:

Pre-creating the database using this script

Checking the database fragmentation:
Use CM_PS1
SELECT DB_NAME(database_id) AS [Database Name], OBJECT_NAME(ps.OBJECT_ID) AS [Object Name], AS [Index Name], ps.index_id, index_type_desc,
    avg_fragmentation_in_percent, fragment_count, page_count
FROM sys.dm_db_index_physical_stats(DB_ID(),NULL, NULL, NULL ,N’LIMITED’) AS ps
    INNER JOIN sys.indexes AS i WITH (NOLOCK)
    ON ps.[object_id] = i.[object_id] AND ps.index_id = i.index_id
WHERE database_id = DB_ID()
AND page_count > 1500
ORDER BY avg_fragmentation_in_percent DESC OPTION (RECOMPILE);

Index and Statistics Maintenance:

SQL backup and restore

Software Update Report dashboard rdl file

Software Update step-by-step: