Additional Articles

Data Warehouse Capacity Planning as Capacity Enforcement

by Additional Articles

DMReview

Data Warehousing

Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process.

2008-09-19

3,269 reads

SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints

by Additional Articles

Database Journal

SQL Server Express

In the latest articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing Service Broker. This article describes the initial setup of components required to demonstrate a distributed implementation, with initiator and target services residing on two separate computers.

2008-09-18

1,535 reads

SQL Server 2008- SSIS Data Profiling task

by Additional Articles

SimpleTalk

Integration Services (SSIS)

By using SQL Server 2008’s new Data Profiling task, you can do a lot to ensure that data being imported via SSIS is valid, and you can develop a system that can take the necessary steps to correct the commonest problems. Bob Sheldon shows you how to get started with it.

2008-09-18

1,701 reads

Administering your Windows Internal Database (MICROSOFT##SSEE) instance

by Additional Articles

MSSQLTips.com

Embedded Edition

Microsoft products such as Windows Server Update Services (WSUS) 3.0 and Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database, more and more system administrators charged with managing WSUS and WSS are faced with the challenge of managing these databases. Since most of these system administrators are not full-fledged DBAs, how do they manage the Windows Internal Database?

2008-09-17

3,273 reads

Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation

by Additional Articles

Database Journal

Clustering

Part 1 of this series discusses the prerequisites for SQL Server cluster installation. Subsequent installments will provide step-by-step examples of SQL Server 2008 cluster installation.

2008-09-17

1,778 reads

How To Collect Performance Data With TYPEPERF.EXE

by Additional Articles

MSSQLTips.com

Performance Tuning

One of the things I typically need to do is to collect performance data on the server which includes CPU, memory and disk utilization as well as SQL Server-specific data. What command line tools are available to do this?

2008-09-15

4,384 reads

Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?

by Additional Articles

DMReview

Data Warehousing

Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing. The following corollaries to Murphy’s Law relate this inevitability of something going “bump” in the night to data warehousing.

2008-09-15

3,411 reads

Attribute Member Keys – Pt 1: Introduction and Simple Keys

by Additional Articles

Database Journal

Analysis Services (SSAS)

Join Business Intelligence Architect Bill Pearson as he kicks off an exploration of Attribute Member Keys, a continuation of a body of articles surrounding significant components of the Analysis Services dimensional model. In this article we introduce Attribute Member Keys, focusing upon the simple keys and their properties.

2008-09-12

2,459 reads

Best Practices for Data Warehousing with SQL Server 2008

by Additional Articles

TechNet Blogs

Best Practices

There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008.

2008-09-12

5,318 reads

Automatically Running Stored Procedures at SQL Server Startup

by Additional Articles

MSSQLTips.com

Administration

I have a stored procedure I want to run when SQL Server starts. Is there a way to execute this procedure automatically each time the SQL Server service is started?

2008-09-11

3,855 reads

All authors

Additional Articles

Data Warehouse Capacity Planning as Capacity Enforcement

SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints

SQL Server 2008- SSIS Data Profiling task

Administering your Windows Internal Database (MICROSOFT##SSEE) instance

Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation

How To Collect Performance Data With TYPEPERF.EXE

Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?

Attribute Member Keys – Pt 1: Introduction and Simple Keys

Best Practices for Data Warehousing with SQL Server 2008

Automatically Running Stored Procedures at SQL Server Startup

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

A Cloud Dependency Failure from Amazon

Deploying AI in logistics (the unfiltered version)

Forums

Cara buka blokir bank jago yang terkunci

Cara membuka blokir bank jago yang terkunci

Cara membuka blokir bank jago

Question of the Day

Creating a JSON Document III