Friday, August 01, 2008

Date in Task Bar

›
Got this from Windows XP site. Worth re-post To display the date as well as the time, you need to make the taskbar "taller" by dr...
Tuesday, July 29, 2008

SQL Server Reporting Services Datasource Security

›
http://technet.microsoft.com/en-us/library/ms160330.aspx Stored Credentials You can store the credentials used to access an external data so...
1 comment:
Wednesday, July 02, 2008

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified or Named Pipes Provider, error: 40 - Could not open a connection to SQL S

›
The problem was that the remote connection needed to utilize Named Pipes, but in order to utilize Named Pipes both the machine hosting the i...
11 comments:
Tuesday, July 01, 2008

How to determine what ports are open

›
start -> run -> cmd netstat -na look for :3306 and LISTEN on the same line... OR..also from command prompt telnet localhost 3306
1 comment:
Friday, June 27, 2008

Vitual PC 2007

›
Well, it has been a while since I have blogged due to the project I am working on at work. The project MOSS 2007 from dev, test, and prod. ...
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: