Massive SQL Date Time Cheat Sheet
Massive SQL Date Time Cheat Sheet Anyone who has been involved in SQL will undoubtedly tell you wargames they played when they had to manipulate date time data via SQL.…
JavaScript-TypeScript for Nintex Forms to Validate File Names
JavaScript-TypeScript for Nintex Forms to Validate File Names This article is going to discuss how to implement JavaScript-TypeScript for Nintex Forms to Validate File Names before they’re uploaded to SharePoint.…
SQL: get max length of values in every table column
SQL to get max length of values in every table column I had an issue to resolve once upon a time where data could not be loaded into a table…
SQL: “Watchdog” loop to start and monitor SQL Agent Jobs
SQL “Watchdog” loop to start and monitor SQL Agent Jobs This runs an SQL “Watchdog” loop to start and monitor SQL Agent Jobs. There are just a few configurable items…
C#: Read lines from a text file in batches and process in parallel
C#: Read lines from a text file in batches and process in parallel I have had numerous requests from readers if I could provide some sample C# code which will…
SQL: Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server
SQL to Rebuild Indexes, Update Statistics, and Shrink Databases Here is SQL to Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server. This code works on SQL Server 2008…
C#: Azure Blob Storage Manager Class
C# Azure Blob Storage Manager Class Here is a C# Azure Blob Storage Manager Class which I hope you find useful as I’ve needed it often enough. It provides basic…
C#: CSV File Writer Class
C# CSV File Writer Here is a C# CSV File Writer class you can use in all your projects. It provides basic functionality for writing data to CSV files and/or…