(Ciprian Jichici) This article describes the CLR integration into the SQL Server 2005 Database Engine in detail and provides some background for answering two integration-related questions.

(Mike Gunderloy) As every developer knows by now, Microsoft has focused renewed attention on security in recent product releases. One of the important concepts in this effort is surface area. Roughly speaking, a piece of software has a smaller surface area if there are fewer ways to attack it: fewer

(William Pearson) In this article, we will examine a subject that is near and dear to broadly focused report authors – the use of cube structure to create desired cosmetic effects – in the Cube Browser, and more importantly, in a reporting environment. I constantly get e-mails, and see questions

In this exercise, you will use the .NET Compact Framework and SQL Server CE to configure merge replication, build an application user interface, subscribe to a SQL Server publication, modify and synchronize data, and resolve conflicts.

(Greg Robidoux) In a previous tip we discussed the different recovery models SQL Server offers and decision points on which to base your recovery model selection. After you’ve selected the appropriate recovery model, you need to put in place the proper backup strategy to minimize data loss and downt

(Mahesh) Microsoft SQL Server 2005 features the integration of CLR component of the .Net framework allowing the developers to seemingly use the power of .Net languages like C#, VB .Net, J# etc in writing stored procedures, triggers, user-defined types, and user-defined function.

(Sara Rea) This chapter uses a fictional retailer named Savings Mart to show how Microsoft’s Analysis Services, included with Microsoft SQL Server, can be used to improve operational efficiencies and reduce costs.

When you use the SqlClient class in a Microsoft .NET Framework client application to work with Microsoft SQL Server 2000 hotfix build 2000.80.811 or a later version, you may receive an error message if the following conditions are true:• Your application tries to call a stored procedure. • The o

(Chip Andrews) Welcome to part two of our series on finding and patching SQL Servers in your organization. In part one we discussed how to find all of the SQL Server instances on your network. In this part, we’ll discuss patch deployment and the various options available to you. (R)

When the Microsoft Operations Manager (MOM) 2005 Management Server and the MOM 2005 database reside on the same computer, you may receive the following error message every 24 to 120 hours: Old format or invalid type library error when processing MOM data