SQLServerCentral.com Articles tagged Architecture

Designing & Maintaining SQL Server Transactional Replication Environments

Fri, 12 Oct 2012 06:00:00 UT

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.

The Pencil Analogy

Thu, 18 Aug 2011 06:00:00 UT

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

Use Patterns and Prior Code and Don't Reinvent the Wheel

Tue, 22 Feb 2011 07:00:00 UT

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

SQL University: Architecting SQL Server Security, the Big Picture

Tue, 08 Feb 2011 07:00:00 UT

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

SSIS for Multiple Environments

Tue, 27 Apr 2010 06:00:00 UT

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.

Don't Throw Something New In At Production Deployment

Fri, 26 Mar 2010 06:00:00 UT

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

Patterns For High Availability, Scalability, And Computing Power With Windows Azure

Thu, 07 May 2009 06:00:00 UT

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.

New Features in Reporting Services 2005

Mon, 26 May 2008 06:00:00 UT

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.

Enterprise Architecture – Connect-the-Dots for Adults, Part 3

Mon, 26 Nov 2007 07:00:00 UT

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.

Enterprise Architecture: Connect-Dots for Adults, Part 2

Tue, 20 Nov 2007 07:00:00 UT

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.

Reporting@Home: Delivering Dynamic Graphical Feedback to Participants

Tue, 07 Aug 2007 06:00:00 UT

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.

New Features in Reporting Services 2005

Mon, 26 May 2008 06:00:00 UT

Reporting v Editing

Tue, 12 Sep 2006 06:00:00 UT

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.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Microsoft Reporting Services 2005 Features and Enhancements

Wed, 22 Feb 2006 07:00:00 UT

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.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Reporting Services vs. Crystal Reports

Tue, 03 May 2005 06:00:00 UT

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

Reporting Services SP1 Released

Fri, 25 Jun 2004 06:00:00 UT

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