View Gui-SSRS-Deploy.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#------------------------------------------------------------------------ | |
# 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 |
View GetSQLBuffers_wProvider_PipeTo_Out-SquarifiedTreeMap.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# 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 |
View Deploy-Reports.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. |
View SQLReporting.psm1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
View CellFindingVisitor.cs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Management.Automation.Language; | |
public class ScriptExtent : IScriptExtent | |
{ | |
private readonly IScriptPosition _start; | |
private readonly IScriptPosition _end; |
View SubScriptionExporter.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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 |
View sql-messages-without-whitespaces.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |
View Query_DB2.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$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 |
View BabylonjsVisual.ts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare module BABYLON { | |
export class Engine { | |
constructor(canvas:HTMLElement, antialias:boolean); | |
runRenderLoop(it:any); | |
resize(); | |
} | |
export class Scene { | |
constructor(engine:Engine); | |
render(); | |
} |
View Set-SqlTlsCertificate.ps1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function Set-SqlTlsCertificate { | |
[CmdletBinding(SupportsShouldProcess=$true)] | |
param ( | |
[Parameter()] | |
[Alias("CN", "MachineName")] | |
[String[]]$ComputerName = "localhost", | |
[Parameter()] | |
[String[]]$InstanceName, |
OlderNewer