Skip to content

Instantly share code, notes, and snippets.

View dalehhirt's full-sized avatar

Dale Hirt dalehhirt

View GitHub Profile
@dalehhirt
dalehhirt / GetAdGroup
Last active December 5, 2021 17:07
Get Ad Group when it can't find a DC
$adGroupName = "Domain Users"
(get-adgroup $adGroupName -Server (Get-ADDomainController -Discover -Service ADWS -DomainName $env:USERDNSDOMAIN) -properties members).members
function w-h() {
write-host -ForegroundColor Yellow ">>>" (get-date).ToString("yyyMMdd HH:mm:ss") $args
}
function w-e() {
write-host -ForegroundColor Red ">>>" (get-date).ToString("yyyMMdd HH:mm:ss") $args
}
[alias]
add-alias = !f() { [ $# = 3 ] && git config $1 alias."$2" "$3" && return 0 || echo "Usage: git add-(local|global)-alias <new alias> <original command>" >&2 && return 1; }; f
add-global-alias = !git add-alias --global
add-local-alias = !git add-alias --local
aliases = !git config --get-regexp '^alias\.' | cut -c 7- | sed 's/ / = /'
br = branch
branch-name = rev-parse --abbrev-ref HEAD
branches = branch -a
c = commit
ci = commit
SELECT
ar.replica_server_name,
adc.database_name,
ag.name AS ag_name,
drs.is_local,
drs.is_primary_replica,
drs.synchronization_state_desc,
drs.is_commit_participant,
drs.synchronization_health_desc,
drs.recovery_lsn,
SELECT
id AS [Table ID]
, OBJECT_NAME(id) AS [Table Name]
, name AS [Index Name]
, STATS_DATE(id, indid) AS [LastUpdated]
, rowcnt AS [Row Count]
, rowmodctr AS [Rows Modified]
, FLOOR(500 + (rowcnt * 0.2)) AS [Threshold To AutoUpdate]
, CASE
WHEN rowcnt = 0 THEN 'Not Ready to Update'
@dalehhirt
dalehhirt / PS_Script_Template_V2_Logs.ps1
Last active January 24, 2017 18:48 — forked from 9to5IT/PS_Script_Template_V2_Logs.ps1
PowerShell: Script Template Version 2 (with logging)
#requires -version 4
<#
.SYNOPSIS
<Overview of script>
.DESCRIPTION
<Brief description of script>
.PARAMETER <Parameter_Name>
<Brief description of parameter input required. Repeat this attribute if required>
@dalehhirt
dalehhirt / TopQueries.sql
Created August 2, 2016 16:32 — forked from BrentOzar/TopQueries.sql
Some of the top StackOverflow queries from http://data.stackexchange.com. Great for demoing wide SELECT workloads.
USE StackOverflow;
GO
IF OBJECT_ID('dbo.usp_Q7521') IS NULL
EXEC ('CREATE PROCEDURE dbo.usp_Q7521 AS RETURN 0;')
GO
ALTER PROC dbo.usp_Q7521 @UserId INT AS
BEGIN
/* Source: http://data.stackexchange.com/stackoverflow/query/7521/how-unsung-am-i */
@dalehhirt
dalehhirt / WMEh802V.py
Last active February 3, 2016 17:32
From http://pastebin.com/WMEh802V Code to get network speed and tweet if it falls below specified values.
#!/usr/bin/python
import os
import sys
import csv
import datetime
import time
import twitter
def test():
@dalehhirt
dalehhirt / Get-ComputerOwner.ps1
Created September 10, 2015 03:23
Get Computer Owner
$oADObject = Get-ADComputer <ComputerName> -Properties *
$oAceObj = Get-Acl -Path (“ActiveDirectory:://RootDSE/” + $oADObject.DistinguishedName);
$oAceObj.Owner
#requires -version 4
# #Requires -RunAsAdministrator
<#
.SYNOPSIS
<Overview of script>
.DESCRIPTION
<Brief description of script>
.PARAMETER <Parameter_Name>