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…
C#: Fastest Way To Check Last Character of a String
C#: Fastest Way To Check Last Character of a String In this article we’ll benchmark in C#: Fastest Way To Check Last Character of a string. There are plenty of…
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#: For Vs ForEach Vs While
C#: For Vs ForEach Vs While In this article we’ll benchmark iterating over commonly used collections and data structures with the following loop constructs in C#: For Vs ForEach Vs…
Tricky C# and SQL Interview Questions
Tricky C# and SQL Interview Questions for mid-to-senior level Positions A few readers have left private comments asking me what kinds of interview questions I’ve asked potential candidates. Personally, I…
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…
C#: Fastest way to TRIM strings
C#: Fastest Way to TRIM strings This will benchmark various techniques to determine in C# .Net: Fastest way to TRIM strings. Removing all the whitespace at the beginning and/or end…