jacobhackl

[assembly: CLSCompliant(true)]

jacobhackl

-- Search in All Objects
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'CreatedDate' + '%'
GO

-- Search in Stored Procedure Only
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),
object_definition(OBJECT_ID)

jacobhackl

*.o *.lo *.la #*# .*.rej *.rej .*~ *~ .#* .DS_Store thumbs.db Thumbs.db *.bak *.class *.exe *.dll *.mine *.obj *.ncb *.lib *.log *.idb *.pdb *.ilk *.msi* .res *.pch *.suo *.exp *.*~ *.~* ~*.* cvs CVS .CVS .cvs release Release debug Debug ignore Ignore bin Bin obj Obj *.csproj.user *.user *.generated.cs

jacobhackl

forfiles /p D:\wrx\data\iedi\done /s /m *.* /d -180 /c "cmd /c del @path"

jacobhackl

;WITH cte
     AS (SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2, Col3 
                                       ORDER BY ( SELECT 0)) RN
         FROM   #MyTable)
DELETE FROM cte
WHERE  RN > 1

jacobhackl

/* Re-sizing TempDB to 15 GB */

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



USE [master];

jacobhackl

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

# Build results

[Dd]ebug/
[Rr]elease/

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

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

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;