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
<system.webServer> | |
<rewrite> | |
<rules> | |
<rule name="Remove WWW and Ensure HTTPS" stopProcessing="true"> | |
<match url="(.*)" /> | |
<conditions logicalGrouping="MatchAny"> | |
<add input="{HTTP_HOST}" pattern="^(www\.)" /> | |
<add input="{HTTPS}" pattern="^OFF$" /> | |
</conditions> | |
<action type="Redirect" url="https://mydomain.com/{R:1}" /> |
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 | |
'public ' | |
+ CASE | |
WHEN c.DATA_TYPE IN ('bigint') THEN 'long' | |
WHEN c.DATA_TYPE IN ('int') THEN 'int' | |
WHEN c.DATA_TYPE IN ('smallint') THEN 'short' | |
WHEN c.DATA_TYPE IN ('tinyint') THEN 'byte' | |
WHEN c.DATA_TYPE IN ('decimal', 'numeric', 'smallmoney', 'money') THEN 'decimal' | |
WHEN c.DATA_TYPE IN ('real') THEN 'single' | |
WHEN c.DATA_TYPE IN ('float', 'decimal') THEN 'double' |
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
@Echo Off | |
Cls | |
:CheckServiceName | |
If "%~1"=="" Goto AskServiceName | |
Set Service=%~1 | |
Goto CheckDependencyServiceName | |
:AskServiceName |
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://dba.stackexchange.com/a/112434 |
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
-- Create a db_viewdefinition role | |
CREATE ROLE [db_viewdefinition] AUTHORIZATION [dbo]; | |
-- Grant view definition rights to the new role | |
GRANT VIEW DEFINITION TO [db_viewdefinition]; |
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
-- Create a db_executor role | |
CREATE ROLE [db_executor] AUTHORIZATION [dbo]; | |
-- Grant execute rights to the new role | |
GRANT EXECUTE TO [db_executor]; |
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
<!-- EN-US --> | |
<errorFilter> | |
<test> | |
<or> | |
<equal binding="HttpStatusCode" value="404" type="Int32" /> | |
<regex binding="Context.Request.ServerVariables['URL']" pattern="/favicon\.ico(\z|\?)" /> | |
</or> | |
<or> | |
<and> |
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
<!-- RESPONSE FROM THE SERVER --> | |
<?xml version="1.0" encoding="utf-8" ?> | |
<Autodiscover xmlns="http://schemas.microsoft.com/exchange/autodiscover/responseschema/2006"> | |
<!-- Response: Required | |
This tag serves as an indication that the retrieved XML is an Autodiscovery Response | |
--> | |
<Response xmlns="http://schemas.microsoft.com/exchange/autodiscover/outlook/responseschema/2006a"> | |
<!-- User: Optional | |
This tag gives user-specific information. Autodiscover must be UTF-8 encoded. | |
--> |
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
<?xml version="1.0" encoding="utf-8" ?> | |
<Autodiscover xmlns="http://schemas.microsoft.com/exchange/autodiscover/outlook/requestschema/2006"> | |
<Request> | |
<AcceptableResponseSchema>http://schemas.microsoft.com/exchange/autodiscover/outlook/responseschema/2006a</AcceptableResponseSchema> | |
<EMailAddress>[email protected]</EMailAddress> | |
</Request> | |
</Autodiscover> |
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
{ | |
... | |
ServicePointManager.ServerCertificateValidationCallback = | |
delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { | |
return true; | |
}; | |
smtpclient.Send(); | |
... | |
} |