Skip to content

Instantly share code, notes, and snippets.

View aduguid's full-sized avatar
🏠
online

Anthony aduguid

🏠
online
361 followers · 1.5k following
View GitHub Profile
@aduguid
aduguid / logger.ps1
Created September 16, 2019 00:07 — forked from barsv/logger.ps1
Logging in powershell with log rotation
# all logging settins are here on top
$logFile = "log-$(gc env:computername).log"
$logLevel = "DEBUG" # ("DEBUG","INFO","WARN","ERROR","FATAL")
$logSize = 1mb # 30kb
$logCount = 10
# end of settings
function Write-Log-Line ($line) {
Add-Content $logFile -Value $Line
Write-Host $Line
@aduguid
aduguid / ssrs.date_range.md
Created November 21, 2018 05:11
SSRS.Date_Range 
WITH
source_data
AS
(
	SELECT 
		  [today_date] = CONVERT(DATETIME, CONVERT(DATE, GETDATE()))
		, [today_year] = YEAR(GETDATE())
		, [today_month] = MONTH(GETDATE())
)
@aduguid
aduguid / vba.transpose.data.md
Created September 25, 2018 01:52
vba.transpose.data 
Public Function Transposer(strSource As String, strTarget As String)
	'Reference: https://support.microsoft.com/en-au/help/202176/how-to-transpose-data-in-a-table-or-query-in-access-2000
	'Example: ?Transposer("Table1", "Table2")
	On Error GoTo Transposer_Err
	Dim db          As DAO.Database
	Dim tdfNewDef   As DAO.TableDef
	Dim fldNewField As DAO.Field
	Dim rstSource   As DAO.Recordset
	Dim rstTarget   As DAO.Recordset
@aduguid
aduguid / SSRS.ReportUrlWithParameters.md
Created September 20, 2018 01:45 
=Globals!ReportServerUrl + "/ReportServer?" 
   + Replace(Globals!ReportFolder, " ", "+") + "%2f" 
   + Replace(Globals!ReportName, " ", "+") + "&rs:Command=Render&rs:Format=Excel"
   + "&single_parameter=" + Parameters!single_parameter.Value 
   + "&mutliple_parameters=" + Join(Parameters!mutliple_parameters.Value, "&mutliple_parameters=") 
   + IIf(IsNothing(Parameters!start_date.Value), "&start_date:isnull=True", "&start_date=" & Format(Parameters!start_date.Value, "dd-MMM-yyyy"))
   + IIf(IsNothing(Parameters!end_date.Value), "&end_date:isnull=True", "&end_date=" & Format(Parameters!end_date.Value, "dd-MMM-yyyy"))
+ "&boolean_parameter=" + CStr(Parameters!boolean_parameter.Value)
@aduguid
aduguid / software.tool.list.md
Last active March 28, 2019 23:09
A list of software and tools I use for data and reporting
Description
Category Name
@aduguid
aduguid / csharp.dialogbox.md
Last active July 5, 2018 06:32
c# dialog box 
    /// <summary> 
    /// Used to handle temporary objects
    /// </summary>
    public class DialogBox
    {
        /// <summary> 
        /// Used to create a input message dialog box
        /// <example>
        /// <a href='http://www.csharp-examples.net/inputbox/'/>
@aduguid
aduguid / ssrs.Update_Subscriptions.md
Last active June 7, 2018 05:25
To Update the owner of subscriptions 
/*------------------------------------------------------------------------------+
| Purpose:  To update the owner of subscriptions 
| Note:     SQLCmdMode Script
+--------------------------------------------------------------------------------
*/

:setvar _server "YOUR_SERVER"
:setvar _database "ReportServer"
:connect $(_server)
@aduguid
aduguid / sql output line.md
Created March 22, 2018 05:30
SQL.OUTPUT LINE 
OUTPUT @@SERVERNAME AS [Server Name], DB_NAME() AS [Database Name], $action, inserted.*, deleted.*;
@aduguid
aduguid / SQL.week_list_for_year.md
Created March 8, 2018 22:38 
SELECT 
		week_date = DATEADD(d, 1, DATEADD(wk, wks.[number], DATEADD(yy, DATEDIFF(yy, 0, '01-JAN-2018'), 0)))
FROM 
	master.dbo.spt_values AS wks
WHERE 
	1=1 -- used in testing to be able to comment out other clauses below
	AND wks.[type] = 'P'
	AND wks.[number] <= 255
@aduguid
aduguid / Stuff I should know.md
Last active January 1, 2018 23:34
Things to learn
  • R
  • PowerPivot
  • PowerBI
  • Tableau
  • Python