This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# to generate your dhparam.pem file, run in the terminal | |
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
cd ~ | |
##If you want to install OpenJDK | |
#sudo apt-get update | |
#sudo apt-get install openjdk-8-jre-headless -y | |
###Or if you want to install Oracle JDK, which seems to have slightly better performance | |
sudo add-apt-repository ppa:webupd8team/java | |
sudo apt-get update | |
sudo apt-get install oracle-java8-installer |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_DELDATA_ForeignKeyRelations]')) | |
DROP VIEW [dbo].[V_DELDATA_ForeignKeyRelations] | |
GO | |
CREATE VIEW [dbo].[V_DELDATA_ForeignKeyRelations] | |
AS |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
RIGHT('0000' + CAST(ABS(CHECKSUM(T_KeyGroup.KG_No + '.' + T_Key.Key_No)) % 1000 AS varchar(10)), 4) AS RPT_Hook | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
How to run: | |
cmd.exe /k start chrome "http://yourWebSite.com | |
Registring new application | |
Search order: | |
- The current working directory. | |
- The Windows directory only (no subdirectories are searched). | |
- The Windows\System32 directory. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
; | |
WITH CTE AS | |
( | |
SELECT | |
0 AS num | |
,CAST(null AS varchar(100)) AS chr | |
UNION ALL | |
SELECT |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// http://www.nullskull.com/a/768/7zip-lzma-inmemory-compression-with-c.aspx | |
// http://www.7-zip.org/sdk.html | |
namespace SevenZip.Compression.LZMA | |
{ | |
public static class SevenZipHelper | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
%userprofile%\Documents\IISExpress\config\applicationhost.config | |
C:\Users\{Username}\Documents\IISExpress\config\applicationhost.config | |
Change path in <virtualDirectory path="/" physicalPath=" | |
Have you try to give full permission to your folder? Read and write? | |
Filename: redirection.config Error: Cannot read configuration file |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'techonthenet') | |
CREATE LOGIN techonthenet | |
WITH PASSWORD = 'abc' | |
,DEFAULT_LANGUAGE=English | |
--,DEFAULT_LANGUAGE=German | |
--,DEFAULT_LANGUAGE=French | |
--,DEFAULT_LANGUAGE=Italian | |
,CHECK_POLICY=OFF | |
; | |
GO |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
;WITH CTE AS | |
( | |
SELECT TOP 99999999 | |
sys.objects.NAME | |
,(avg_total_user_cost * avg_user_impact) * (user_seeks + user_scans) AS Impact | |
,'CREATE NONCLUSTERED INDEX IX_' | |
+ sys.objects.name COLLATE DATABASE_DEFAULT | |
+ '_' |
OlderNewer