Use Query Store to help with SQL Server upgrades

The Query Store is a feature that helps you evaluating query performance. It captures execution information asl well as up to 200 plans for a single query. For a thorough overview on the Query Store you can read Enrico van de Laar’s article here. Query Store is also available for Azure since V12. To turn on Query Store […]

Setting database to trustworthy will let you deploy assemblies in unsafe mode

The title says it all, but let me expand on this a little bit. I have an assembly that I wanted to emulate in SQL server. The first, obvious choice is to use safe mode, which results in the following message: Msg 6212, Level 16, State 1, Line 2 CREATE ASSEMBLY failed because method ‘x’ […]