(Arthur Fuller) The LINQ (.NET Language Integrated Query) Project is a Microsoft initiative to standardize data access across not only data sources but also development. A number of developers who have examined LINQ have proclaimed that it will revolutionize database application development.

The main purpose of the APIs is to protect columns, fields or rows from certain users who are otherwise authorized to access a table. For example, while you may want everyone to be able to access the customer table, you may want only certain users or roles to access the credit card column. You can a

(Sahil Malik) My previous three articles covered the nitty gritty of CLR integration in SQL Server 2005 (SQLCLR). In addition to discussing the correct usage, they also explored various SQLCLR features (such as context connections) and their uses and restrictions.

(Douglas Reilly) Linchi Shea is a database expert specializing in enterprise management for SQL Server. He has written a series of articles for SQL Server Professional and what is arguably the book on SQL Server administration, Real World SQL Server Administration with Perl. I have seen Linchi on a

(Andrew Novick) Writing stored procedures and other code in .Net languages is a very attractive idea to a lot of developers. But is it a good idea? What’s the performance going to be like? Is it going to bring my server to its knees?

You may receive an access violation exception if all the following conditions are true: • You connect to a linked SQL server by using remote access. • You run the DBCC FREEPROCCACHE Transact-SQL statement on the linked server to remove all elements from the procedure cache. • The remote acces

(Alan Zeichick) Microsoft’s SQL Server has long been a favored platform for software developers—both enterprise and commercial. The low cost of the software keeps down the expenses involved in building and deploying applications. The fact that SQL Server is tightly coupled with Windows makes it

(Kimberly L. Tripp) SQL Server 2005 provides non-locking, non-blocking read consistency to your users via snapshot isolation. Find out when to use it to improve performance and reduce latency in your applications.

(Barend Jnr) This article will show you how to do really, really simple data paging in Microsoft SQL Server 2000.

(Marcin Policht) In the previous article of our series dedicated to new features in SQL Server 2005 Integrated Services, we started exploring methods of incorporating Windows Management Instrumentation (WMI) based data into the package flow control. As explained, this functionality has been implemen