aduguid
I utilize a clean code approach to agile software methodology. SSRS, SSIS, SSAS, T-SQL, DAX, M, R, Python, C#, VB, VBA, PowerBI, Fabric, Blazor
ReportServer
Pinned Repositories
Access-examples
:a: Various examples of VBA, queries, macros, forms, reports and ribbon XML in an Microsoft Access database file
Application-Icons
Here are some 16x16 icons I regularly use in my applications
ExcelVBA
A library of Excel VBA functions and routines I use in projects
Portfolio
:bust_in_silhouette: Screenshot examples of my work with links to projects and code. If you'd like to speak to me about employment, please contact me through my LinkedIn profile
VBA_personal
Excel personal VBA files in the personal.xlsb
Batch-File-examples
:shell: Various batch files (descriptions are in the read me file)
Script-Help
:memo: This VSTO Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum, Markup or Markdown Languages. The functionality within the ribbon allows a quick way of preparing a bulk data load. Otherwise, the requests can be both time-consuming and error prone. It is written in 3 different versions as a VSTO Add-In in C# and VB.NET as well as a VBA Add-In. The most complete version is C#.
Reporting-Services-examples
:closed_book: Various example reports I use for SQL Server Reporting Services (SSRS) as well as documents for unit testing, requirements and a style guide template.
TSQL-Scripts
:frog: Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.
Active-Directory-Search
:bust_in_silhouette: This Active Directory Search tool was written in C# and VB.NET Windows Forms and exports the results from LDAP to csv format.
aduguid's Repositories
aduguid/Application-Icons
Here are some 16x16 icons I regularly use in my applications
aduguid/Portfolio
:bust_in_silhouette: Screenshot examples of my work with links to projects and code. If you'd like to speak to me about employment, please contact me through my LinkedIn profile
aduguid/VBA_personal
Excel personal VBA files in the personal.xlsb
aduguid/DataCleaner
The premier open source Data Quality solution
aduguid/aduguid
aduguid/CatalogReports
A handful of SSIS Catalog reports ready for SSRS
aduguid/Excel-Add-in-WoodGrove-Expense-Trends
A compelling Excel add-in that demonstrates how you can use the new JavaScript API for Excel 2016. Comes in two flavors - task pane and add-in commands.
aduguid/jimbrig
Github Homepage
aduguid/metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
aduguid/network-share-reconnecter
This project contains a VB script and a Windows scheduler task to automatically reconnect disconnected network shares / drives on login.
aduguid/OfficeJS.dialogs
MessageBox, InputBox and Forms helpers for OfficeJS
aduguid/Rubberduck
Every programmer needs a rubberduck. COM add-in for the VBA IDE (VBE).
aduguid/SQLForExcel
SQL Server Add-in for MS Excel
aduguid/workbooks
Workbooks is an interactive programming environment that’s perfect for experimentation, learning, and documentation: an educational tool for learning the myriad of .NET platforms, APIs, and libraries.
aduguid/activitywatch
The best open source automated time tracker. Cross-platform, extensible, privacy-focused.
aduguid/analytical-sql-examples
NO LONGER MAINTAINED. Code samples for Oracle's analytical SQL features
aduguid/Front-End-Checklist
🗂 The perfect Front-End Checklist for modern websites and meticulous developers
aduguid/fsociety
fsociety Hacking Tools Pack – A Penetration Testing Framework
aduguid/github-issue-templates
:symbols: A collection of GitHub issue and pull request templates
aduguid/hits
:chart_with_upwards_trend: General purpose hits (page views) counter
aduguid/MikyPopescu
aduguid/Portable-Apps
Applications I used that don't need to install
aduguid/prettier
Prettier is an opinionated code formatter.
aduguid/query-docs
Public source repo that hosts the documentation files for Microsoft BI query languages DAX and M.
aduguid/RubberduckWeb
Project Website for the Rubberduck VBA Editor Add-In
aduguid/services
Gitter integrations
aduguid/SlimDucky
A bare-bones VBIDE add-in to troubleshoot Rubberduck's WPF dockable toolwindows
aduguid/SSRS-Branding-File-Editor
A new feature of branding has been introduced for SSRS in SQL Server 2016. This feature is useful for customizing the SSRS Report Manager Portal with Display colors and a logo also can be added to the portal. This Branding consists of a process of zipping and uploading the below 3 files into the SSRS Report Manager portal. 1. Metadata.XML - This file holds the Branding Name , Colors file name and Logo Name (optional) 2. <Colors>.JSON -- This file has the Hex color values for the various elements applicable to the SSRS Report Manager. 3.<LogoFile> -- The logo file to be displayed on the top left corner of the SSRS Report Manager. This file is optional. This tool will be used to edit the Colors.JSON file to apply the colors for each relevant element. This is an excel based macro tool. This tool generate the above files based on the settings in the sheet. Also the colors can be chosen using the cells back color in Color column. For the selected color, the relevant hex code will be written in the colors JSON file. This tool can be used for generating new branding file and edit the existing branding file.
aduguid/VBASync
Cross-platform tool to synchronize macros from an Office VBA-enabled file with a version-controlled folder
aduguid/vsts-docs