Microsoft IT protects against unplanned Transactional Replication outages and issues by using best practices and proactive monitoring. This results in increased stability, simplified management and improved performance of transactional replication environments.  Read more...

Today we have a guest editorial from Brad Wallace that is an attempt to answer the question 'Why is database engineering so expensive?'  Read more...

In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...  Read more...

Welcome to this semester's security week at SQL University. In previous semesters we've covered the technical aspects of SQL Server...  Read more...

In this article, Zach Mattson shows us how you can set up SSIS to handle multiple application environments and easily move packages from development to QA to production.  Read more...

This post comes from a conversation I had with a developer last week as well as my experiences over the...  Read more...

Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.  Read more...

Read more...

Reporting is one of the key parts of any data warehouse or business intelligence systems. Vincent Rainardi has brought us some great information on data warehousing and now turns his attention to some of the very useful new features in Reporting Services 2005.   Read more...

This article, the third in a series on enterprise architecture, discusses the approaches to developing an enterprise architecture, describing the methods, benefits and pitfalls of each.  Read more...

This article, the second in a series, discusses what items could be contained in the enterprise architecture and touches briefly on how to organize the objects.  Read more...

A new generation of computationally intensive scientific research projects relies on volunteers from around the world contributing idle computer time to calculate mathematical models. Many of these projects utilize a common architecture to manage the scheduling and distribution of calculations and collection of results from participants. User engagement is critical to the success of these projects, and feedback to participants illustrating their role in the project’s progress is known to increase interest and strengthen the community.  Read more...

Reporting is one of the key parts of any data warehouse or business intelligence systems. Vincent Rainardi has brought us some great information on data warehousing and now turns his attention to some of the very useful new features in Reporting Services 2005.   Read more...

In response to his article on using Reporting Services to manage rights, Jonathan Spink takes a look at how Reporting Services can be positioned in your enterprise.   Read more...

Reporting Services was one of the most popular add-ons to SQL Server 2000 and the next version has been greatly improved. Author Kamran Ali brings us a look at some of the new features and enhancements in this platform.   Read more...

A Feature comparison of Reporting Services for SQL 2000 and Crystal Reports / Crystal Enterprise. PDF file link.   Read more...

A key service pack has now been released for Microsoft SQL Server Reporting Services. This one adds key enhancements and fixes many bugs.  Read more...