SQL Server Developer

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 [...]

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 [...]

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 [...]

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 [...]

The ADO.NET Entity Framework, the next generation of Microsoft’s data access technology, is an extended Object Relational Mapping (ORM) technology that makes it easy to tie together the data in your database with the objects in your applications. This is done by abstracting the object model of an application from its relational or logical model. [...]

Step2, Ask our Question I find the best thing to do with data visualisation is to ask a specific question of the data. In this case we ask, What does the World look like if its land mass is reallocated based on CO2 emissions per country in 2004? Lets start by calculating the data that [...]

I’m always impressed by visualisations that can take complex data and present the user with something so meaningful and simple that it gets the message across instantly. I was impressed and inspired by this presentation at TED and thought how hard would it be to do this within the new tools of SQL 2008 Spatial? Join [...]

Introduction This article is nothing new, but well it is worth revising for those who have not used CROSS JOINS. Many of ypu might have faced a problem while dealing with comparisons on a particular set of records. This could be a comparison of Dates or Numbers or anything, but between a specific set of [...]

Visual Studio 2008 comes with a lot of enhancements to its earlier counterpart. This article takes a quick tour of the new features in the Visual Studio.NET 2008 IDE. Here is a list of the new features added to Visual Studio 2008 that we will discuss in this article:   Support for Multi-targeting Integrated Ajax Support [...]

How to track which stored procedure fired a trigger Having one database that supports many applications is very common in an enterprise environment. For example, XYZ Telecom may provide services to its customers through web applications, call centers, billing systems etc. Generally in each of these scenarios the database will remain the same but the [...]