Wednesday, March 26, 2008

Upgrading from SQL Express 2005 to SQL 2005 Developer Edition

›
Upgrading from SQL Express 2005 to SQL 2005 Developer Edition (2 hours) Note: First ensure you have access to the following key in the regi...
2 comments:
Tuesday, March 04, 2008

MCTS - SharePoint Developer

›
Passed the Microsoft Exam SharePoint 2007 Developer I am now officially and Microsoft Certified Technical Specialist.
1 comment:
Wednesday, February 20, 2008

Back versus Attaching to MDF

›
Chintal my new programming parnter taught an old dog a new trick today. Instead of backing up and restoring databases simply open Windows E...
Thursday, February 14, 2008

Working with Infrastructure in the Enterprise as a Programmer Analyst

›
For 10 years I have been working as an analyst first then putting on the programmer hat and developing applications. In corporate America y...
Monday, February 04, 2008

Start explorer in C:

›
Start Windows Explorer In The C Drive In the Explorer property sheet use this path and switches in the target: C:\windows\explorer.exe /n,/e...
2 comments:
Wednesday, January 02, 2008

Kill Instance of Application

›
Recently I was receiving an issue with an application I am supporting.   Problem The application is a .NET Console application that usi...
Thursday, December 20, 2007

Year End

›
Well, another year is coming to an end and what a year it has been. I have seen my Wife and daughter grow to be best little buddies. Also ...
1 comment:
Tuesday, December 18, 2007

›
dbcc checkident('table_name', reseed, 0)   Reset Database identity
Monday, December 17, 2007

Reset VS2005 IDE

›
http://blogs.vertigo.com/personal/KeithC/Blog/Lists/Posts/Post.aspx?ID=16  
Friday, December 14, 2007

›
Answer Re: A transport-level error has occurred when sending the request to the...

Stored Procs

›
Please be aware if you are inserting data into a data field with a value type of int and allows null be sure to set the @Param int = null Th...
Wednesday, December 12, 2007

InfoPath class file from export

›
xsd.exe myschema.xsd /classes /l:cs /n: [NAMESPACE]

Identity Information

›
Introduction   About Identity Columns If you have worked with SQL Server, you are probably familiar with identity columns. These ar...
Thursday, November 29, 2007

SQL Reporting Notes

›
SQL Reporting Notes   I noticed an issue with SQL Reporting and the PDF formatting.  I was receiving a lot of extra pages between page ...
Tuesday, November 27, 2007

SQL Reporting Services Expression

›
If you ever need to insert "data not available" or "n/a" use the following code. =IIf(Fields!HoursAllocated.Value is no...
1 comment:

ASP.NET Account locked out please check before banging your head.

›
aspnet_wp.exe could not be started. The error code for the failure is 80004005. This error can be caused when the worker process account ...
1 comment:
Monday, November 26, 2007

%HOME%%HOMEPATH%

›
Have you ever needed to use RUNAS for testing security on your applications?   If so, and you have gotten a second account for testing a...
Tuesday, November 13, 2007

Check empty array Trick

›
The old trick for checking for an empty array is Dim X() As String If (Not X) = -1 Then Debug.Print "empty" El...
Wednesday, November 07, 2007

InfoPath and Web Services

›
Have you ever had this issue developing a Web service with InfoPath? InfoPath cannot submit the form. An error occurred while the form was b...
Wednesday, October 10, 2007

Data Types

›
Data types defined for SQL Server http://msdn2.microsoft.com/en-us/library/aa258271(SQL.80).aspx Difference between varable and fixed - When...