I just switched to a Windows 11 laptop (finally!) and had to setup everything again. In Visual Studio 2022 I was getting this IIS Express error "You connection is not private" error and the browser would not display my Web Site. The solution was to open Edge and type edge://flags (Chrome was chrome://flags), then find "Allow invalid certificates for resources loaded from localhost" and set it to Enabled.

I found the answer here: asp.net mvc - Your connection is not private NET::ERR_CERT_COMMON_NAME_INVALID - Stack Overflow

I recently got this error when trying to install a SharePoint CU (KB5002629) on SharePoint Subscription Edition. This is a corrupt C:\Windows\Installer folder, or maybe someone deleted some of the files/folders from this directory to save space. You should NEVER do that!! This is the error that was popping up. I tried some older CU's and got the same error.

To fix this issue you need to update the C:\Windows\Installer folder from a working server. Luckily I have a PROD and the DEV was the issue, so I was able to fix this using a script that someone kindly created.

The Script is here: This script was designed as a fix Windows "Installer" by restoring the missing Package(*.msi)/Patches(*.msp) files with the following steps: 1. Identifying the missing files. 2. Crawl the missing files from specified folder or other healthy machine. · GitHub

Someone wrote a nice blog here to explain the solution. Using PowerShell to restore Missing Windows Installer cache items (schottsql.com)

 This script pulled missing files from the working sharepoint installer .\Restore-InstallerFiles.ps1 -SourceFolder "D:\InstallerFiles", "E:\InstallerFiles", "\MachineX\D$\MSI Files";

This is how to format the Date/Time with Date/Time and AM/PM in C#: 

$"{DateTime.Now:yyyy-MM-dd hh:mm:ss tt}

If you get this error message when working with Telerik, you might want to update the Nuget Settings as shown below.

This recently happened to me after I had to rebuild my PC. I found this solution: unable to install in UI for ASP.NET Core | Telerik Forums 

I struggled to figure out how to send e-mails from SQL Server 2012 Database Mail on Windows Server 2008. Yeah Windows Server 2008 is very old but I had a client who needed this done! I had previously configured SQL 2019 Database Mail on a Windows 2022 Server I it was easy. I just configured it in SQL Database Mail and it worked. But in Windows Server 2008 you have to add the following registry entries. Maybe not ALL of these are required but after a few days I was not about to experiment anymore. Restarting the SQL Agent allowed the SQL Database Mail to work via smtp.office365.com, on Port 587 with the SSL checked! I hope someone finds this useful someday!

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]
"SchUseStrongCrypto"=dword:00000001
"SystemDefaultTlsVersions"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v2.0.50727]
"SystemDefaultTlsVersions"=dword:00000001
"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v2.0.50727]
"SystemDefaultTlsVersions"=dword:00000001
"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319]
"SystemDefaultTlsVersions"=dword:00000001
"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.5.50709]
"SystemDefaultTlsVersions"=dword:00000001
"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\
Protocols\SSL 2.0\Client]
"DisabledByDefault"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\
SecurityProviders\SCHANNEL\
Protocols\SSL 3.0\Client]
"Enabled"=dword:00000001
"DisabledByDefault"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\
SCHANNEL\Protocols\SSL 3.0\Server]
"Enabled"=dword:00000001
"DisabledByDefault"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\
Protocols\TLS 1.2\Client]
"Enabled"=dword:00000001
"DisabledByDefault"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\
Protocols\TLS 1.2\Server]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

I was able to Copy a Folder from one location to another but when it came to "Renaming" I was stumped until I got some help from an Expert! So this is how you have to Rename a SharePoint Folder in a Power Automate Workflow!

If you ever need to rebuild a Power Apps form in SharePoint to start over then do the following!

I need to empty an LDF file before sending to a colleague. How do I force SQL Server to truncate the log?

Solution:

ALTER DATABASE ExampleDB SET RECOVERY SIMPLE
DBCC SHRINKFILE('ExampleDB_log', 0, TRUNCATEONLY)
ALTER DATABASE ExampleDB SET RECOVERY FULL

 From: What is the command to truncate a SQL Server log file? - Stack Overflow

When I go to SQL Server Management Studio -> Management -> Maintenance Plans -> Right click on the maintenance plan that I want to execute but the option is greyed out.

• I have checked and SQL Server Integration Services is running.
• I can execute other maintenance plans.
• I have even tried modifying this plan without an issue but Execute stays greyed out.
• There is no other instance of the plan running at the moment.
• I have also disconnected from the SQL Server and connected back but that didn't help either.
• SQL Agent is running.

Solution:

Turns out it was an execution window that was buried. It doesn't show as an "open window" when you look at the taskbar at the SSMS icon, so it's deceptive. ALT-TAB your way through the windows and you should find it.

The open windows was:

From here: sql server - Maintenance Plan Execute option is greyed out - Stack Overflow

Source: FIXED: Error 3283 Refresh Links (isladogs.co.uk) - and - RefreshLink fails with "Primary Key already exists" (accessforever.org) -  Thanks!

I came across error 3283 - Primary key already exists after the MS Office system had been updated to version 2312 Build 16.0.17126.20190 for Monthly Enterprise  Channel.

The error happens when calling RefreshLink as shown in the code sample below. Disclaimer: This worked for me, but your solution might be different. The solution "for now" is to use On Error Resume Next and deal with the error afterwards as the table does in fact relink just fine. Microsoft say that a fix will not be released until March 12th 2024 in version 2401. So you will need to implement this work around until it's resolved.

For Each tblDef In tblDefs
	If tblDef.Connect <> "" Then
		If InStr(1, tblDef.Connect, "ODBC") > 0 Then
			'SQL Server Database
			If (tblDef.Connect <> strSQLConnectionString) Or blnForceReconnect Then
				tblDef.Connect = strSQLConnectionString
								   
				' Error 3283 when refreshing links using code caused by MS Office Update 2312 Build 16.0.1716.20190
				' A fix will be applied by Microsoft on March 12th 2024 Office Updates for build 2401.
				On Error Resume Next
				tblDef.RefreshLink
			
				' This is required if the SQL View is to be update-able
				If tblDef.Name = "vw_Example" Then
					CurrentDb.Execute "CREATE UNIQUE INDEX __uniqueindex ON " & tblDef.Name & " (ID ASC)"
				End If
														
				Err.Clear
				On Error GoTo ErrorHandler
				
			End If
		End If
		
	End If
Next tblDef

Thanks to Isladogs on Access and Access Forever for this post.