nkundu

1. Install the Proxy Server package. Just go to Package Manager in DSM and install Proxy Server.

2. Edit squid.conf to tell it about your ad file. Ssh to the box, and edit the file /var/packages/ProxyServer/target/squid/etc/squid.conf (vi is installed by default)

You're going to add 2 lines to this file. First, under the auth_param section, you're going to add:

acl ads dstdom_regex -i "/var/packages/ProxyServer/target/squid/etc/squid.adservers"

nkundu

@echo OFF
REM Need to be in current directory to touch file
pushd %~dp1
copy /b %1 +,,
popd

nkundu

Get-ChildItem -Path . -Filter *.whatev -Recurse | Where-Object {$_.length/1MB -gt 50} | select fullname,@{n=”Size MB”;e={$_.length/1GB}}

nkundu

apt-get install vnc4server
~/.vnc/xstartup

nkundu

string connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0; data source={0}; Extended Properties=\"Excel 8.0;IMEX=1\"", fullfilename);

DataSet ds = new DataSet();
using (OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString))
{
    adapter.Fill(ds, "contactRecords");
}

nkundu

// Install: C:\Windows\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe xxx.exe
// Uninstall: C:\Windows\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe /u xxx.exe

using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Configuration.Install;
using System.Linq;

nkundu

using (var conn = new System.Data.SqlClient.SqlConnection(connStr))
{
	if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); }
	var tran = conn.BeginTransaction();

	try
	{
		using (var cmd = conn.CreateCommand())
		{
			cmd.Transaction = tran;

nkundu

create table #tmpSpWho2 (
	SPID bigint
	, [Status] nvarchar(100)
	, [Login] nvarchar(100)
	, HostName nvarchar(100)
	, BlkBy nvarchar(100)
	, DBName nvarchar(100)
	, Command nvarchar(100)
	, CPUTime bigint
	, DiskIO bigint

nkundu

/*****
CREATE TYPE [dbo].[BigintCollection] AS TABLE(
	[Value] [bigint] NOT NULL,
	PRIMARY KEY CLUSTERED 
(
	[Value] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)

nkundu

        public static string XmlToString(XmlDocument xmlDoc)
        {
            using (var stringWriter = new StringWriter())
            {
                using (var xmlTextWriter = XmlWriter.Create(stringWriter))
                {
                    xmlDoc.WriteTo(xmlTextWriter);
                    xmlTextWriter.Flush();
                    return stringWriter.GetStringBuilder().ToString();
                }