Add Trusted Assemblies to SQL Server 2022

Since SQL Server 2017, Microsoft introduced the clr strict security option. This option is enabled by default and requires that all assemblies loaded into SQL Server are signed by a certificate. This is a security feature that helps protect your database from malicious code.

When you migrate a database to SQL Server 2017 or later, you may need to load assemblies that are not signed by a certificate. In this case, you need to add the assemblies as trusted assemblies to SQL Server.

Create Your Sessions Coder Style Using Marp

Let’s face it, we all love to code. We love to create things and we love to share our knowledge with others. We also love to learn new things and we love to help others.

Especially when you want to share your knowledge with presentations, you want to easily create your slides and you want to be able to share them with others.

New year and new blog

It has been a looong time since I last wrote a blog post. Not because I have been lazy, but because I have been busy with other things. I have been working on moving my blog to a new engine and I’m happy to announce that it’s finally ready.

What happened?

Well, we all know that things turned out for the worst in 2020 with the pandemic. That year I and Kevin Chant did about 20 sessions for many different events. We also did a lot of work for the community and we were able to help a lot of people.

If you’ve used the data masking command in dbatools you’ve probably noticed that the PowerShell session becomes memory intensive when it has to handle larger tables with one or more unique indexes. The reason that happens is that during the data masking process the command looks for any unique indexes in the table. If it finds a unique index it will create a unique row for all the columns in the unique index. The command creates the values in memory. This means that you’ll have all the values that eventually get inserted into a table in memory. This can lead to a massive amount of memory being used when you have wider unique indexes with large data types. There was also another problem that I had to fix and that was that it would create those unique values for every unique index. This was also the case when there were overlapping columns when multiple unique indexes were being used. This was not efficient and I wanted to make something better for that too. I’ve been thinking about solutions for this problem because I think this command should be usable in almost every situation.

Recently I learned that SQL BITS was going to be an online event. The organizers also decided to do another approach and let the presenters record their sessions. I’m pretty familiar with SLOBS and have been streaming content for the last few months. This gave me some experience in setup scenes and other parts of SLOBS a little more efficiently and make it easy to record my session. Here are some of the things I did to make things easier.