SQL
-
SQL addon for Optimizely CMS 12 updated with new features EN
First released in 2021, the SQL Studio addon for Optimizely CMS lets you query your database directly from the edit UI. The latest update adds support for GPT-5, a new UI for managing saved queries.
-
Exporting Optimizely databases causing errors EN
Solutions to a couple of recurring issues when migrating databases to the cloud.
-
Increase timeout for long running SQL queries using SQL addon EN
Learn how to increase the timeout for long running SQL queries using the SQL addon.
-
Microsoft announces Natural language to SQL EN
Finally, Microsoft launches "Natural language to SQL," after it has been available for several months in Optimizely CMS!
-
List number of pages per pagetype in Optimizely CMS EN
Learn how to identify the most frequently used content types in your Optimizely CMS installation using SQL.
-
Is there really a RIGHT way to delete content directly in the Optimizely CMS database? EN
What is really the right way? And who decides what's the right way? I don't...
-
Delete content directly from the Optimizely database EN
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...
-
Erstatning for rapportsenteret i Optimizely CMS 12 EN NO
Rapportsenteret har vært en del av Optimizely CMS siden det dukket opp for første gang i versjon 5R2 i 2008, men nå – i nyeste versjon er det borte! Fortvil ikke! Lag ditt eget!
-
SqlStudio for Optimizely CMS 12 and .NET6 EN
The addon that gives you super powers directly in your browser is upgraded to support CMS 12 and .NET 6. Enjoy!
-
New SQL addon for Episerver CMS EN
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!
-
Restore point-in-time backup for Azure SQL database EN
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!
-
Datasikkerhet à la hakkespettboken EN NO
Det er ofte snakk om ny teknologi, men man kan også finne løsninger ved å se langt, langt tilbake i historien. Til og med hakkespettboken skrevet for over 2000 år kan løse dagens sikkerhetsutfordringer!
-
Flytt hjem: Azureressurser i Norway East NO
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.
-
Locate Episerver content with restricted access rights EN
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.
-
Episerver Forms - public access to uploaded files EN
Files uloaded to an Episerver Form, can not be accessed without logging in. Unless...
-
Episerver Scheduled jobs - Make it fail! EN
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!
-
Identify your Episerver content! EN
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.
-
Content URL, with or without shortcut? EN
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
-
The horrors of the Episerver Link Validation Job EN
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.