dalehhirt

select
       mt.TypeName,
       mtp.ManagedTypePropertyName,
       gs.SettingValue
from GlobalSettings gs
join ManagedTypeProperty mtp
       on gs.ManagedTypePropertyId = mtp.ManagedTypePropertyId
join ManagedType mt
       on mtp.ManagedTypeId = mt.ManagedTypeId
where mt.TypeName = 'Microsoft.SystemCenter.DataWarehouse'

dalehhirt

Function Log-Start{
  <#
  .SYNOPSIS
    Creates log file

  .DESCRIPTION
    Creates log file with path and name that is passed. Checks if log file exists, and if it does deletes it and creates a new one.
    Once created, writes initial logging data

  .PARAMETER LogPath

dalehhirt

#requires -version 4
# #Requires -RunAsAdministrator
<#
.SYNOPSIS
  <Overview of script>

.DESCRIPTION
  <Brief description of script>

.PARAMETER <Parameter_Name>

dalehhirt

$oADObject = Get-ADComputer <ComputerName> -Properties *
$oAceObj   = Get-Acl -Path (“ActiveDirectory:://RootDSE/” + $oADObject.DistinguishedName);
$oAceObj.Owner

dalehhirt

#!/usr/bin/python
import os
import sys
import csv
import datetime
import time
import twitter

def test():

dalehhirt

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

#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

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

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, 

dalehhirt

[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