Friday, February 13, 2015

SQL Server How to Drop Connections

›
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE dbname SET MULTI_USER GO
Friday, January 16, 2015

IIS 7.5 FTP and Virtual Directory not displaying in FileZilla - 550 Keyset does not exist

›
Software - Windows 2003 R2 - IIS 7.5 using FTP FileZilla (Protocol=FTP; Encryption=Require explicit FTP over TLS; Logon Type:=Normal;...
Friday, January 02, 2015

Force Kill Process - MSDN

›
Working on some Windows 2008 R2 FTP issues and the services got hung.  After some Goolge searching I found the following article to KILL THE...
Tuesday, November 11, 2014

Backend Programmer learning new tricks

›
http://sciactive.com/pnotify/
Wednesday, October 29, 2014

Get httpPostedFileBase FileName only code or extract last portion of file director path

›
var   httpPostedFileBase   =   Request . Files . Get ( "DocumentFileName" );                 var   myFileName   =   string . Empty...
Friday, October 24, 2014

Zip Code

›
[ RegularExpression ( @"^\d{5}(-\d{4})?$" , ErrorMessage  =   "Invalid Postal Code" )]

Location of Nuget Packages - (I am getting older so I have to blog this stuff to remember ha ha)

›
Web Layer - packages.config
Wednesday, October 15, 2014

Reading Keys from Web.config file.

›
Try using the WebConfigurationManager class instead. For example: C# string userName = WebConfigurationManager . AppSettings [ "PFU...

Read file using FileStream - Reference - http://www.csharp-examples.net/filestream-read-file/

›
Read file using FileStream First  create FileStream to open a file  for reading. Then call  FileStream.Read  in a loop until the whole fi...
Wednesday, October 01, 2014

jQuery $.ajax call add functions you will need to call after the html is rendered.

›
I am adding the following blog post because I spent a good amount of time working on figuring the following out. Using the jQuery functio...
Wednesday, September 17, 2014

pragmatic - Word of the day

›
prag·mat·ic pragĖˆmatik/ adjective dealing with things sensibly and realistically in a way that is based on practical rather t...

SSL Chrome

›
SSL certificate technology is always improving to stay ahead of hackers. We regularly update to the most current and effective standards. W...
Wednesday, May 28, 2014

Determine .NET Version - Shared by Walt Daniels

›
Run this from a Command prompt (not a powershell prompt) … it takes a minute, be patient. wmic /namespace:\\root\cimv2 path win32_prod...
Friday, May 09, 2014

jQuery Lightbulb

›
If you want to learn jQuery, which is a hot tech skill these days head over to www.codecademy.com The following statement had the light bu...
Wednesday, March 26, 2014

Reset Visual Studio Windows if Windows Start opening in different panes

›
Windows:  ALT + W, R  Menu:   Window | Reset Window Layout  Command:  Window.ResetWindowLayout  Versions:  2005, 2008, 2010, 2012, 2013 
Monday, March 10, 2014

LINQ Queries OR SQL checking Nothing or Null Values

›
You need to check if it's  Nothing  first and use the  AndAlso  keyword to stop it from evaluating the latter statement. Also, when chec...
Tuesday, March 04, 2014

Stored Proc Place holder to be filled later example

›
SELECT Field1, Field2, Field3, ' ' AS FieldName, FROM tbl_name WHERE field = @param Later fill this with the data you need...
Wednesday, February 05, 2014

TFS MSBuild Workflow Toolbox

›
Do you still have the Team Foundation Build Activities tab?  If not, you probably deleted it.  To get it back, you can right-click on the t...
Monday, January 06, 2014

LAWS OF PROJECT MANAGEMENT

›
1. No major project is ever installed on time, within budget, or with the same staff that started it. Yours will not be the first. 2. Pr...
Monday, December 30, 2013

Family, Friends and fellow Developers

›
Merry Christmas and Happy New Year.  Hope everyone is prosperous and joyful in the coming 2014 year. In 2013 we have have lost and gained Fa...