(Alex Kozak) Removing extra empty spaces is a pretty common task that seems very simple, but in reality it is not as trivial as you may assume. The first impulsive solution that many programmers try is replacing two empty spaces with one, which works as long as the number of empty spaces doesn’t exc

(Jeremy Kadlec) In SQL Server 2000 Enterprise Manager, the Task Pad view was really the only native-reporting interface available and it was limited to database and object-related information. In SQL Server 2005, Microsoft integrates Management Studio and Reporting Services to provide snapshots of r

Twenty-three new webcasts are scheduled for June, covering such topics as Integration Lab, Reporting Services, Getting Started with Data Mining and more.

(Vidya Vrat Agarwal) It is important that Microsoft SQL Server database administrators are familiar with the requirements for SQL Server installation, previous version coexistence issues, and procedures for adding or removing SQL Server components. In this module, you will learn how to plan for a SQ

(Tim Chapman) The ability to immediately access data changes without requiring additional reads from the database can enhance application throughput. When data modification statements are executed in SQL Server 2005, you can capture the data that has been modified and store it for use in subsequent

(Don Kiely) One of the major benefits of writing .NET code to run in the Common Language Runtime (CLR) hosted in any environment is code access security (CAS).

I recently received the following email which brings up a good point for those of you using the Recordset.AddNew method to add new rows to your database tables.

(Michael Livshitz) I think all of us , developing some .NET application (it doesn’t matter ASP.Net or Windows forms) with SQL Server as database, sooner or later face the next task.

(Marcin Policht) The latest article in our series discusses improvements in the transactional support implemented in SQL Server 2005 Integration Services. The more granular scope of transactions, which now can be assigned to arbitrarily designated Control Flow tasks and containers, makes it is possi

Consider the following scenario. You run 32-bit client applications for Microsoft SQL Server 2000 Analysis Services on a client computer that is running Microsoft Windows Server 2003. You install Microsoft Windows Server 2003 Service Pack 1 (SP1) on the client computer. In this scenario, you may not