chipitsine

select * into #tmpag_availability_groups from master.sys.availability_groups

chipitsine

by cpu

(@P1 bigint,@P2 nvarchar(21),@P3 nvarchar(21),@P4 datetime,@P5 nvarchar(21),@P6 nvarchar(21),@P7 numeric(28, 12),@P8 numeric(28, 12),@P9 numeric(28, 12),@P10 nvarchar(21),@P11 nvarchar(21),@P12 int,@P13 int,@P14 nvarchar(21),@P15 nvarchar(21),@P16 nvarchar(21),@P17 nvarchar(21),@P18 nvarchar(21),@P19 nvarchar(21),@P20 nvarchar(21),@P21 nvarchar(21),@P22 nvarchar(21),@P23 nvarchar(21),@P24 nvarchar(21),@P25 nvarchar(21),@P26 nvarchar(21),@P27 nvarchar(21),@P28 nvarchar(21),@P29 nvarchar(21),@P30 nvarchar(21),@P31 nvarchar(21),@P32 int,@P33 int,@P34 nvarchar(21),@P35 int,@P36 int,@P37 nvarchar(21),@P38 nvarchar(21),@P39 nvarchar(21),@P40 nvarchar(21),@P41 nvarchar(21),@P42 nvarchar(5),@P43 int,@P44 bigint)INSERT INTO INVENTSETTLEMENT (TRANSRECID,INVENTTRANSID,ITEMID,TRANSDATE,VOUCHER,SETTLETRANSID,QTYSETTLED,COSTAMOUNTSETTLED,COSTAMOUNTADJUSTMENT,BALANCESHEETACCOUNT,OPERATIONSACCOUNT,CANCELLED,SETTLEMODEL,DIMENSION,DIMENSION2_,DIMENSION3_,DIMENSION4_,DIMENSION5_,DIMENSION6_,DIMENSION7_,DIMENSION8_,DIMEN

chipitsine

choco -y install git
choco -y install python -version 2.7.11
choco install windows-sdk-10.0
choco install windows-sdk-7.1
choco install netfx-4.5.2-devpack
choco install windows-sdk-8.0
choco install microsoft-build-tools
choco install -m microsoft-build-tools -version 12.0.21005.20140416
choco -y upgrade visualstudio2015community

chipitsine

<?
$DB->Query("SET NAMES 'utf8'");
$DB->Query('SET collation_connection = "utf8_unicode_ci"');
$DB->Query('SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED');
$DB->Query('SET SESSION innodb_flush_log_at_trx_commit=2');
$DB->Query('SET wait_timeout=28800');
?>

chipitsine

cls

$sql = ([System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | Where { $_.InstanceName -ne 'SQLEXPRESS'})
'number of intances found: {0}' -f $sql.Count
'-----------------------------------------'
$sql

chipitsine

#!/bin/sh

if [ ! -d "$1" ]; then
        echo "Usage $0 /path/to/sites"
        exit 1;
fi

totalsize=0

for site in `ls $1`; do

chipitsine

#!/bin/bash


if [ ! -f "$1" ]; then
        echo "Usage $0 file.txt"
        exit 1;
fi

now=$(date +"%m_%d_%Y")

chipitsine

#requires -version 4.0

cls

$CurrentDir = [System.IO.Path]::GetDirectoryName($myInvocation.MyCommand.Definition)

$ProgDir = (${env:ProgramFiles(x86)}, ${env:ProgramFiles} -ne $null)[0]
$LogParserExe = (Join-Path $ProgDir '\Log Parser 2.2\LogParser.exe')

$Header = @"

chipitsine

using System;

using MailKit.Net.Smtp;
using MailKit;
using MimeKit;

namespace TestClient
{

    class SmtpClient: MailKit.Net.Smtp.SmtpClient

chipitsine

cls
Import-Module ActiveDirectory

$d = (Get-date).AddDays(-30)

Get-ADComputer -Filter { (Enabled -eq $true) -and (OperatingSystem -like "*XP*") -and (PasswordLastSet -ge $d) } -Properties Name, OperatingSystem | ForEach-Object {
 Write-Host $_.Name, $_.OperatingSystem
}