SQL

Solutions to a couple of recurring issues when migrating databases to the cloud.

Learn how to increase the timeout for long running SQL queries using the SQL addon.

Finally, Microsoft launches "Natural language to SQL," after it has been available for several months in Optimizely CMS!

Learn how to identify the most frequently used content types in your Optimizely CMS installation using SQL.

What is really the right way? And who decides what's the right way? I don't...

Do you know your way around the Optimizely CMS database? Deleting, or updating, content directly in the database is pretty straightforward, but of course not recommended...

The Report Center has been a part of Optimizely CMS since its first debut in version 5R2 in 2008, but in CMS 12, it's removed! Don't despair! Make your own Report Center!

The addon that gives you super powers directly in your browser is upgraded to support CMS 12 and .NET 6. Enjoy!

I enjoy poking around in the Episerver database, so I made an addon to make it easier! Enjoy autocomplete, save your favorite queries for later - but be careful!

If you are doing manual updates directly to your Episerver database, or performing an upgrade that updates the database schema it could be a good idea to have a backup from the exact time right before the change is made. In Azure, you always have!

A new Episerver addon use technology described in the Junior Woodchucks' Guidebook over 2000 years ago, to safely store your Episerver data! Check it out!

For noen måneder siden var det ikke fritt frem for å opprette SQL-databaser i Azure-regionen Norway East - men nå er det! Jeg viser hvordan man kan flytte en Azure SQL-database på tvers av regioner.

If someone deletes a page from an Episerver site, you can figure out what happened by looking at the changelog. What if someone changes access rights? I show how to locate pages that have their access rights set explicitly.

Files uloaded to an Episerver Form, can not be accessed without logging in. Unless...

If you write code that is likely to fail, it is good practice to wrap that section of code in a try-catch-clause and handle the exception. For scheduled jobs, it's the opposite! If something fails, be sure to throw that exception!

You can have multiple pages with the same name, you can even have a block and an image with the same name. When we are communicating about content, the name is not always the best.

There are several methods that will give you an URL to a Episerver content, but they do not all work the same. I dive into the details

Preventing broken links is an important part of maintaining a website. Episerver's Link Validating job tries to help us, but unfortunately, it has its shortcomings.