Table of contents: Dev Resources .Net .Net Theory CSharp Event Patterns VB.Net Event Patterns App.Config User Defined Conversions Lambda Shortcuts .Net Snippets CSharp Loop Through Command Line Arguments CSharp Test for Table in Access DB Through OleDb Serialise Object to XML CSharp Append to txt File CSharp Dynamic ContextMenu Reflection to fill Class properties from an Array of Values Quick and Dirty Log File Collection Manipulation Shotcuts CSharp Get Classes that Implement an Interface Databases SQL Language SQL Transactions MySQL Command Line Common Table Expressions Testing for Nothing Parameters SQL Scripts SQL Transaction Scripts SQL Find Columns Named SQL List Columns on Table SQL Show Unique Tables Between Databases SSMS Search Stored Procedure Content SSMS Stored Procedure - Create Audit Table and Trigger SSMS Test Index Fragmentation SQL Find Stored Proc Info Copy One Database to Another MS Office Excel Tips and Tricks Excel Named Range Tricks Excel Calling Subs with Parameters from a Worksheet Excel Unprotect WorkSheets Disable VBA IDE Error Popup VBA Passing Parameters to Methods from Worksheet Buttons Bulk Add Apostrophes to Cells Excel Fomulae Multiple List Values from Criteria Quick Random Numbers VLookup, Offset Match and Index Match for Single Values Get Last Filled Value in Row or Column VBA Theory VBA Error Handling VBA Event Patterns VBA Inheritance or Lack of VBA Excel xlam Addins Excel xlam Adding a Custom Ribbon Excel xlam Adding Buttons to the Ribbon VBA Snippets VBA Excel ShowHide Columns VBA Open Word Doc VBA Custom Command Line Arguments VBA Common Methods VBA Testing Dynamic Array Initialisation VBA Date Functions Programming Concepts Core Concepts Procedural Programming Object Oriented Programming Classes and their Features Applications Git Git Concepts and Setup Git Basics Setting up a New Repo The .gitignore File Changing Home for Git Submodules in Git Git Commands Reverting Changes Common Lifecycle Commands Tortoise Git TiddlyWiki Adding Plugins to your TiddlyWiki Adding a Favourites to the Menu Bar Adding an Expandable Contents SSMS SSMS Refresh Intellisense Websites TikiWiki Replacing TikiWiki Favicons TikiWiki Setup Adding a New Structure WordPress Web Hosting Adding SSL Support to a Website Website DNS Settings Using Windows Windows Keyboard Shortcuts Windows Tips and Tricks Assigning Application Hotkeys in Windows Managing Resources Setting Up a Shared Folder on Your Network Windows Scripting HTA Applications Windows Script Snippets Moving files with VBScript Making Folders with Batch Script Finding Folders with VBScript Re-Registering a .dll with Batch Delete Locked File in Windows with Powershell Using Linux Bash and its Uses XML Based Tech XSLT XPath Variable use Dev Random How To Find ODBC Entry Values in Regedit DeveloperDev Resources.Net.Net TheoryCSharp Event PatternsVB.Net Event PatternsApp.ConfigUser Defined ConversionsLambda Shortcuts.Net SnippetsCSharp Loop Through Command Line ArgumentsCSharp Test for Table in Access DB Through OleDbSerialise Object to XMLCSharp Append to txt FileCSharp Dynamic ContextMenuReflection to fill Class properties from an Array of ValuesQuick and Dirty Log FileCollection Manipulation ShotcutsCSharp Get Classes that Implement an InterfaceDatabasesSQL LanguageSQL TransactionsMySQL Command LineCommon Table ExpressionsTesting for Nothing ParametersSQL ScriptsSQL Transaction ScriptsSQL Find Columns NamedSQL List Columns on TableSQL Show Unique Tables Between DatabasesSSMS Search Stored Procedure ContentSSMS Stored Procedure - Create Audit Table and TriggerSSMS Test Index FragmentationSQL Find Stored Proc InfoCopy One Database to AnotherMS OfficeExcel Tips and TricksExcel Named Range TricksExcel Calling Subs with Parameters from a WorksheetExcel Unprotect WorkSheetsDisable VBA IDE Error PopupVBA Passing Parameters to Methods from Worksheet ButtonsBulk Add Apostrophes to CellsExcel FomulaeMultiple List Values from CriteriaQuick Random NumbersVLookup, Offset Match and Index Match for Single ValuesGet Last Filled Value in Row or ColumnVBA TheoryVBA Error HandlingVBA Event PatternsVBA Inheritance or Lack ofVBA Excel xlam AddinsExcel xlam Adding a Custom RibbonExcel xlam Adding Buttons to the RibbonVBA SnippetsVBA Excel ShowHide ColumnsVBA Open Word DocVBA Custom Command Line ArgumentsVBA Common MethodsVBA Testing Dynamic Array InitialisationVBA Date FunctionsProgramming ConceptsCore ConceptsProcedural ProgrammingObject Oriented ProgrammingClasses and their FeaturesApplicationsGitGit Concepts and SetupGit BasicsSetting up a New RepoThe .gitignore FileChanging Home for GitSubmodules in GitGit CommandsReverting ChangesCommon Lifecycle CommandsTortoise GitTiddlyWikiAdding Plugins to your TiddlyWikiAdding a Favourites to the Menu BarAdding an Expandable ContentsSSMSSSMS Refresh IntellisenseWebsitesTikiWikiReplacing TikiWiki FaviconsTikiWiki SetupAdding a New StructureWordPressWeb HostingAdding SSL Support to a WebsiteWebsite DNS SettingsUsing WindowsWindows Keyboard ShortcutsWindows Tips and TricksAssigning Application Hotkeys in WindowsManaging ResourcesSetting Up a Shared Folder on Your NetworkWindows ScriptingHTA ApplicationsWindows Script SnippetsMoving files with VBScriptMaking Folders with Batch ScriptFinding Folders with VBScriptRe-Registering a .dll with BatchDelete Locked File in Windows with PowershellUsing LinuxBash and its UsesXML Based TechXSLT XPath Variable useDev Random How ToFind ODBC Entry Values in Regedit Developer
;){kind=link}
;){kind=link}
;){kind=link}
;){kind=link}