SQL Function to Lookup DNN Profile Values

DNN Expert posted on February 01, 2021 15:20

CREATE FUNCTION GIBS_GetProfileElement ( @userID as int, @portalID as int, @ProfilePropertyName as nvarchar(100) ) RETURNS nvarchar(4000) AS B...

[Read the rest of this article...]

Posted in: DNN, Stored Procedures, SQL Scripts

Actions: E-mail | Permalink | Comments (0)

11

Can't connect to shared network drive

DNN Expert posted on December 11, 2020 08:46

After the last Windows 10 update (1803), our five Windows 10 Pro computers which are in a WORKGROUP local network (no domain) keep loosing their conne...

[Read the rest of this article...]

Windows 10, mapped drive

Posted in: Networking Problems

Actions: E-mail | Permalink | Comments (0)

03

Getting Eastern Standard Time from Azure SQL

DNN Expert posted on November 03, 2020 11:20

Declare @todays_date Date set @todays_date = CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS date) For example, if you wa...

[Read the rest of this article...]

Azure SQL GetDate()

Posted in: Microsoft SQL Server, Azure, Azure SQL Database

Actions: E-mail | Permalink | Comments (0)

21

Initializing a NotificationController in DNN 9

DNN Expert posted on October 21, 2020 07:28

You can use NotificationsController.Instance.SendNotification method to send notifications. Here is an example: public void ...

[Read the rest of this article...]

DNN, Notification Controller

Posted in: DNN, Core Modules, Social

Actions: E-mail | Permalink | Comments (0)

21

Azure Blob Storage Task TLS 1.2 Windows Server 2016 Datacenter

DNN Expert posted on October 21, 2020 05:24

Fix for Blob Storage Task failing due to: Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (400) Bad Re...

[Read the rest of this article...]

TLS 1.2, Azure Blob Storage Task

Actions: E-mail | Permalink | Comments (0)

24