Skip to content

Instantly share code, notes, and snippets.

View c0shea's full-sized avatar

Connor O'Shea c0shea

View GitHub Profile
@EitanBlumin
EitanBlumin / Deploy SSRS Reports.ps1
Last active May 12, 2025 03:18
Powershell script to deploy SSRS reports from a folder (all rds and rdl files)
Param
(
[string] $SourceFolder = "C:\SSRS\My-Reports",
[string] $TargetReportServerUri = "http://localhost:8081/ReportServer",
[PSCredential] $Credential,
[switch] $CustomAuthentication,
[string] $ApiVersion,
[string] $TargetFolder = "/My-Reports/Sample-Reports",
[switch] $Recursive,
[string] $OverrideDataSourcePathForAll, #= "/My-Reports/Data Sources/ProdDS",
@DianaEromosele
DianaEromosele / Change "origin" of your GIT repository
Created August 7, 2016 00:31
Change "origin" of your GIT repository
$ git remote rm origin
$ git remote add origin [email protected]:aplikacjainfo/proj1.git
$ git config master.remote origin
$ git config master.merge refs/heads/master
@rotassator
rotassator / Default (Windows).sublime-keymap
Created February 10, 2016 22:54
Sublime Text 3: Key Binding - restore Quick Switch Project keystroke
[
{ "keys": ["ctrl+alt+p"], "command": "prompt_select_workspace" }
]
@metavige
metavige / sp_lock3
Created September 8, 2015 00:51
see lock information in MSSQL
USE master
GO
IF (SELECT OBJECTPROPERTY(OBJECT_ID('sp_lock3'),'IsProcedure')) = 1
DROP PROC dbo.sp_lock3
GO
CREATE PROC dbo.sp_lock3 (
@spid1 INT = NULL /* Check only this spid; if this is NULL then all spids will be checked */
, @spid2 INT = NULL /* and this spid; if this is not null, @spid1 must be not null as well */
)
AS
@jeverington
jeverington / SQL Table Order for import
Created August 16, 2012 09:29
Determine the load order of tables so that you don’t have to drop foreign key constraints to load related data (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72957)
-- Start of Script - Find_Table_Reference_Levels.sql
/*
Find Table Reference Levels
This script finds table references and ranks them by level in order
to be able to load tables with FK references in the correct order.
Tables can then be loaded one level at a time from lower to higher.
This script also shows all the relationships for each table
by tables it references and by tables that reference it.