This document contains step-by-step instructions for installing and testing the Microsoft Business Intelligence infrastructure based on SQL Server 2012 and SharePoint 2010, focused on SQL Server 2012 Reporting Services with Power View. This document describes how to completely install the following scenarios: a standalone instance of SharePoint and Power View with all required components; a new SharePoint farm with the Power View infrastructure; a server with the Power View infrastructure joined to an existing SharePoint farm; installation on a separate computer of client tools; installation of a tabular instance of Analysis Services on a separate instance; and configuration of single sign-on access for double-hop scenarios with and without Kerberos. Scripts are provided for all/most scenarios.

SQL in the City - Boston 2012

by Press Release

SQLServerCentral.com

SQL in the City

A free day of training in Boston on Oct 8, 2012. Come join Grant Fritchey, Steve Jones and more to talk about SQL Server and how you can work more efficiently.

Data Worms

by Steve Jones

SQLServerCentral.com

Editorial

Worms have been around a long time in computer systems. However changes in the global policies of governments and the possible retaliation for cyber warfare should have DBAs concerned.

Report Builder 3.0: Formatting the Elements in your Report

by Additional Articles

SimpleTalk

Report Builder

here is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports.

SQL in the City - Chicago 2012

by Press Release

SQLServerCentral.com

SQL in the City

A free day of training in Chicago on Oct 5, 2012. Join Grant Fritchey, Steve Jones and more to discuss, debate, ask questions, and learn about how to better run your organizations SQL Servers.

Dress Like Steve

by Steve Jones

SQLServerCentral.com

Editorial

Come to a SQL in the City event and you might get to dress like Steve.

Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

by Gregory Larsen

SQLServerCentral

You may have data in a database that was inserted into a table by mistake, or you may have data in your tables that is no longer of value. In either case, when you have unwanted data in a table you need a way to remove it. The DELETE statement can be used to eliminate data in a table that is no longer needed. In this article you will see the different ways to use the DELETE statement to identify and remove unwanted data from your SQL Server tables.

SQL in the City - San Francisco 2012

by Press Release

SQLServerCentral.com

SQL in the City

The city by the bay welcomes Steve Jones, Grant Fritchey and more for a day of debate, discussion and learning about SQL Server. It's free. Just register and join us.

Compress Everything

by Steve Jones

SQLServerCentral.com

Editorial

Data grows constantly and the size of some of our databases seems to have no end in sight. Steve Jones notes that we might just want to compress everything, just to keep up.

Run an Oracle package from SQL Server Integration Services

by Additional Articles

MSSQLTips.com

Oracle

If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, you may need to use SQL Server Integration Services (SSIS).

Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

SQL in the City - Boston 2012

Data Worms

Report Builder 3.0: Formatting the Elements in your Report

SQL in the City - Chicago 2012

Dress Like Steve

Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

SQL in the City - San Francisco 2012

Compress Everything

Run an Oracle package from SQL Server Integration Services

Blogs

Monday Monitor Tips: Virtual Machine Usage and Cost

Advice I Like: Respect

Blue Sky Programming – The Optimism Trap

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

Alamat Kontak Resmi BCA KCU GADING SERPONG Telp:08218154393

Alamat Kontak Resmi BCA KCP Kepa Duri Telp:08218154393

Question of the Day

DBCC CHECKDB Limits I