Skip to main content

Posts

Showing posts from January, 2022

[Program] Visual studio 2019 error

When you have the below error message on programming.  " License error.  The project uses non-licensed premium features.  It is not allowed to enhance types with a total of more than 1000 lines of code in the solution by features not covered by the installed licenses, but 1007 lines of code were enhanced." This was caused using Postsharp. When your program uses postsharp in all your code and if you are using more than1000 times. You will have this error. You need to remove some of the line or purchase licenses from the below link.  https://www.postsharp.net/pricing

[email] Encrypt email AES

 Much important information goes with our email. And when you send it, we can encrypt that email to secure our email. We call it AES(Advanced Email Security),  Encrypt Email, or Secure email.  When you 'add on' this kind of feature to your email system.  Usually, add text '[Encrypt]' on your email subject.  Then Encrypt email will send to the receiver. Every company is using a different method. Please check with your IT dept. 

[SQL] How to determine SQL Server database transaction log usage

  To run this command issue the following in a query window: DBCC SQLPERF(logspace) This is sample output From here we can see the size of the transaction logs as well as how much space is being used.  The current log space used will tell you how much of the transaction log is being used.  If this percentage is high and the size of the log is quite big it is probably due to one of the items listed above.  Getting information about SQL Server virtual logs using DBCC LOGINFO The next command to look at is DBCC LOGINFO. This will give you information about your virtual logs inside your transaction log.  The primary thing to look at here is the Status column.  Since this file is written sequentially and then looped back to the beginning, you want to take a look at where the value of "2" is in the output.  This will tell you what portions of the log are in use and which are not in use Status = 0.  Another thing to keep an eye on is the FSeqNo column. T...