Category Archives: Programming

Save a null value to a GUID field using C# SqlParameter

Posted on February 12, 2016 by pfb_admin

sCommand.Parameters.Add(“@employee_id”, SqlDbType.UniqueIdentifier).Value = (processEmployee_id == String.Empty ? System.Data.SqlTypes.SqlGuid.Null : new Guid(processEmployee_id));   In order to obtain safe and long term solutions, Ayurveda offers excellent, effective, and no side effects people generic levitra online glacialridgebyway.com prefer to take only VigrX male … Continue reading →

Posted in C#, Programming, SQL Server | Leave a comment

linkdump: find newest file in folder or subfolders

Posted on February 1, 2016 by pfb_admin

http://codesnip.net/powershell-script-to-search-files-recursively/http://www.dotnetperls.com/recursive-file-listhttps://support.microsoft.com/en-us/kb/185476http://serverfault.com/questions/62162/shell-command-to-find-the-newest-created-files-recursively-from-a-root-directoryhttp://www.bing.com/search?FORM=U313DF&PC=U313&q=find+newest+file+recursively&src=IE-TopResult&conversationid=http://stackoverflow.com/questions/25493192/powershell-get-childitem-exclude-directory-several-levels-deep?rq=1http://stackoverflow.com/questions/9675658/powershell-get-childitem-most-recent-file-in-directoryIt is manufactured clinically in clean room facilities by Ajanta Pharma and supplied in a range of purchase cialis online flavours and quantities may include Litchi, Gauva, Caramel, Rasberry, Kiwi, Fig, Green apple. These negative effects are considerable, persistent and … Continue reading →

Posted in Linkdump, Programming, System/DB Administration | Leave a comment

SQL View to produce descriptive one-parameter date ranges

Posted on November 18, 2015 by pfb_admin

Automatically generated date ranges by name. Year-to-date? Last month? Next month year-to-date? Make sure to have the authentic product viagra soft tablet to assure the top quality of the results. Something else is this medication of generic levitra pill must … Continue reading →

Posted in Programming, SQL Server | Leave a comment

C# columnar Time zone conversions on populated DataTables

Posted on September 11, 2015 by pfb_admin

TLDR; the code below converts a DataTable’s time columns from UTC to local time, even when the DataTable is populated with data. My utility framework for general data displays queries a predefined content-specific DataTable into a DataGridView. The columns are automatically handled by … Continue reading →

Posted in C#, Programming | 2 Comments

Get Fiddler

Posted on May 12, 2015 by pfb_admin

http://blogs.msdn.com/b/ieinternals/archive/2011/04/22/ie-security-prompt-page-accessing-cross-domain-information-not-under-its-control.aspx http://blogs.msdn.com/b/ieinternals/archive/2009/06/22/https-mixed-content-in-ie8.aspx Well then, how to treat Diabetes Mellitus? High blood glucose caused by damaged islet-like cells leads to Diabetes brand viagra 100mg Mellitus. The medicines boost the cheapest viagra pills natural signals generated while lovemaking session. CFS can develop … Continue reading →

Posted in Programming | Leave a comment

The catch with ClickOnce

Posted on March 4, 2015 by pfb_admin

ClickOnce is a great technique for in-house application distribution. It eliminates a lot of common problems for IT by giving users the ability to control their own application installs and updates. However, relinquishing tight control has some very significant downsides. These are … Continue reading →

Posted in Programming, System/DB Administration | Leave a comment

Synchronicity, serendipity, and Server service schedules

Posted on October 3, 2014 by pfb_admin

Background: For the past year, I have been receiving nightly administrative monitoring messages from our production database. A recent project required a nightly quality check with associated alert. I used a technique similar to the well-proven monitoring messages, and after careful testing … Continue reading →

Posted in Business, Programming, Project Management, SQL Server, System/DB Administration | Leave a comment

Mixed links: Powershell

Posted on August 4, 2014 by pfb_admin

http://technet.microsoft.com/en-us/library/hh848797.aspx  List of topics http://technet.microsoft.com/en-us/library/ff730951.aspx plus ACL http://technet.microsoft.com/en-us/library/ff730950.aspx Multi-select list boxes… SO CLOSE! http://technet.microsoft.com/en-us/library/ff730938.aspx Click OK to continue… http://technet.microsoft.com/en-us/library/ff730959.aspx Scripting for multiple computers http://technet.microsoft.com/en-us/library/ff730964.aspx Working with environment variables Added later: http://windowsitpro.com/windows/create-your-own-powershell-functions PS Functions If discount viagra frequent urination occurs, the amount … Continue reading →

Posted in Programming, System/DB Administration | Leave a comment

Interesting… report viewer

Posted on November 27, 2013 by pfb_admin

Bringin back the RDL. When you are really in need of Physiotherapy because it helps them in good blood circulation and releasing canadian pharmacy viagra stress. With advent of internet and cipla generic viagra Online Pharmacies, millions of people have … Continue reading →

Posted in Programming, SQL Server | Leave a comment

Change Data Capture pattern

Posted on November 27, 2013 by pfb_admin

We’re having a problem with ETL between our ERP and MES systems. We use a timestamp-based periodic export. It occasionally skips a record. We have determined this is due to the duration a transaction is open. If an export occurs … Continue reading →

Posted in Business, Programming, SQL Server, System/DB Administration | Leave a comment