DNN Blogs

Written for the Community, by the Community

The DNN Community is made of all kinds of people across the world and is not an organization. As such, any opinions, endorsements, and claims made in the articles and comments here are those of the individual and do not represent the community as a whole.

Author: Michael Tobisch

Implementing Ola Hallengren's Maintenance Solution on SQL Server Express

I had a speech about SQL Server performance and maintenance at the DNN Connect conference in Millau in July 2022. In this article I want to demonstrate how to implement this solution using SQL Server Express.

Michael Tobisch
2022-08-30

0
MaintenancePerformanceSQL Server

Installing DNN on a Ubuntu Server

Really? No, I am joking, but it's not April Fools Day. So what? In this Blog article I am going to explain how to install SQL Server 2019 on Ubuntu, and then using it with DNN. Sometimes you are in need to install SQL Server and IIS (with DNN) on different machines, so why pay a license for the Operating System when you need a database server?
Since the release of SQL Server 2017, Microsoft added support for different Linux systems (Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu and Docker Engine) to SQL Server. Some days ago, I said: why not trying this? And after some trial and error, I finally got it to run. So here's what I did.

Michael Tobisch
2020-11-05

2
ConfigurationInstallationInstructionsSQL ServerUbuntu

Secure your DNN Database by some simple steps

We all know it: If we have problems accessing a database, we can assign the db_owner role to the account that accesses the database - or even worse, we assign the sysadmin role for the whole server to this account.
And we have that presentiment that we could open some security holes by doing so. So what is reasonable?

Michael Tobisch
2020-10-22

2
ConfigurationInstallationSecuritySQL Server

Activating and Configuring Database Mail in MS SQL Server Express Edition

Do you know Database Mail? Those who administer an MS SQL Server apart from the Express Edition might know it, and there is a nice interface to configure it in SQL Server Management Studio (SSMS). But this interface is missing in the Express Edition. The reason for that is that the SQL Server Agent Services are not present in this edition, which does not let us configure maintainence tasks or Database Mail.
These services use the MSDB database, and this database is installed as one of the system databases, even in SQL Server Express Edition. With a few SQL statements we can activate and configure Database Mail, and make use of this feature.

Michael Tobisch
2020-09-02

2
Database MailOpenFormSQL Server

Why EVERY site should be secured by HTTPS

There are a lot of blog entries and articles in the Web about that topic, and it has been discussed a million times in the last years - esp. since Let's Encrypt entered the market and Google announced that using (or not using) HTTPS will affect site ranking. But still I find sites in the community that don't use it, so here I want to work out reasons for doing a change.