Gyan Guru

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

  • Fritz Cremer
  • Anirban Sengupta
  • Ravi
  • namanvb
  • Raghuram C S
  • Madhav
  • Venugopal Gella
  • Rohit
  • Ranjan Patra
  • Ramakrishnan
  • Deepa Tomar
  • Subhash Babu Rampuri
  • Rajeshwari
  • Sony Paul M
  • Thejesh Sugow
  • Sudhish

Groups

Latest Activity

May 21
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
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
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....
March 8
Sajesh updated their profile
February 9
Thanks Akash,Query is working as expected.
February 9
 

Blog Posts

Akash

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

Akash

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

Akash

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

Akash

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

Akash

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

Thejesh Sugow

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.

Sajesh

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.

Akash

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.

 
 

About

Akash Akash created this social network on Ning.

Create your own social network!

Do You Need Help?

Badge

Loading…

Birthdays

There are no birthdays today

 

© 2009   Created by Akash on Ning.   Create Your Own Social Network

Badges  |  Report an Issue  |  Privacy  |  Terms of Service