Gyan Guru - Imbibing Knowledge

Imbibing Knowledge

Imbibing knowledge

I am hiring technology geeks

Hi All,

I am hiring hardcore technology geeks for my new product development team. I am looking for geeks in MS .Net 3.5, MWF, MCF, MPF, Silverlight, VISIfire, SQL Server 2k5.

Interested? Contact me now...

Regards,
Akash

What is the other place you can find me...

My own personal technology blog...
http://www.manmadecode.com and http://www.developerslogic.com

You can check my other blog too at http://geekspeak.ning.com

Members

View All

Groups

Team i-Vista

6 members

View All

Latest Activity

Subhash Babu Rampuri updated their profile

May 21

Akash replied to Thejesh Sugow's discussion 'Widget for Cricket SMS alert for T20 Matches'

160by2.com is a free SMS service for sending free personal messages and cannot be used with an intend to make business. SMS alerts can be packaged and personalized based on the frequency of updates required. Regarding the Widget (Desktop or Web),...

May 14

Thejesh Sugow updated their profile

May 14

Thejesh Sugow added a discussion

Widget for Cricket SMS alert for T20 Matches

Hi Guys, Can we have Widget for Cricket SMS alert for T20 Matches with following options. Radio button Options 1. Update Score every 4 Overs. 2. Update Score when Wicket falls. 3. Update on End of 10 Overs 4. Update on End of One side batting. ...

May 14

Gyan Guru now has birthdays

March 12

Akash added a blog post

Smarter the Better – SQL Server Tips – Part 01

March 8

Sajesh updated their profile

February 9

Sajesh replied to Sajesh's discussion 'Help required for Using FOR XML EXPLICIT'

Thanks Akash,Query is working as expected.

February 9

Blog Posts

Smarter the Better – SQL Server Tips – Part 01

There are many occasions where a SQL Server Developer uses scripts which take longer to execute. I would rather say a wrong choice or approach in writing scripts caused the execution of the script longer. There are smarter ways to achieve results. In this post I will try to consolidate few tips on smarter SQL Server programming.

Do you want to delete all rows from a table?
Use Truncate instead of Delete statement. Truncate is faster and… Continue

Posted by Akash on March 8, 2009 at 7:30pm

Understanding and Using PIVOT clause in SQL Server 2005

SQL Server 2005 has lots of new features, of which one is PIVOT clause. This is similar to Pivot tables in MS Excel and Matrix Control in Reporting Service. Here is a simple example demonstrating how to use PIVOT clause. I am right now taking a simple example. There are scenarios where there could be a need to write a big stored procedure to build a Pivot table in lower versions of SQL Server.

Do run the below query in Query Analyzer t… Continue

Posted by Akash on February 7, 2009 at 9:24pm

Using Advanced Stream Redirector (ASX) to stream audio/video through HTTP Protocol

Advanced Stream Redirector (ASX) files are based on the Extensible Markup Language (XML) syntax, and are made up of various elements with their associated tags and attributes. This is designed to store a list of Windows Media files (.WMA, .ASF, .WMV) to play during a multimedia presentation. The ASX files can be effectively used to play songs over the Internet/Intranet through HTTP protocol.

I will not write here on how one shoul

… Continue

Posted by Akash on February 1, 2009 at 6:00am

How to open .MSG Outlook file in Internet Explorer from a web application?

Considering an example web application where the application allows uploading files with extension DOC, RTF, XLS, PPT, GIF, JPEG, PDF and MSG. The view page has the list of attachments and allows viewing files by invoking relevant applications. But files with .MSG do not open or do not invoke Outlook to view it.

The solution for this is in fact very simple. Do follow the following steps:

Open IIS and navigate to the web site

… Continue

Posted by Akash on January 18, 2009 at 11:30am

How to check a web form can have HTML/Script Injection?

Injection of HTML code and/or client side scripts like JavaScript, VBScript, and Jscript by malicious web users into the web pages viewed by other users is a computer security vulnerability typically found in web applications. This is popularly known as Cross Site Scripting (XSS) Attack.

Injection of the code can be done either from a web form or through a query string input. To check whether your web application is open to XSS, insert the following code given below in the Input T… Continue

Posted by Akash on January 10, 2009 at 10:30am

Forum

Widget for Cricket SMS alert for T20 Matches 1 Reply

Hi Guys, Can we have Widget for Cricket SMS alert for T20 Matches with following options. Radio button Options 1. Update Score every 4 Overs. 2. Update Score when Wicket falls. 3. Update on End o...

Started by Thejesh Sugow. Last reply by Akash May 14.

Help required for Using FOR XML EXPLICIT 2 Replies

Can any body help me out in using FOR XML EXPLICIT clause in sql 2000 I want to generate XMl in the below mentioned Format <Career> <Details> <FirstNa </FunctionalArea> <I...

Tagged: Sql, 2000, Explicit, EXPLICIT, XML

Started by Sajesh. Last reply by Sajesh Feb 9.

What is new in IIS 7 web server?

Debuting with Windows Vista, and also included in Windows Server 2008, IIS 7.0 features a modular architecture. Instead of a monolithic server which features all services, IIS 7 has a core web serv...

Tagged: windows vista, windows, modular architecture, modular, web

Started by Akash Oct. 8, 2008.

Welcome to
Gyan Guru

Sign Up
or Sign In