adamfortuno

create database ae_analysis;
GO
USE ae_analysis;
GO
DROP TABLE IF EXISTS dbo.summary;
create table dbo.summary (
	Test varchar(10) not null
  , Cycle tinyint not null
  , WorkloadID uniqueidentifier not null
  , Hostname sysname not null

adamfortuno

import-module sqlserver

$instance_list = @('<server-1>', '<server-2>')

$query = @"
SELECT dbs.[name] AS [database_name]
, stat.creation_time [statement_datetime_created]
, stat.execution_count AS [statement_run_count]
, txt.[text] AS [statement_text]
FROM sys.dm_exec_query_stats stat CROSS APPLY sys.dm_exec_sql_text(stat.plan_handle) txt

adamfortuno

Import-Module SQLPS -DisableNameChecking

$SQLInstanceName = "(local)"
$SourceDBName   = "sandbox"
$CopyDBName = "${SourceDBName}_copy"

$Server  = New-Object -TypeName 'Microsoft.SqlServer.Management.Smo.Server' -ArgumentList $SQLInstanceName
$SourceDB = $Server.Databases[$SourceDBName]
$CopyDB = New-Object -TypeName 'Microsoft.SqlServer.Management.SMO.Database' -ArgumentList $Server , $CopyDBName
$CopyDB.Create()

adamfortuno

function Invoke-Tasks {
    <#
        .Synopsis
        Invoke a Task
        .Description
        Executes a task with different calls in parallel.
        
        .Parameter TaskScript
        The script for the task to be executed.
        .Parameter Parameters

adamfortuno

##Secure message transmission with TLS 1.2 (default is 1.0)
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Send-Mailmessage -smtpServer ... -Port ... -from "me@home.com" -to "you@home.com" -subject "..." -body "..."

adamfortuno

/******************************************************************************
Situation...

There is a DOS batch script named foo.bat in C:\temp\foo.bat. We want
******************************************************************************/

$things-todo-when-batchfile-completes = {
	new-item 'c:\temp\thinger-done.txt'
	Get-EventSubscriber | Unregister-Event
}

adamfortuno

$servers = @(
	'foo1.sandbox.local'
	'foo2.sandbox.local'
	'foo3.sandbox.local'
)

foreach ($server in $servers) {
    "{0}`t{1}" -f $server, [System.Net.Dns]::GetHostAddresses($server).IPAddressToString
}

adamfortuno

## Connect to an instance 
[void][Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO")
$instance = New-Object 'Microsoft.SqlServer.Management.Smo.Server' -ArgumentList '<instanceName>'

## Connect to an innstance's WMI
[void][Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO")
[void][Reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement")
$instance_wmi = New-Object 'Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer' -ArgumentList '<instanceName>'

adamfortuno

from fuzzywuzzy import fuzz
import pandas as pd

path_employee_list = "C:/Users/adam.fortuno/temp/employee_names.txt"
path_ad_users_list = "C:/Users/adam.fortuno/temp/ad-user-names.txt"
path_employee_to_aduser_mapping = "C:/Users/adam.fortuno/temp/mapping.csv"
employee_mapping = []

with open(path_employee_list, "r") as employee:
  for employee_name in employee:

adamfortuno

---Create a playground
create database sandbox;
go
use sandbox
go
drop table dbo.tableOfThings
go
create table dbo.tableOfThings (
id int identity(1,1) not null constraint pk_tableOfThings primary key
, date_created datetime2 not null constraint df_date_created  default getdate()