Recently I had to do a report that generates barcodes using an assembly (dll). In order to use the dll, you can do few different […]
UTC Time For North America – EST
This is the UTC for Eastern time zone for North America based on current eastern time.
How to connect Sharepoint documents as a UNC path?
If you have sharepoint documents that require you to connect to it as a unc path then you must have the following service setup on […]
How to split large video files?
There is a great tool I recently found online that allows you to open small or large videos and split them into multiple parts without […]
How to map a network drive with NET USE?
The following command will allow any account to map to a network unc path. The command must include credential. The above command will map drive […]
How to get table size in a database?
This query will return size of each table in a sql database. This is a great way to monitor growth of a database and decide […]
Youtube-dl commands
This is a great free software online that you can use to download youtube videos. Here are some examples: Example: youtube-dl -h This will show […]
Database Mail Error Failed to initialize sqlcmd library with error number -2147467259
Failed to initialize sqlcmd library with error number -2147467259
How to get timezone information?
Using UTC time and using offset values can be one of the best ways to make sure you capture the correct local time based on […]
How to rerun SQL query after delay?
This sample show how to run the same query with delay. It will keep running the same query with 10 second delay and keep re-executing […]