crshnbrn66

#------------------------------------------------------------------------
# Source File Information (DO NOT MODIFY)
# Source ID: 9ad32074-7adb-4822-a049-93600f966aa9
# Source File: ..\Documents\SAPIEN\Projects\Gui-SSRS-Deploy\Gui-SSRS-Deploy.psproj
#------------------------------------------------------------------------
#region Project Recovery Data (DO NOT MODIFY)
<#RecoveryData:
CAIAAB+LCAAAAAAABACNkV1rgzAUhu8L/Q/ifepHxU6IuVhdyy72QS27Had6HBkxkUTH/PeLU4dl
MHb5JO95XnJCT1ioD9R9Bi2w9cpx6LNW71i032DxBbXhSrJgE1BvhunuwAXeZyyBchv6u4jsoLyQ
6CYMCfhRQpJt7PtVEscACfWm8DQ6tZz7BplPvSXOciVKW+d4yzYzwYTOCSvUKAt8hBpT13VuOy7K

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

dhmacher

-- TRANSLATE() and STRING_SPLIT() work with SQL Server 2016+, STRING_AGG() with 2017+.
-- language_id=1033 is English (simplified)

SELECT STRING_AGG(REPLACE(TRANSLATE(s.[value] COLLATE database_default, '():.,-/='';', '**********'), '*', ''), ' ')
FROM sys.messages AS msg
CROSS APPLY STRING_SPLIT(msg.[text], ' ') AS s
WHERE msg.language_id=1033
--AND s.[value] COLLATE database_default NOT IN ('the', 'is', 'to', 'not', 'a', 'for', 'in', 'be', 'of', 'or', 'cannot', 'and')
  AND s.[value] COLLATE database_default NOT LIKE '%[%@=]%'
GROUP BY msg.message_id

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,