Friday, October 25, 2013

MVC Overview

›
Monday, October 07, 2013

SQL Random Number Generator

›
DECLARE @Random INT; DECLARE @RandomChar CHAR(15); DECLARE @Upper INT; DECLARE @Lower INT ---- This will create a random numb...
Thursday, September 26, 2013

SQL CURRENT_TIMESTAMP vs GETDATE() Great Article.

›
http://blog.sqlauthority.com/2012/12/20/sql-server-difference-between-current_timestamp-and-getdate-current_timestamp-equivalent-in-sql-serv...

How to clear the Immediate Window

›
Simply type >cls
Tuesday, September 24, 2013

Source Control disappear from Solution Explorer Visual Studio 2010

›
Check -  Visual Studio, click on  File-->Source Control-->Change Source Control .
Tuesday, September 17, 2013

Windows 7 add shortcut to Active Directory

›
Create a short cut and point to -  %SystemRoot%\SYSTEM32\rundll32.exe dsquery,OpenQueryWindow
Monday, September 09, 2013

Entity Container Name Gotcha

›
Was coding today in an application I support currently (Very large)... Lesson learned --- When working with .edmx (Entity Framework) 1) ...
Thursday, August 29, 2013

Deep Thoughts from Rob Roy

›
Next Time you are bounced, transferred or put on hold ask the individual, "Who do I send an invoice to the company for my time". ...
Thursday, August 22, 2013

Old Data Grid --- I cannot believe I am posting this old technology, but good to know and remember

›
The following is VB.NET I am currently on a contract programming both VB.NET and C# at the same time. Does not make for a dull day. Howeve...
Wednesday, August 21, 2013

jQuery Hide and Show elements

›
$(document).ready( function  () {              if  ($( '#diagGroupBtnGroup' ).is( ':visible' ))             {               ...
Tuesday, August 20, 2013

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. Pro...
Monday, August 19, 2013

VB.NET Query to get data when Key ID is Null aka Nothing (vb.net)

›
Dim Query = From x In ctx.tbl_funding_capitation _ Order By x.start_dt Descending _ Select New With ...
Thursday, August 15, 2013

What do Sender and EventArgs mean?

›
The sender is the control that the action is for (say OnClick, it's the button). The EventArgs are arguments that the implementor of th...

Programmer Productivity By Jonathan Erickson, September 26, 2009

›
Multitasking is good when it comes to computer programs, letting them do more with less. But when computer programmers start multitasking, ...
Tuesday, August 13, 2013

DB Property Create --- By Rob McCrady

›
If you want to quickly generate a property list for a VB class from the list of columns on a DB table, this script is a way to do that quic...

Bound Columns -- "DataFormatString"

›
Important back pocket tool to have for formatting bound fields... Reference MSDN ---  http://msdn.microsoft.com/en-us/library/system.web.u...
Friday, August 02, 2013

T-SQL IF Exists Table Drop and Add - SQL Server

›
IF EXISTS(SELECT * FROM dbo.sysobjects WHERE ID = OBJECT_ID('[dbo].[tbl_staging_services_to_summary]'))  BEGIN   --PRINT 'tbl_...
Thursday, August 01, 2013

Great Quote I heard today from a co-worker

›
Life is too short to get uptight over stuff. Not going to help a bit to do otherwise. God’s got the stuff I can’t control. If I can control...
Tuesday, July 30, 2013

SQL Server - T-SQL for setting Date

›
DECLARE @DayOfMonth TINYINT SET @DayOfMonth = 31 DECLARE @Month TINYINT SET @Month = 3 DECLARE @Year INTEGER SET @Year = YEAR(GETDATE()) +...
Monday, July 29, 2013

GET and SET - 101 Knowledge - Source - http://msdn.microsoft.com/en-us/library/w86s7x04.aspx

›
Using Properties (C# Programming Guide) Visual Studio 2012 Other Versions 11 out of 15 rated this helpful  -  Rate this to...