SQL Server Developer

Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)

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

Compare Dates

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

New Features in Visual Studio 2008

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 use CONTEXT_INFO in SQL Server

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

New Data Types in SQL Server 2008 Part 3

Introduction This is the third article of the new data types in SQL Server 2008 series. We have already discussed the new date time data types in the first article and HierarchyID in second article. In this article, we are going to discuss spatial data types. Spatial data represents information about the physical location and […]

New Data Types in SQL Server 2008 Part 2

Introduction This is the second article in the New data types in SQL Server 2008 series. We have already discussed the new date time data types in the first article. In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 […]

SQL Server 2008 New DATETIME DataTypes

Introduction SQL Server 2008 has arrived – not fully, but as a CTP version. Whenever you hear about new software, the first and most obvious question is “What are the new features?”. There are many new features and facilities in SQL Server 2008. This article is going to cover the newly introduced data types in SQL […]

CLR Integration in SQL Server 2005

The Common Language Runtime (CLR) of the .Net framework is integrated into SQL Server 2005. The CLR supplies managed code with services such as cross-language integration, code access security, object lifetime management, and debugging and profiling support. CLR provides various functions and services required for program execution, including just-in-time (JIT) compilation, allocating and managing memory, […]

Working with XML Data in SQL Server 2005

XML is one of the data types in SQL Server 2005.It is considered as one of the significant changes introduced in SQL Server 2005.In the previous versions, storing and retrieving XML data were possible but it was not as easy and extensible as it is in the current version. The XML data type lets the […]

Notification Services in SQL Server 2005

SQL Server Notification Services is used for developing and deploying applications that generate and send notifications. Notifications are personalized messages sent to a device that subscribes to them. A subscription defines the preference of the subscriber for a specific type of event. For example, a subscriber can specify a preference to the notification application such […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |