SQLvariant

<# This is the code used to tell you 
   which databases are using up the RAM on 
   your SQL Server is great information to know
   Queries are from https://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/ #>
$SQLInstance  = 'localhost\SQL2016'

Invoke-Sqlcmd -ServerInstance $SQLInstance -Database master -Query "
DECLARE @total_buffer INT;

SELECT @total_buffer = cntr_value

crshnbrn66

param
(
    [String] [Parameter(Mandatory)]
    $SolutionFile,
    #this is the evironment that is in the Solution config to read where things need to go (TEST/DEV/QA/Prodution)
    #for example - C:\tfs2013\Test Automated Deployment Sharepoint.rptproj
    [string] [Parameter(Mandatory)] $Environment,
    #this is the name of the Datasource as it exists in Sharepoint without the .rsds extension
    [string] [Parameter(Mandatory)] $DataSource,
    #This is the connection string that will be set for the report data source. 

crshnbrn66

# SQLReporting.psm1 Version 0.9
# Written by Trond Hindenes
#http://hindenes.com/powershell/SQLReporting.psm1
#Import-Module Pester
#http://stackoverflow.com/questions/9178685/change-datasource-of-ssrs-report-with-powershell
<#
    .SYNOPSIS
    Gets SSRS instances on ComputerName
	
    .DESCRIPTION

rjmholt

using System;
using System.Collections.Generic;
using System.Management.Automation.Language;

public class ScriptExtent : IScriptExtent
{
    private readonly IScriptPosition _start;

    private readonly IScriptPosition _end;

crshnbrn66

#Requires -Version 5.0
#------------------------------------------------------------------------
# Source File Information (DO NOT MODIFY)
# Source ID: 8967ce63-8512-4998-b597-b65331d6a9f6
# Source File: subscriptionExporter.psf
#------------------------------------------------------------------------
#region File Recovery Data (DO NOT MODIFY)
<#RecoveryData:
d00BAB+LCAAAAAAABACMu9eOs0CbLnreUt/Dr/+U0ZhosDQzEjlHk8/IGUwy4ep39QTtJe0tzfpa
beHPVLnqDU8A+t+cIpu+xXJxyZb8AxyszTT++z/Rf0X++R+/P//4x7+ZS1M1Y9ILTV8YyVD8x7qn

SQLvariant

$dbName="SAMPLE"
$server="not.my.localhost"

#Define connection string for the database
$cn = new-object system.data.OleDb.OleDbConnection("server=$($server);Provider=IBMDADB2;DSN=$($dbName);trusted_connection=true;");
#Define data set for first query
$ds = new-object "System.Data.DataSet" "ds"
#Define query to run
$q = "select * from hello_world"
# Define data object given the specific query and connection string

AndyCross

declare module BABYLON {
	export class Engine {
		constructor(canvas:HTMLElement, antialias:boolean);
		runRenderLoop(it:any);
		resize();
	}
	export class Scene {
		constructor(engine:Engine);	
		render();	
	}

stummsft

function Set-SqlTlsCertificate {
    [CmdletBinding(SupportsShouldProcess=$true)]
    param (
        [Parameter()]
        [Alias("CN", "MachineName")]
        [String[]]$ComputerName = "localhost",

        [Parameter()]
        [String[]]$InstanceName,

potatoqualitee

# IE has to be used because of a refresh that Invoke-WebRequest can't handle (think Clicks)
# Add required types
Add-Type -Path C:\Scripts\Scheduled\ClosedAsFixed\HtmlAgilityPack.dll
Add-Type -AssemblyName System.Web

Function Get-Total ($closedorresolved, $bugorsuggestion){

	switch ($closedorresolved) {
		"Closed" { $status = '3' }
		"Resolved" { $status = '2' }

okpedro

# USE THIS SCRIPT TO UPLOAD LARGE .PBIX FILES TO POWER BI REPORT SERVER
# 
# I needed to manually construct the form-data as PowerShell doesn't appear to have full support for 
# this yet, though it appears to be coming soon.

#CREDENTIALS
[string]$userName = 'BIWIN\MS'
[string]$userPassword = 'xxxxxxxxxxxxx'
[securestring]$secStringPassword = ConvertTo-SecureString $userPassword -AsPlainText -Force
$Credential = New-Object System.Management.Automation.PSCredential ($userName, $secStringPassword)