SQL Server Developer

Whether to use UNION or OR in SQL Server Queries

Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken  from the AdventureWorks database […]

Monitor User Connections in SQL Server

Applications typically make connections to the SQL Server databases in large numbers but what if those connections are not successfully closed? How you can monitor them? This short article describes the methods we can use to monitor unclosed connections. Sample Application Let us start with a simple C# WinForms application which has the following UI. […]

Denormalization in SQL Server for Fun and Profit

Almost from birth, database developers are taught that their databases must be normalized.  In many shops, failing to fully normalize can result in anything from public ridicule to exile to the company’s Siberian office.  Rarely discussed are the significant benefits that can accrue from intentionally denormalizing portions of a database schema.  Myths about denormalization abound, […]

Understanding WCF Hosting

 WCF is a flagship product from  Microsoft for developing distributed application using SOA. Prior to WCF   traditional ASMX Web services were hosted only on Internet Information Services (IIS). The hosting options for WCF services are significantly enhanced from Microsoft .NET Framework 3.0 onwards. In WCF there are three main parts: Service, Endpoints and Hosting Environment. […]

Introduction to SQL Azure

Since the SQL Azure database services are in the cloud, you do not have to worry about high availability and scalability. SQL Azure will maintain a “Monthly Availability” of 99.9% during a calendar month. For example, you or your network administrators do not have to spend time on high availability which is taken care by […]

Writing Custom Rules for FxCop

Code review or monitoring inevitably becomes a part of our project’s life cycle. It’s a process which analyzes your code, helps to mitigate issues and reduce the percentage of bugs in testing by performing code cleaning. We can do the code review either manually or, preferably, automatically. In a big project reviewing code manually is […]

New Controls in ASP.Net 3.5

This article will describe the following Ajax extension related controls: ScriptManager, ScriptManagerProxy, Timer, UpdatePanel, UpdateProgress and List View in ASP.NET 3.5.  The article will be divided into two parts; the first section covering Ajax extension related controls and how these controls have fundamentally change the approach of web development, the second will cover the List […]

Getting Started with the ADO.NET Entity Framework Part 4

This article is the final article of a 4-part series on the ADO.NET Entity Framework. This article will describe how to use the Entity Data Model and the Entity Data Source Control to implement a program using the Entity Framework. Using a GridView control to display bound data.  Refer to the solution we created earlier using […]

Getting Started with the ADO.NET Entity Framework Part 3

This article is part three of a four part series on the ADO.NET Entity Framework. This article discusses the new Entity Data Source control which was introduced as part of the Visual Studio.NET 2008 SP1 release. Data controls are those that can be bound to data from external data sources. These data sources may include databases, XML […]

Getting Started with the ADO.NET Entity Framework Part 2

This article is part two of a four part series on the ADO.NET Entity Framework.  In this artilce we will now take a look at how to create a data model using the Entity Data Model generation tool called EdmGen.  The EdmGen.exe command line tool can be used to do one or more of the […]