Skip to main content

Posts

Create Your Own Keep Alive Service

Dear All  You can create your own keep alive service by blow code (Note i got this code but it still not tested yet)  original post  http://al-atari.net/?p=569 Imports System.IO Imports System.Net Imports System.Text Imports System.Net.Mail Module Startup     Sub Main()         Call CheckOneSite("http://www.part-time-work-at-home-opportunities.com/keepalive.aspx")         Call CheckOneSite("http://www.site2.com")         Call CheckOneSite("http://www.site3.com")         Call CheckOneSite("http://www.siten.com")     End Sub     Private Sub CheckOneSite(ByVal pUrl As String)         Try             ' Create a request for the URL.                      Dim lRequest As WebRequest = WebRequest.Create(pUrl)   ...

Keep Alive Free Websites

Dear All, Here are the free website for pinging the DNN website for better performance. http://www.dnnmonitor.com/ http://www.pingalive.com/ http://www.mandeeps.com/ Regards Rashid Imran Bilgrami http://www.bestvisualization.com 

What is Server.Transfer In .net or Server.Transfer vs Response.Redirect

Dear All, Here is a detail video about Server.Transfer vs Response.Redirect command I hope it helps you alot  Regards  Rashid Imran Bilgrami  CEO Best Visualization http://www.bestvisualization.com  

SQL Agent disabled / how to enable SQL agent

Dear Readers, Today i found that SQL agent is disabled and i can active through the below process First you can check first these points Go to run type services.msc Right click on the SQL Server Agent (MSSQLSERVER) Then check in the properties your startup type might be disabled change it to automatic or manual and try again it will enable the start option If the above process not workable then check this one SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online. You need to run the following script under you SQL management Studio 1) Open the new query 2) Past the code sp_configure 'show ...

Autonumber in select statement in SQL Server

Dear Friends You can identify the autonumber with SQL query through  ROW_NUMBER: Here is a query SELECT ROW_NUMBER() OVER (ORDER BY col1) AS rn, * FROM tbl1 To filter the results based on the row number use this: SELECT * FROM (     SELECT ROW_NUMBER() OVER (ORDER BY col1) AS rn, * FROM tbl1 ) T1 WHERE rn = 5 I hope it will help you Regards Rashid Imran Bilgrami http://www.bestvisualization.com

Import Arabic Content From external file Maillist King / Send a blaster Email Program

Dear All If you are facing a problem to import unicode language character  like arabic, russian, german or any other (like ????) during importing the user list and sending email in sendblaster email program or maillist king program then flow the below step to get rid of this issue To solve this sort of encoding problems, simply make sure your language is used both for codepage and for number / dates format. Display language is not relevant. In short, please follow these basic instructions: Open Windows Control Panel, Regional and Language Options, and make sure that 1) in “Format” tab, the format for numbers and dates is set to your language (for example Arabic) – not to English or any other language. 2) In “Advanced” (WinXP) or “Administrative” (Vista, Win7) tab, the “Language for non-Unicode programs” is set to your language (for example Arabic). Changing this will require re-starting your PC. Finally, when you compose your message, choose Unicode charset and make so...

How to use left, right & substring in SQL with String Dynamic Length

Dear Reader Here is an example for how to use Left, right and substring function in SQL Using Right with Reverse String SELECT RIGHT([String],CHARINDEX('%',REVERSE([String]),0)-1) Using Left with String select Left([String],CHARINDEX('%',[String],0)-1) Using SubString with String select Substring([String],0,CHARINDEX('%',[String],0)) Regards Rashid Imran Bilgrami http://www.bestvisualization.com