(Jagadish Chaterjee) This article focuses on retrieving SQL Server 2005 information using SMO together with Visual Basic 2005 and Visual Studio 2005.

(Arthur Fuller) In member discussion posts, I’ve noticed some iteration of the following question crop up several times, “Can I update existing rows and insert (or delete) new ones in a single query?” To me, the point, and the mistake, is the same. I’ll explain.

Eighteen new webcasts are scheduled for February, covering such topics as SQL Server 2005 Essentials: SQL/CLR, Reporting Services Basics, Using .NET Procedural Code in SQL Server 2005 and more.

(Muhammad Mosa) SQL cache dependencies are one of the most wonderful new features in ASP.NET 2.0, the ability to automatically invalidate a cached data object (such as a DataSet or Custom Data Type) when the related data is modified in the database. This feature is supported in both SQL Server 2005

(Art Rask, Don Rubin, and Bill Neumann) This paper describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified database security requirements.

(Stephen J. Friedl) A customer asked that we check out his intranet site, which was used by the company’s employees and customers. This was part of a larger security review, and though we’d not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concep

(Greg Robidoux) You probably already have a process in place to back up SQL Server databases on some set schedule, but what do you do when you need to recover a database? (R)

(SIC) This is a two-part entry that explains the entire process of importing an unformatted Excel Sheet into SQL Server using .Net. The first part deals with the method used to obtain the Excel file path from the client and to open it up on the server. The second part deals with the method I used to

(Gregory A. Larsen) The Data Transformation Services (DTS) tool that you are familiar with in SQL Server 2000 has gone through its own transformation in SQL Server 2005. DTS is no more, but instead with SQL Server 2005 you get a new transformation tool named SQL Server Integrated Services (SSIS).

When you try to run a drillthrough query on a server that is running Microsoft SQL Server 2000 Analysis Services Service Pack 4 (SP4), you may receive the following error message: The Operation requested failed due to security problem – resource access error