sanjeev.net

SET vs SELECT - Sql server

noreply@blogger.com (sanjeev sharma) — Mon, 07 Apr 2008 23:50:28 PDT

We always get confused between SELECT and SET when assigning values to variables, and make mistakes. Here in this article, I will try to highlight all the major differences between SET and SELECT,...

To read full. please follow

For a user : silverlight sucks

noreply@blogger.com (sanjeev sharma) — Mon, 21 Apr 2008 03:01:01 PDT

As a developer silverlight is good but from a user point of view it is useless, worthless and always sucks. Everybody (including microsoft) knows over 98% of internet-enabled systems have Flash...

To read full. please follow

Googlebot Attacks !!

noreply@blogger.com (sanjeev sharma) — Mon, 21 Apr 2008 04:00:45 PDT

Do you really want to remain hidden from GOOGLE? .Crawlers always try to get deeper into your web sites. Google has recently decided to let it’s Googlebot crawl through forms in an effort to index...

To read full. please follow

Sql server 2005 : OVER clause

noreply@blogger.com (sanjeev sharma) — Mon, 21 Apr 2008 04:12:43 PDT

I found it very useful. Let me give you a quick overview of the OVER clause. Not very detailed but a will prove a nice kick start for you guys. Lets take a table for our example: create table...

To read full. please follow

Writing Unit test cases : Visual studio 2008

noreply@blogger.com (sanjeev sharma) — Wed, 30 Apr 2008 00:50:45 PDT

One of the great improvements of Visual Studio 2008 brought to developers is the built in support for unit testing. With Unit Testing support, it is very easy for developer to create, execute and...

To read full. please follow

Master pages : ASP.net 2.0 : Visual studio 2005

noreply@blogger.com (sanjeev sharma) — Fri, 02 May 2008 23:24:57 PDT

Introduction to master pages In ASP.NET 1.1, to give your application a coherent style you were using user controls to make one footer and one header, maybe you make one menu, then you drop those...

To read full. please follow

ASP.Net Top Security Issues: Checklist

noreply@blogger.com (sanjeev sharma) — Mon, 05 May 2008 03:32:28 PDT

We all try to make our web sites fully secure. Following is the checklist for all the major security issues. Before deploying your web site you should go thru the list and identify that which all of...

To read full. please follow

Asynchronous calls/ XMLHttpRequest Limitations

noreply@blogger.com (sanjeev sharma) — Thu, 08 May 2008 02:54:35 PDT

XMLHttpRequest can’t access remote servers : For some odd reason, although there are ways in javascript to send and receive data to remote servers, such as through script or iframe elements,...

To read full. please follow

Day Of Week : DateTime Formats

noreply@blogger.com (sanjeev sharma) — Thu, 29 May 2008 20:39:53 PDT

Many times we have to display day of week with date (like Wednesday, 05/28/2008). Getting date is ok; we have different formats (DateTime Formats). None of the formats return day of week. How to get...

To read full. please follow

Number of days in month : Sql server

noreply@blogger.com (sanjeev sharma) — Wed, 25 Jun 2008 05:34:38 PDT

declare @month int, @year int, @date datetime select @month = 2, @year = 2000 select @date = convert(varchar, @year) + right('0' + convert(varchar, @month), 2) + '01' select datediff(d, @date,...

To read full. please follow

SQL Server Function to Determine a Leap Year

noreply@blogger.com (sanjeev sharma) — Wed, 25 Jun 2008 21:20:34 PDT

Problem I need to write a function to determine if particular year is a leap year (i.e. February contains 29 days rather than 28 days). I know that there are various rules for calculating leap years....

To read full. please follow

Writing/Logging Bugs....Must read for QA people

noreply@blogger.com (sanjeev sharma) — Sat, 11 Oct 2008 08:58:00 PDT

Writing is easy, but writing clearly is hard. When it comes to write bug explanations... well, writing seems to get even harder, as far as the IT professional is concerned. In my life as a developer...

To read full. please follow

String type data inside gridview : Preserve extra spaces

noreply@blogger.com (sanjeev sharma) — Mon, 10 Nov 2008 01:25:04 PST

Here’s my problem… Very often we face a gridview "bug" that when we are saving the string data in the database just like this "Sanjeev sanjeev1 sanjeev2 sanjeev123" but when it is shown in...

To read full. please follow

Generate a unique number in Sql Server 2005

noreply@blogger.com (sanjeev sharma) — Sat, 17 Jan 2009 01:47:39 PST

We often find ourselves in the need of generating unique numbers in our database applications. Let us quickly take a tour of how to do that using Sql server 2005. SQL Server contains the NEWID()...

To read full. please follow

Resolving the warning 'Saving changes is not permitted' in SQL Server 2008

noreply@blogger.com (sanjeev sharma) — Sat, 17 Jan 2009 02:05:51 PST

For those new to SQL Server 2008, when you perform operations like Adding/Dropping a column or changing the data type of the column in the Management Studio, a warning pops up: "Saving changes is...

To read full. please follow

Calculate Age using Sql server

noreply@blogger.com (sanjeev sharma) — Wed, 01 Apr 2009 08:45:30 PDT

This simple SQL will help you to calcuate you age using SQL server DECLARE @BirthDate DATETIME DECLARE @CurrentDate DATETIME SELECT @CurrentDate = getdate(), @BirthDate = '11/24/1984' --Add your...

To read full. please follow

Configure MSDE: Installation/Server Setup, Database Creation/Backup/Restore/Deletion using OSQL

noreply@blogger.com (sanjeev sharma) — Tue, 14 Apr 2009 21:39:30 PDT

SERVER SETUP Step 1: Download Microsoft SQL Server 2000 Desktop Engine Service Pack 3 file (MSDE2000A.exe) from http://go.microsoft.com/fwlink/?linkID=14502 Step 2: Execute MSDE2000A.exe to extract...

To read full. please follow

How to get commonly used directories using .Net

noreply@blogger.com (sanjeev sharma) — Sun, 31 May 2009 07:24:10 PDT

Many times we require users home directory and other commonly used directories in .NET, this can be achieved using a combination of the Environment.SpecialFolders enumeration, and the...

To read full. please follow

Where to use Interface and where to use class?

noreply@blogger.com (sanjeev sharma) — Sat, 12 Dec 2009 23:05:56 PST

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; ...

To read full. please follow

What are the advantages of hosting WCF Services in IIS as compared to self-hosting?

noreply@blogger.com (sanjeev sharma) — Tue, 06 Sep 2011 03:52:32 PDT

There are two main advantages of using IIS over self-hosting:- Automatic activation IIS provides automatic activation that means the service is not necessary to be running in advance. When any...

To read full. please follow

Using ANTS Memory Profiler

noreply@blogger.com (sanjeev sharma) — Tue, 06 Sep 2011 04:12:59 PDT

.NET Memory ProblemsAutomatic memory management in .NET makes development a lot easier, but it's still easy to introduce memory leaks into your application. You can never say to yourself, “Wow! I...

To read full. please follow

Sql Server 2005 - Twelve Tips For Optimizing Query

noreply@blogger.com (sanjeev sharma) — Tue, 06 Sep 2011 04:17:04 PDT

I recently came across very nice article about optimization tips for SQL Server 2005. 1. Turn on the execution plan, and statisticsThe first thing you need to do is to use the tools that help you...

To read full. please follow

Basics of WCF Security – Part 1

noreply@blogger.com (sanjeev sharma) — Tue, 15 Nov 2011 01:28:48 PST

Series : Part-1 Part-2 Part-3 Getting started with WCF security In WCF, messages are transmitted over a variety of supported protocols including IPC (named pipes), TCP, HTTP and MSMQ....

To read full. please follow

Basics of WCF Security – Part 3

noreply@blogger.com (sanjeev sharma) — Tue, 15 Nov 2011 01:40:20 PST

Series : Part-1 Part-2 Part-3 In last edition of Basics of WCF Security series, we discussed ProtectionLevel Security Setting in WCF. Today’s WCF corner is a continuation on the same...

To read full. please follow

Basics of WCF Security – Part 2

noreply@blogger.com (sanjeev sharma) — Tue, 15 Nov 2011 02:20:42 PST

Series : Part-1 Part-2 Part-3 In last Article of Basics of WCF Security series, we discussed Core Security Concepts, Transport and Message level security basics and started...

To read full. please follow