(Mat Stephen) There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005. Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the box’ features. There is one that is wh

(Carvin Wilson) The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. The first article in this series entitled “Using the SQL Distributed Management Objects”, provi

(Sven Cipido) Like every other report, we have some filters when displaying your data. This is also the case for SQL Reporting. But most of the times, those filters have several options to select from. In this article, we will dig deeper into how to add a “Select all” option. With “Select All”, we m

This Support WebCast session will explore I/O-related performance problems and resolutions for Microsoft SQL Server 2000. The session will discuss in-depth monitoring of I/O using System Monitor and Profiler, and will briefly introduce features of MOM 2005 SQL Management Pack. The WebCast will outli

(Ina Fried) After investing significantly in technology for radio frequency identification devices, Microsoft is readying its first major product, a software package designed to help companies manage the product tagging technology. s

(Anand Kumar Rao) Exception management is one of the key area for all kinds of application development .You should adopt an appropriate strategy for exception management to build high quality and robust application .It is a very powerful concept and makes the development work very easy if its used e

(Michael M. David) A mind is a terrible thing to waste and so is the vast quantity of untapped data structure meta information available free for the using in any XML document. This semantic data available in XML is like gold lying on the ground ready to be scooped up and cashed in with little or no

(Raman Iyer and Bogdan Crivat) This article describes how SQL Server 2005 Data Mining allows aggregation directly at the algorithm level. Although this restricts what the third-party algorithm developer can support in terms of language and data types, it frees the developer from having to implement

(Jayaram Krishnaswamy) This tutorial explores the IIS XML support for SQL 2000 Server. By configuring a virtual root on Microsoft Internet Information Services, data from a SQL 2000 server can be accessed using XML over HTTP, the details of which will be examined in another article. This is possible

(Arnay Joshi) This article contains query for nth highest numbers, creating random numbers in SQL SERVER, viewing sequentially numbered records etc. They are frequently asked sql server interview questions.