Architectural Options for Asynchronous Workflow
This article describes the benefits of asynchronous processing and discusses three possible ways to implement this type of workflow within your own systems.
2009-09-28
2,417 reads
Additional Articles
Introduction to Cube Storage
BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.
2009-09-28
3,549 reads
A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network
Database sizes increase constantly, as do requirements for access and availability. At the same time, it is more important than ever to have a fast and reliable backup and recovery plan in place. This document discusses the challenges of designing a robust backup and restore solutions for very large databases (VLDBs). Using a real-world example, it demonstrates how to make the best use of the backup and restore features of SQL Server 2008 to help create a fast and reliable backup and restore plan for VLDBs over the network.
2009-09-25
2,989 reads
Querying a Multi-Tenant Data Architecture
This article discusses different ways to query multiple databases and shows a simple, web-based tool I've created and routinely use for those SaaS-style web applications I work on that use separate databases to store different customer data. Read on to learn more!
2009-09-25
2,679 reads
SQL WHERE Clause Optimization
SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...
2009-09-25
9,654 reads
Multi-Tenant Data Architecture
The second article in our series about designing multi-tenant applications identifies three distinct approaches for creating data architectures.
2009-09-24
3,979 reads
Performance Improvement: Understanding
I'm going to try to lay out some general guidelines for performance improvement through improving understanding about what performance is, how to measure it, and finally solutions to common problems. This article will cover the core understanding of the performance conversation.
2009-09-24
3,790 reads
Service Broker example on how to configure, send and receive messages
SQL Server 2008 and 2005 offer the Service Broker feature. In this tip we will go through the different components of service broker and step by step on how to setup Service Broker for a single database.
2009-09-23
3,250 reads
Ten Pitfalls In Establishing An Enterprise Architecture
Avoiding getting snared in these traps avoids having to spend a lot of money later to fix problems, Gartner says. In addition, EA benefits can be realized faster and the risk of program failure is reduced.
2009-09-23
4,327 reads
Keep Your SQL Server Indexes Fragmentation Free
Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.
2009-09-22
5,457 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers