tag:blogger.com,1999:blog-4856645471511252942024-02-20T18:15:56.478+05:00Hyperlink Solutions: Project management, Consultation, Development @ WebHyperlink Solutions deals in Project management, Consultation, Designing and Development of Web ApplicationsRaja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-485664547151125294.post-21277845354709740852011-04-01T17:13:00.000+05:002011-04-01T17:13:12.638+05:00Gmail Motion - A new era to communicate with your othersThe mouse and keyboard were desiged before the evolution of Internet. Since then, countless technological advancements have allowed for much more efficient human computer interaction. Why then do we continue to use outdated technology? Introducing Gmail Motion -- now you can control Gmail with your body.Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-45084542841830100082011-02-03T08:24:00.002+05:002011-02-03T08:31:24.134+05:00Microsoft Office SharePoint Server(MOSS) 2007 Training for free from Microsoft<div dir="ltr" style="text-align: left;" trbidi="on"><span class="Apple-style-span" style="color: #222222; font-family: Verdana, Arial, 'Trebuchet MS', sans-serif; font-size: 12px; line-height: 18px;"></span><br />
Now you can explore Microsoft Office SharePoint Server (MOSS 2007) with training from Microsoft experts by living at your desktop.<br />
You can download a simple file which have grand tour of the latest features and changes in SharePoint, including automated workflows to track approval cycles, business dashboards showing how well you are performing on your goals, and syncing documents to Outlook.<br />
<strong>Training topics included</strong><br />
<ul style="text-align: left;"><li><strong>Collaboration</strong></li>
</ul><div style="text-align: justify;">Finding your way around a team site Understanding permissions Customizing a team site Linking calendars to Outlook Adding Web Parts Collaborating in libraries, lists, and workspaces Using blogs and wikis to share information</div><ul style="text-align: left;"><li><strong>Enterprise Content Management</strong></li>
</ul>Document management Protecting files Using workflows Records management Creating and publishing Web pages Improving compliance and support litigation discovery<br />
<ul style="text-align: left;"><li><strong>Search</strong></li>
</ul>Finding files, Web sites, information, and people<br />
<ul style="text-align: left;"><li><strong>Portals and personalization</strong></li>
</ul>My Sites Targeting content to specific audiences Managing access to your My Site<br />
<ul style="text-align: left;"><li><strong>Business processes and forms</strong></li>
</ul>Streamlining business processes with forms and workflow Gathering information with browser-compatible forms Designing custom workflows using SharePoint Designer<br />
<ul style="text-align: left;"><li><strong>Business intelligence</strong></li>
</ul>Sharing Excel workbooks as interactive reports Working with a Report Center site Using dashboards to drive decisions<br />
So, why are you waiting …..<b><a target="_blank" href="http://www.microsoft.com/downloads/en/details.aspx?FamilyId=7BB3A2A3-6A9F-49F4-84E8-FF3FB71046DF&displaylang=en">click here</a></b> to download from Microsoft’s official site<br />
<br />
</div>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-1746948390999392622011-01-28T08:00:00.000+05:002011-01-28T08:00:49.002+05:00SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY<div dir="ltr" style="text-align: left;" trbidi="on"><br />
SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY are similar functions because they return values that are inserted into identity columns.<br />
<br />
IDENT_CURRENT is not limited by scope and session; it is limited to a specified table. IDENT_CURRENT returns the value generated for a specific table in any session and any scope. For more information, see IDENT_CURRENT (Transact-SQL).<br />
<br />
SCOPE_IDENTITY and @@IDENTITY return the last identity values that are generated in any table in the current session. However, SCOPE_IDENTITY returns values inserted only within the current scope; @@IDENTITY is not limited to a specific scope.<br />
<br />
For example, there are two tables, T1 and T2, and an INSERT trigger is defined on T1. When a row is inserted to T1, the trigger fires and inserts a row in T2. This scenario illustrates two scopes: the insert on T1, and the insert on T2 by the trigger.<br />
<br />
Assuming that both T1 and T2 have identity columns, @@IDENTITY and SCOPE_IDENTITY will return different values at the end of an INSERT statement on T1. @@IDENTITY will return the last identity column value inserted across any scope in the current session. This is the value inserted in T2. SCOPE_IDENTITY() will return the IDENTITY value inserted in T1. This was the last insert that occurred in the same scope. The SCOPE_IDENTITY() function will return the null value if the function is invoked before any INSERT statements into an identity column occur in the scope.<br />
<br />
</div>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-35203485565301453662010-08-05T22:59:00.000+05:002010-08-05T22:59:30.807+05:00optimizing ASP.NET website/applicationI really like this article. Got a lot of tips from it. I hope you will also like it.<br />
<br />
<a href="http://toddanglin.ulitzer.com/node/1054992">http://toddanglin.ulitzer.com/node/1054992</a>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-3743717880688794212010-08-04T13:03:00.001+05:002010-08-04T13:04:23.432+05:00How to truncate transaction log file via sql statementSometimes you wish to truncate transaction log file via SQL statement. you don't want to create mess as you would have 24x7 (online) production database and recovery model would also be set to full.<br />
<br />
Solution available before SQL SERVER 2005 was very simple. Just run below line and you have achieved your desired results.<br />
<blockquote>backup log dbname with truncate_only</blockquote><br />
But in SQL SERVER 2005 and above, previous statement generates syntax error as it is no more supported in SQL SERVER 2005 and above. Then what is solution for SQL SERVER 2005 and above. Solution is very simple, a regular BACKUP LOG to a backup device is sufficient. That truncates the log. Use below statements in order to get your desired output<br />
<blockquote>use master<br />
alter database dbname set recovery simple<br />
go<br />
dbcc shrinkdatabase(dbname )<br />
go<br />
alter database dbname set recovery full<br />
<br />
go</blockquote><br />
I hope it will solve your problemRaja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-74760049336732513562010-08-03T15:43:00.000+05:002010-08-03T15:43:07.560+05:00Open Source Project Management ToolsHere is list of available project management tools which are currently available for your usage.<br />
<br />
<ol><li><b><a href="http://openproj.org/" target="blank"><span class="Apple-style-span" style="font-weight: normal;">Open Proj</span></a></b></li>
<li><a href="http://www.openworkbench.org/" target="blank">Open Workbench</a></li>
<li><a href="http://www.ganttproject.biz/" target="blank">GanTT Project</a></li>
<li><a href="http://trac.edgewall.org/" target="blank">Trac</a></li>
<li><a href="http://sourceforge.net/projects/dotproject/" target="blank">Dot Project</a></li>
<li><a href="http://www.redmine.org/" target="blank">Redmine</a></li>
<li><a href="http://www.achievo.org/" target="blank">Achievo</a></li>
<li><a href="http://www.projectivity.biz/" target="blank">Projectivity</a></li>
<li><a href="http://www.ehour.nl/" target="blank">eHour</a></li>
</ol><br />
<b><br />
</b>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-4780016502206129922010-08-03T13:27:00.000+05:002010-08-03T13:27:38.037+05:00Find the Most Time Consuming Code in your SQL Server DatabaseI liked this article. I hope you will also get valuable information from it.Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-22375432913193943292010-08-03T13:20:00.001+05:002010-08-03T13:23:01.230+05:00Viewing tempdb Size and Growth ParametersYou can view the size and file growth parameters of the tempdb data or log files by using one of the following methods<br />
<br />
<blockquote>SELECT <br />
name AS FileName, <br />
size*1.0/128 AS FileSizeinMB,<br />
CASE max_size <br />
WHEN 0 THEN 'Autogrowth is off.'<br />
WHEN -1 THEN 'Autogrowth is on.'<br />
ELSE 'Log file will grow to a maximum size of 2 TB.'<br />
END,<br />
growth AS 'GrowthValue',<br />
'GrowthIncrement' = <br />
CASE<br />
WHEN growth = 0 THEN 'Size is fixed and will not grow.'<br />
WHEN growth > 0 AND is_percent_growth = 0 <br />
THEN 'Growth value is in 8-KB pages.'<br />
ELSE 'Growth value is a percentage.'<br />
END<br />
FROM tempdb.sys.database_files;<br />
GO<br />
</blockquote><br />
<br />
Similarly, If the version store is using a lot of space in tempdb, you must determine what is the longest running transaction. Use this query to list the active transactions in order, by longest running transaction.<br />
<br />
<blockquote>SELECT transaction_id<br />
FROM sys.dm_tran_active_snapshot_database_transactions <br />
ORDER BY elapsed_time_seconds DESC;<br />
</blockquote>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-5262156294519263272010-07-07T11:33:00.000+05:002010-07-07T11:33:37.278+05:00Top Ten Questions and Answers on DataI hope you will love this information posted by Microsoft on MSDN.Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-76965026436084128522010-06-23T11:36:00.000+05:002010-06-23T11:36:49.635+05:00Free Controls from DevExpressRaja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-9595452301348233032010-06-17T11:39:00.002+05:002010-06-17T11:39:55.396+05:00http://gmailblog.blogspot.com/2010/06/tip-5-things-you-may-not-know-you-can.htmlhttp://gmailblog.blogspot.com/2010/06/tip-5-things-you-may-not-know-you-can.htmlRaja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-21274013787391520662010-06-14T13:53:00.002+05:002010-06-14T13:54:40.995+05:00Extension methodsI liked above article. I hope you will also like it :)Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-11542833929849177802010-02-02T09:45:00.000+05:002010-02-02T09:47:11.685+05:00New datetime datatypes in SQL Server 2008Please follow the link below to learn more about the new date and time related data types in SQL server 2008.<br /><br /><a href="http://www.databasejournal.com/features/mssql/article.php/3718086/New-datetime-datatypes-in-SQL-Server-2008.htm" target="new">http://www.databasejournal.com/features/mssql/article.php/3718086/New-datetime-datatypes-in-SQL-Server-2008.htm</a>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-78607806797743832212010-02-02T09:42:00.001+05:002010-02-02T09:44:23.971+05:00New Features in .NET Framework 4 and Visual Studio 2010, Beta 2I hope it will give you idea about new features which Microsoft is going to release.Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-31456224734706537812009-11-19T18:10:00.002+05:002009-11-19T18:20:16.666+05:00Most of the time, we, developers, creates temp tables in our stored procedures in order to store temporary data. We, sometimes, encounter an issue when we run that stored procedure, we got exception that #temp table already exists and user doesn't get what he wants.<br /><br /><a href="http://2.bp.blogspot.com/_yfEVO7Y7lmk/SwVF0e1ltrI/AAAAAAAAABQ/pu6SAwit-F8/s1600/tempTable.JPG"><img id="BLOGGER_PHOTO_ID_5405803695661495986" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 282px; TEXT-ALIGN: center" alt="" src="http://2.bp.blogspot.com/_yfEVO7Y7lmk/SwVF0e1ltrI/AAAAAAAAABQ/pu6SAwit-F8/s400/tempTable.JPG" border="0" /></a><br /><div></div><div></div><br /><div>After doing some RnD, i found a solution which really helped me a lot. Please use below TSQL statement(MS SQL SERVER) before you create any temp table. </div><div>if object_id('tempdb..#TableName) is not null drop table #TableName</div><div>then create your #TableName.</div><div> </div><div>It will definitly help out alot in getting rid of displayed exception.</div>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-52255942815195279602009-11-10T11:25:00.003+05:002009-11-10T11:42:27.438+05:00Cannot use a leading .. to exitLast week, When we moved our application from staging site to production site, we were encountered an interesting exception.<br /><br /><br />Cannot use a leading .. to exit above the top directory.<br /><br /><br />Screenshot is attached herewith.<br /><br /><br /><br /><a href="http://4.bp.blogspot.com/_yfEVO7Y7lmk/SvkIUnSKg2I/AAAAAAAAABA/DHKeymCwqEA/s1600-h/exception.JPG"><img id="BLOGGER_PHOTO_ID_5402358378243195746" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 320px; CURSOR: hand; HEIGHT: 240px; TEXT-ALIGN: center" alt="" src="http://4.bp.blogspot.com/_yfEVO7Y7lmk/SvkIUnSKg2I/AAAAAAAAABA/DHKeymCwqEA/s320/exception.JPG" border="0" /></a><br /><br />Please note that we are using Master pages in our application and we had included javascripts and CSS files in this master page. After googling through different forums, I found that ../javascript/a.js was causing this error.<br /><br /><br /><br />Actually, in our staging site, it worked perfectly because ../ was finding parent directory but when that master page moved in parent directory, it didn't had 1 futher parent/top directory. We solved this exception using <span style="color:#663366;"><strong>~/ </strong></span><span style="color:#000000;">sign instead of ../</span>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-35894917867720101392009-10-06T11:35:00.000+06:002009-10-06T11:36:57.021+06:00Hotmail passwords leaked onlinefor more details, check it out Hotmail passwords leaked online<br /><br /><a href="http://windowslivewire.spaces.live.com/blog/cns!2F7EB29B42641D59!41528.entry?wa=wsignin1.0&sa=363915619">http://windowslivewire.spaces.live.com/blog/cns!2F7EB29B42641D59!41528.entry?wa=wsignin1.0&sa=363915619</a>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-32711180488299576372009-07-21T10:35:00.001+06:002009-07-21T10:38:36.888+06:00Silverlight 3 Released<strong>Silverlight</strong> 3 and associated developer tools have been released. Visit the <a href="http://silverlight.net/GetStarted/">Get Started </a>page to download all you need to build great Web experiences with <strong>Silverlight</strong> 3. You can also learn more by watching the new videos, reviewing the QuickStarts, and reading some success stories and what's new in Silverlight 3.Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-27671020884895850602009-07-07T19:35:00.003+06:002009-07-07T19:45:06.692+06:00Cross Browser FindingsHere are my recent findings that I want to share with all of you:<br /><br />1:- if there is nested table in a <TD> tag and you want to assign ID to this <TD> to make it dynamic HTML control, then I will recommend you to assign ID to table and make it HTML control.<br /><br />Similarly, if you want to make <tr> tag as dynamic HTML control, then I will recommend you to make <TD> as HTML control instead of <TR>.<br /><br />Happy coding.Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-28575542046030325702009-06-09T15:31:00.001+06:002009-06-09T15:34:16.328+06:00IIS Search Engine Optimization (SEO) ToolkitThe IIS Search Engine Optimization (SEO) Toolkit helps Web developers, hosting providers, and server administrators improve their sites' relevance in search results by recommending how to make them more search engine-friendly. The IIS SEO Toolkit Beta can be installed with the Microsoft Web Platform Installer 2.0 Beta for use with IIS 7.0 and IIS 7.5. For details, visit <a href="http://www.iis.net/extensions/SEOToolkit" target="_blank">IIS</a> siteRaja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-2391219885549871152009-06-09T15:15:00.006+06:002009-06-09T15:30:50.862+06:00White box Unit testing: Pex - Automated White box Testing for .NETDevelopers, If you are interested in doing white box unit testing of your code, than Microsoft has released PEX for you. For more details and tutorials, please visit <a href="http://research.microsoft.com/en-us/projects/pex/" target="_blank">PEX</a>.Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-76794978558585992952009-06-08T20:27:00.005+06:002009-07-07T19:46:08.032+06:00Custom Error handlings<div>Today, I visited Microsoft's site to view/verify my MCP credentials, which could be acceessed from <a href="https://mcp.microsoft.com/authenticate/validatemcp.aspx">https://mcp.microsoft.com/authenticate/validatemcp.aspx</a>, when i provided my transcriptID and access code, it exposed error screen which is a bad practice. <br /></div><div><br /></div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_yfEVO7Y7lmk/Si0h94TqZOI/AAAAAAAAAAs/wmW5fBMgYcQ/s1600-h/Microsoft+configuration+error.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 300px;" src="http://1.bp.blogspot.com/_yfEVO7Y7lmk/Si0h94TqZOI/AAAAAAAAAAs/wmW5fBMgYcQ/s400/Microsoft+configuration+error.JPG" border="0" alt="" id="BLOGGER_PHOTO_ID_5344965679729239266"></a><br /><div><br /></div><div>If it is bad practice than what is best practice/solution to avoid this yellow screen. I laughed as Microsoft itself gave solution in ASP.NET to avoid this error screen but didn't use itself. In order to avoid this screen, open your application's web.config file, there is a section named as <customErrors mode="Off"/>. By default, it's mode value is "Off" which means that if your application encouter an error, it should display error details to user but safe practice is<br /></div>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-83501243049939966932009-06-05T16:05:00.002+06:002009-06-05T16:09:27.106+06:00Australian IT Salary Survey - How much could you earn in 2009If your interested to move/immigrate to Australia and before doing it, you want to know what could be your possible salary, than <a href="http://www.hays.com.au/salary/pdfs09/Information%20Technology.pdf">here is link</a> for youRaja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0tag:blogger.com,1999:blog-485664547151125294.post-51937546174995753012009-06-03T15:01:00.000+06:002009-06-03T17:25:54.538+06:00Could not load file or assembly 'CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'<div>Today, my team member got new machine where he has only VS 2008 with .Net Framework 3.5 along with all necessary softwares on his machine. We recently have moved our applicatio from .Net framework 2.0 to .Net Framework 3.5, which was, by default, supporting crystal reports 10.2. By default, .Net framework 3.5 supports 10.5 version but we still using Crystal Reports 10.2 vesion. When he compiled project on his machine, he got following configuration error. </div><div><p class="MsoNormal"><span class="Apple-style-span" style="font-style: italic;"><span class="Apple-style-span" style="font-weight: bold;">Could not load file or assembly 'CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.</span></span></p></div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_yfEVO7Y7lmk/SiY8wAvRwoI/AAAAAAAAAAM/CrJ5sUmRSWU/s1600-h/Crystal+report+issue.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 420px; height: 220px;" src="http://2.bp.blogspot.com/_yfEVO7Y7lmk/SiY8wAvRwoI/AAAAAAAAAAM/CrJ5sUmRSWU/s320/Crystal+report+issue.JPG" border="0" alt="" id="BLOGGER_PHOTO_ID_5343024803451355778" /></a><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="color: rgb(153, 0, 0);">Solution</span></span><div>In order to fix this problem, I recommended him to install<span><span> crystal reports runtime <span class="Apple-style-span" style=" ;font-family:verdana;"><span class="Apple-style-span" style="font-weight: bold;">CRRedist2005_x86.msi</span> </span> which could be downloaded after googling it otherwise if any of your computer has VS 2005, you can find it at following path.</span></span></div><div><br /><div><span class="Apple-style-span" style="font-family:verdana;">root\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports\CRRedist2005_x86.msi<br /></span></div></div>Raja Imran Shafiquehttp://www.blogger.com/profile/11669859239210638945noreply@blogger.com0