thebentern

// Old busted
private int count = 0;
public int Count
{
    get
    {
        return count;
    }
    set 
    {

thebentern

if $(ConfigurationName) == Release (
    nuget pack "$(ProjectDir)$(ProjectName).nuspec"
    xcopy "$(TargetDir)*.nupkg" "C:\LocalNuget" /y
) ELSE (
  echo "Skipping nuget pack"
)

thebentern

$database = 'MyDatabaseName'
$instance = 'localhost\SQLEXPRESS'

$tables = Invoke-SqlCmd -Query "SELECT TABLE_NAME FROM [$database].INFORMATION_SCHEMA.Tables" -ServerInstance $instance -Database 'msdb'
foreach ($table in $tables) {
  $tableName = $table.TABLE_NAME
  Invoke-SqlCmd -Query "SELECT TOP 50 * FROM [$tableName]" -ServerInstance $instance -Database $database |
  ConvertTo-Csv -Delimiter '|' -NoType |
  ForEach-Object {$_.Replace('"','')}|
  Out-file "C:\DATA\$tableName.csv"

thebentern

$reader = [System.IO.File]::OpenText("GitChuck.txt")
try {
    cd C:\Users\Source\MyRepo
    for(;;) {
        $line = $reader.ReadLine()
        if ($line -eq $null) { break }
        if($line -like '*bin*' -Or $line -like '*obj*' -Or $line -like '*suo*' -Or $line -like '*user*') {
        	git rm --cached $line
        }
    }

thebentern

// Simple example for 
// 1.) Read a sql server query to datatable;
// 2.) Export it to .csv

    class Program
    {
        static void Main(string[] args)
        {
            var connectionString = @"data source=bla bla bla";
            var selectQuery = "select * from my-table;";

thebentern

SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
    JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyName%'

thebentern

openssl x509 -outform der -in your-cert.pem -out your-cert.crt

thebentern

@powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))" && SET PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin

::Dev platforms and languages
choco install vcredist2010 --confirm
choco install nodejs.install --confirm
choco install ruby --confirm
choco install python2 --confirm
choco install redis-64 --confirm
choco install docker --confirm

thebentern

screen -S "my screen name"
# Ctrl-A + D will detach you from that screen

# Show the list of available screens
screen -r

# To reattach to that screen
screen -r "screen id"

thebentern

$key = "mykey"
$secretKey = "mysecretkey"
$bucketName = "bucketName"

Set-AWSCredentials -AccessKey $key -SecretKey $secretKey -StoreAs MyProfileName

foreach ($file in Get-ChildItem "D:\Exceed Extracts\Batch")
{
  if ($file.Length -gt 0)
  {