(Arthur Fuller) SQL Server developers sometimes have to use tables residing in a database other than a project’s “home” database. This need typically arises when you need to draw information from some other application; for instance, you may want to be able to SELECT from one or more tables residing

(Larry O’Brien) Whether it’s full-text search or geometric queries, you’ll have to move beyond BLOBs to get the most from storing Ink in the database. The SQL standard does not provide an Ink storage type, so the question is what shape the underlying database should take to accommodate your needs? T

(William Pearson) In this lesson we revisit an approach to automated / scheduled processing of an Analysis Services database (and related objects), a subject that we undertook in my article Process Analysis Services Cubes with DTS (Database Journal Introduction to MSSQL Server Analysis Services seri

In Microsoft SQL Server 2000, when you query a view that was created by using the VIEW_METADATA option, an access violation may occur.

(Baya Pavliashvili) Data warehousing has been around for decades. Yet, many businesspeople and quite a few technical folks don’t know what it takes to build a warehouse. Most people think that a warehouse is a data store that contains all data within the enterprise, is built within a couple of weeks

Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality. These courses, valued at $99 each w

(Alf Pedersen) If you need moving the database to another location, the attach and detach functionality is indispensable. As many of you may or may not know, SQL Server is a database management system used to store data and objects needed to work with that data.

(Marcin Policht) In the previous two articles of our series dedicated to SQL Server 2005 Integration Services, we demonstrated versatility of the Script Component, which is capable of operating as either a Data Flow source or a transformation. In addition, it is also possible to have this component

When you run Multidimensional Expressions (MDX) queries in Microsoft SQL Server 2000 Analysis Services, real-time updates that are made on Relational Online Analytical Process (ROLAP) partitions may not be reflected in the query results. This problem may occur when the following conditions are true:

(Jagadish Chaterjee) This article is the second in a series focusing on retrieving SQL Server 2005 information using SMO along with Visual Basic 2005 and Visual Studio 2005. With the basics covered in the previous article, this one goes right into technical information.