jacobhackl

<rule name="Force Https" stopProcessing="true">
   <match url="health.htm" negate="true" />
   <conditions>
       <add input="{HTTP_X_FORWARDED_PROTO}" pattern="https" negate="true" />
   </conditions>
   <action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Permanent" />
</rule>

jacobhackl

declare @hyperthreadingRatio bit
declare @logicalCPUs int
declare @HTEnabled int
declare @physicalCPU int
declare @SOCKET int
declare @logicalCPUPerNuma int
declare @NoOfNUMA int

select @logicalCPUs = cpu_count -- [Logical CPU Count]

jacobhackl

--http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/
SELECT
    [ReadLatency] =
        CASE WHEN [num_of_reads] = 0
            THEN 0 ELSE ([io_stall_read_ms] / [num_of_reads]) END,
    [WriteLatency] =
        CASE WHEN [num_of_writes] = 0
            THEN 0 ELSE ([io_stall_write_ms] / [num_of_writes]) END,
    [Latency] =
        CASE WHEN ([num_of_reads] = 0 AND [num_of_writes] = 0)

jacobhackl

TAKEOWN /F "<foldername>" /R /D N /A

Remove folder read-only attribute

ATTRIB -R /D /S "<Foldername>"

jacobhackl

setlocal

set "location=d:\"

for /F "delims=" %%a in ('dir /s /ad /b "%location%"') do (
   echo md %%a >> createDirectorys.bat

)

jacobhackl

using Google.Apis.Auth.OAuth2;
using Google.Apis.Plus.v1;
using Google.Apis.Plus.v1.Data;
using Google.Apis.Services;
using Google.GData.Client;
using Google.GData.Spreadsheets;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography.X509Certificates;

jacobhackl

EXEC sp_addlinkedserver 
@server=N'wradminlite', -- Linked Server Display Name
@srvproduct=N'SQL Server', -- Default to SQL Server
@provider=N'SQLNCLI', -- Use SQLNCLI
@datasrc=N''; -- VPC IP of remote server, force TCP mode

EXEC sp_addlinkedsrvlogin @rmtsrvname = 'wradminlite' -- Linked Server Display Name
, @useself = 'false' -- Do not masquerade
-- , @locallogin = '' -- Commented out to force all local users to use linked login
, @rmtuser = '' -- Remote user name

jacobhackl

<rule name="Redirect to HTTPS" enabled="true" stopProcessing="true">
    <match url="(.*)" />
    <conditions logicalGrouping="MatchAll" trackAllCaptures="false">
        <add input="{HTTPS}" pattern="off" />
    </conditions>
    <action type="Redirect" url="https://{HTTP_HOST}/{R:1}" redirectType="Found" />
</rule>

jacobhackl

# User-specific files
*.suo
*.user
*.sln.docstates

# Build results

[Dd]ebug/
[Rr]elease/

jacobhackl

/* Re-sizing TempDB to 15 GB */

USE [master]; 
GO 
alter database tempdb modify file (name='tempdev', size = 15GB);
GO



USE [master];