(Kristofer Gafvert) A view is quite easy to define, but a lot more difficult to create, use and manage. It’s not anymore than a named SELECT statement, or a virtual table. You can select data, alter data, remove data and all other things you can do with a table (with some limitations). But there is

(Drew Georgopulos) Database Tuning Advisor (DTA), the SQL Server 2005 replacement for the Index Tuning Wizard (ITW), has two entry points: –A GUI that practically drives itself –A command line interface with all its traditional gnarly-ness

(Jeff Modzel) There are many ways to execute a Sql Server 2005 Integration Services (SSIS) package. You can use the command line utility DTExec.exe or its window equivalent, DTExecUI.exe. A package can be executed within Sql Server Business Intelligence Studio (Visual Studio) or from a Sql Server

(Alex Papadimoulis) In most installations, SQL Server acts as the bottom layer in a standard application stack (user interface, middle tier, and database). Users rarely know what type of database they’re using, let alone access and use it directly. For this reason, database security configuration is

(Jagadish Chaterjee) This article mainly discusses and compares the features of exception handling in Microsoft SQL Server 2000 with the same features in SQL Server 2005.

(Greg Robidoux) Failing over to another system in a disaster recovery situation is the last thing you want to do. Although you won’t have to do this often, you may need to eventually — and it’s better to be prepared than not. (R)

(M M Harinath) In a typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to format flat file according to our table structure using delimiters. In this Code Snippet, I am going to discuss how to import Flat files to SQL Server.

(Bill Wolff) SQL Server Reporting Services is fast becoming the mainstay for custom reporting in Microsoft-based shops. Connecting to relational tables, views, and procedures is easy and productive, and with version 2005 you have new data source options for multidimensional queries (Analysis Service

(James F. Koopmann) It has been my observation that a lot of us lack the basic skills required to model the simplest of database objects. This article will explore some of the common mistakes and fixes to the breaking of 1NF.

(Michael Livshitz) In Part 1 of this article we compared the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, wrote a few queries for SQL Server 2005 to test the function. In part 2, I am going to describe using the function for .NET applicatio