Additional Articles

Building a Data Foundation for a BI Solution

by Additional Articles

TechNet Blogs

Business Intelligence

August 2009
Business Intelligence: Planning Your First Microsoft BI Solution
Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner
Business Intelligence: Building a Data Foundation for a BI Solution
See how you can design and build a data mart that uses SQL Server 2008 Integration Services to perform the extract, transform and load (ETL) processes for the Adventure Works BI solution introduced in "Planning Your First Microsoft BI Solution." Derek Comingore

2009-07-22

2,055 reads

Using SQL Server Data Mining Add-Ins for Office 2007 to Predict Database Growth Trends - Part 2

by Additional Articles

MSSQLTips.com

Data Mining

I want to show you another easier way to pull information to help predict database growth again using the Data Mining Tools.

2009-07-22

2,359 reads

Cloud Computing with Microsoft Azure SDS

by Additional Articles

Database Journal

Cloud Computing

Don Schlichting introduces the Microsoft Azure service and explores the SQL Data Services (SDS).

2009-07-21

2,879 reads

Planning Your First Microsoft BI Solution

by Additional Articles

TechNet Blogs

Business Intelligence

Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner

2009-07-21

3,718 reads

Retaining historical index usage statistics for SQL Server - Part 3

by Additional Articles

MSSQLTips.com

Indexing

In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.

2009-07-20

2,160 reads

Using the Resource Governor

by Additional Articles

TechNet Blogs

SQL Server 2008

SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.

2009-07-20

2,190 reads

Context Switching or Database Impersonation using EXEC AS

by Additional Articles

SQL Server Performance

Execute AS

SQL Server 2005/2008 provides the ability to change the execution and security context with the EXEC or EXECUTE AS clause to allow a user to perform high privileged activities without allowing the user to have high privilege access.

2009-07-17

2,114 reads

Setting up Service Broker for secure communication

by Additional Articles

SearchSQLServer

Service Broker (SSSB)

Securely sending Service Broker messages from instance to instance requires a somewhat complex configuration. This tip walks you through the proper methods

2009-07-17

1,595 reads

SQL Server Best Practices - Implementation of Database Object Schemas

by Additional Articles

TechNet Blogs

SQL Server 2008

SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server.

2009-07-17

4,124 reads

Creating a Member Selection Dashboard Filter in Performance Point Server 2007 (PPS)

by Additional Articles

MSSQLTips.com

PerformancePoint

We have heard that you can create filters in a Performance Point dashboard then apply them to one or more reports and scorecards. Can you provide some step-by-step instruction on how to do this?

2009-07-16

2,102 reads

All authors

Additional Articles

Building a Data Foundation for a BI Solution

Using SQL Server Data Mining Add-Ins for Office 2007 to Predict Database Growth Trends - Part 2

Cloud Computing with Microsoft Azure SDS

Planning Your First Microsoft BI Solution

Retaining historical index usage statistics for SQL Server - Part 3

Using the Resource Governor

Context Switching or Database Impersonation using EXEC AS

Setting up Service Broker for secure communication

SQL Server Best Practices - Implementation of Database Object Schemas

Creating a Member Selection Dashboard Filter in Performance Point Server 2007 (PPS)

Blogs

Vibe Coding a Login Tracking System

4 CPE Opportunity (Virtual) for Charity

Data Céilí 2026 Call for Speakers!

Forums

T-SQL in SQL Server 2025: The || Operator

Your Value from a Conference

UNISTR Basics

Question of the Day

UNISTR Basics