matt40k

matt40k

matt40k

matt40k

$ErrorActionPreference = 'Stop'
$regKeyFormat = 'HKLM:\Software\Wow6432Node\Microsoft\Microsoft SQL Server\{0}0\Tools\ClientSetup\'
$vsVersions = @( '12' )

function Validate-Argument($name, $value) {
    if (!$value) {
        throw ('Missing required value for parameter ''{0}''.' -f $name)
    }
    return $value
}

matt40k

$filter = "bi_*"
$groups = Get-ADGroup -Filter {name -like $filter}

foreach ($group in $groups)
{
    $groupName = $group.Name
    $members = Get-ADGroupMember $groupName
    foreach ($member in $members)
    {
        $output = $groupName + "," + $member.name

matt40k

with mycte as
(
  select cast('1900-01-01' as datetime) DateValue
  union all
  select DateValue + 1
  from    mycte    
  where   DateValue + 1 < '2050-12-31'
)
select DateValue
from    mycte

matt40k

$servers = @("server1","server2","server3","server4")

foreach ($server in $servers)
{
    $result = Get-WmiObject win32_service -ComputerName  $server | Where-Object {$_.Name -like "MSSQL$*" -or $_.Name -like "SQLAgent$*" -or $_.Name -like "MSOLAP$*" -or $_.Name -eq "SQLBrowser" -or $_.Name -eq "MsDtsServer120" -or $_.Name -eq "SQLWriter"} | Select name, ',', startname
    foreach ($srv in $result)
    {
        $line = $server + ',' + $srv.startname + ',' + $srv.name
        Write-Host $line 
    }

matt40k

$servers = @("server1","server2","server3","server4")

foreach ($server in $servers)
{
    $drives = Get-WmiObject win32_logicaldisk -Computername $server
    foreach ($drive in $drives)
    {
        if ($drive.Name -ne 'D:' -and $drive.Name -ne 'A:')
        {
            $drv = $server + ',' + $drive.Name + ',' + $drive.VolumeName

matt40k

Function Get-LocalGroupMembers
{
param(
[Parameter(ValuefromPipeline=$true)][array]$server = $env:computername,
$GroupName = $null
)
PROCESS {
    $finalresult = @()
    $computer = [ADSI]"WinNT://$server"

matt40k

CREATE FUNCTION GetGeoJSON (@geo geography)
	RETURNS varchar(max)
	WITH SCHEMABINDING
/*
 * Reference: http://stackoverflow.com/questions/6506720/reformat-sqlgeography-polygons-to-json
 */
AS
BEGIN
	DECLARE @Result varchar(max)
	SELECT  @Result = '{' +