Ok, I've been programming for years, so not much shocks me anymore. But, every once in a while I wonder how I can make more money without having to work more hours. At some points, it seems as though, as a developer, I may spend the rest of my life in "crisis mode" for clients.
Anyway, lately, I've been investigating some strategies. I've found that if I were to choose the ultimate job, it would consist of the following... unlimited number of clients, make money when I'm not working, create residual money, no extreme deadlines.
From what I've seen so far, it looks like affiliate marketing is the way to go. I've been working with it for a short time now. No big successes yet. But, considering this economy, companies are scrambling for these marketers.
If you want to continue on that journey with me, or learn more, please visit http://www.awealthyaffiliatemember.com for more information. On a side note, the group within this "university" also needs developers as they have their own job board.
Monday, February 23, 2009
Thursday, February 19, 2009
How can I tell if a stored procedure is taking too long to run
A lot of times, we are called in a panic if something crashes. A lot of times, it could be because something crashed, in some cases, a stored procedure. Here is a good article with a solution: http://www.databasejournal.com/features/mssql/article.php/3500276/Identifying-Long-Running-SQL-Server-Agent-Jobs.htm
Thursday, February 12, 2009
A severe error occurred on the current command. The results, if any, should be discarded.
Error message:
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.
Error Message in DB:
The connection has been dropped because the principal that opened it subsequently assumed a new security context, and then tried to reset the connection under its impersonated security context. This scenario is not supported. See "Impersonation Overview" in Books Online
Solution:
Implement coding workaround, non-dba issue.
Issue: Web.config setting for connection strings "Connection Reset" does not work for newer versions of .NET2.0. This issue starts once .NET 2.0 SP1 or greater is installed on the application server machine. You'll have to change your code where you are impersonating someone.
Immediate solution:
In your web.config database connection string turn off pooling, Pooling=false;
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Exception: A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.
Error Message in DB:
The connection has been dropped because the principal that opened it subsequently assumed a new security context, and then tried to reset the connection under its impersonated security context. This scenario is not supported. See "Impersonation Overview" in Books Online
Solution:
Implement coding workaround, non-dba issue.
Issue: Web.config setting for connection strings "Connection Reset" does not work for newer versions of .NET2.0. This issue starts once .NET 2.0 SP1 or greater is installed on the application server machine. You'll have to change your code where you are impersonating someone.
Immediate solution:
In your web.config database connection string turn off pooling, Pooling=false;
Thursday, December 18, 2008
javascript focus doesn't work
Had this issue working with .net and javascript. I had the issue where I was trying to set focus on a text box. But, for some reason, I couldn't set focus. I could set focus on drop down boxes in the same window.
Solution, instead of using .focus, I used .select. I still haven't figure out the reasoning behind it, but select worked, focus did not.
Solution, instead of using .focus, I used .select. I still haven't figure out the reasoning behind it, but select worked, focus did not.
Monday, March 17, 2008
How do I have a select distinct and a top x in the same query
Ah, this one puzzled me. I had to go to the internet, and I still didn't quite get it. But, here is the solution.
SELECT
distinct top 3 y.*
FROM
(Select topicid, max(posted) as posted from yaf_Message Group by topicid) y
Order By Posted DESC
How does it work?
Ok, the initial select defines the top values returned.
The From creates another table with only those values that I need. So, when the first select looks in the table, it is looking in a filtered table.
SELECT
distinct top 3 y.*
FROM
(Select topicid, max(posted) as posted from yaf_Message Group by topicid) y
Order By Posted DESC
How does it work?
Ok, the initial select defines the top values returned.
The From creates another table with only those values that I need. So, when the first select looks in the table, it is looking in a filtered table.
Thursday, March 13, 2008
How to access masterpage values from a page
Ok, had this issue. The site allows you to log in and set some preferences. One of these preferences changes the links in the top navigation. So, when it was being set in the preferences page, it wasn't updating the top navigation.
Here's some background as to why. When the preferences were set in the sub page, it would load up the master page first, then set the value. That is the first issue. So, how do I update the master page after the fact. Well, after some quick discovery, I found this article. It saved me. Took 5 minutes after I read this article.
http://www.thescripts.com/forum/thread343203.html
Here's some background as to why. When the preferences were set in the sub page, it would load up the master page first, then set the value. That is the first issue. So, how do I update the master page after the fact. Well, after some quick discovery, I found this article. It saved me. Took 5 minutes after I read this article.
http://www.thescripts.com/forum/thread343203.html
Wednesday, March 12, 2008
What is my mail server's IP address?
Every once in a while, I'll send an email to a client of mine with Yahoo email and I receive an error message. The error message is below. What I found out is that I have to report it to Yahoo and they may clear me. Not sure how long this will take or even if it will work, so I'll find out soon enough.
So, to file the complaint, I was sent to this Yahoo address for 421 errors: http://help.yahoo.com/help/us/mail/defer/defer-06.html
Once there, I filled out some information, mostly about the email. But, one thing hung me up for a little while. How to get my mail server's IP address. It only took a minute, so here's how to get your mail server's IP address.
1. In Windows, click on Start | run
2. Type in the text cmd then click on the OK button.
3. You should now see a small black window with white text.
4. In that box, type in ping mail.yourdomainname.com (fill in yourdomainname.com with your domain name)
5. Hit enter
6. If this works, you will see the IP address of your mail server.
7. To close the window, type in the words exit, then hit enter.
Here's the error message:
Could not deliver message to the following recipient(s):
Failed Recipient: xyz@yahoo.com
Reason: Remote host said: 421 Message from (xyz) temporarily deferred - 4.16.50. Please refer to http://help.yahoo.com/help/us/mail/defer/defer-06.html
-- The header and top 20 lines of the message follows --
Received: from IMAIL2 [1.1.1.1] by x.x.x with SMTP;
Wed, 12 Mar 2008 07:21:52 -0500
Received: from syx [1.1.1.1] by x.x.x with ESMTP
(SMTPD-8.22) id AB9C0D58; Wed, 12 Mar 2008 06:16:44 -0500
From: "person a"
To: "'person b'"
References: <010401c8839a$1f5b2b90$5e1182b0$@bailey@bluecreekweb.com> <551043.95195.qm@web53004.mail.re2.yahoo.com>
In-Reply-To: <551043.95195.qm@web53004.mail.re2.yahoo.com>
Subject: RE: New Order
Date: Wed, 12 Mar 2008 07:16:43 -0400
Message-ID: <000001c88432$8dfe1790$a9fa46b0$@bailey@bluecreekweb.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0001_01C88411.06EC7790"
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AciDoLveNFKaJDfJSpGamAweiCoPMgAkcCdg
Content-Language: en-us
X-Declude-Sender: joe.bailey@bluecreekweb.com [97.80.142.6]
X-Declude-Spoolname: Dbb9c02210000d12b.smd
X-Declude-RefID:
X-Note: Outgoing Scanned by IMail.GlobalWeb.net 4.3.64
X-Scan: Score [0] at 06:16:52 on 12 Mar 2008
X-Fail: Whitelisted
X-Country-Chain:
This is a multipart message in MIME format.
So, to file the complaint, I was sent to this Yahoo address for 421 errors: http://help.yahoo.com/help/us/mail/defer/defer-06.html
Once there, I filled out some information, mostly about the email. But, one thing hung me up for a little while. How to get my mail server's IP address. It only took a minute, so here's how to get your mail server's IP address.
1. In Windows, click on Start | run
2. Type in the text cmd then click on the OK button.
3. You should now see a small black window with white text.
4. In that box, type in ping mail.yourdomainname.com (fill in yourdomainname.com with your domain name)
5. Hit enter
6. If this works, you will see the IP address of your mail server.
7. To close the window, type in the words exit, then hit enter.
Here's the error message:
Could not deliver message to the following recipient(s):
Failed Recipient: xyz@yahoo.com
Reason: Remote host said: 421 Message from (xyz) temporarily deferred - 4.16.50. Please refer to http://help.yahoo.com/help/us/mail/defer/defer-06.html
-- The header and top 20 lines of the message follows --
Received: from IMAIL2 [1.1.1.1] by x.x.x with SMTP;
Wed, 12 Mar 2008 07:21:52 -0500
Received: from syx [1.1.1.1] by x.x.x with ESMTP
(SMTPD-8.22) id AB9C0D58; Wed, 12 Mar 2008 06:16:44 -0500
From: "person a"
To: "'person b'"
References: <010401c8839a$1f5b2b90$5e1182b0$@bailey@bluecreekweb.com> <551043.95195.qm@web53004.mail.re2.yahoo.com>
In-Reply-To: <551043.95195.qm@web53004.mail.re2.yahoo.com>
Subject: RE: New Order
Date: Wed, 12 Mar 2008 07:16:43 -0400
Message-ID: <000001c88432$8dfe1790$a9fa46b0$@bailey@bluecreekweb.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0001_01C88411.06EC7790"
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AciDoLveNFKaJDfJSpGamAweiCoPMgAkcCdg
Content-Language: en-us
X-Declude-Sender: joe.bailey@bluecreekweb.com [97.80.142.6]
X-Declude-Spoolname: Dbb9c02210000d12b.smd
X-Declude-RefID:
X-Note: Outgoing Scanned by IMail.GlobalWeb.net 4.3.64
X-Scan: Score [0] at 06:16:52 on 12 Mar 2008
X-Fail: Whitelisted
X-Country-Chain:
This is a multipart message in MIME format.
Subscribe to:
Posts (Atom)