Additional Articles

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

by Additional Articles

Microsoft MSDN

PowerView

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.

2012-09-21

2,058 reads

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.

2012-09-20

2,777 reads

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).

2012-09-18

2,524 reads

SQL Server 2012: Migrating BLOBs to FILETABLEs

by Additional Articles

MSDN Communities

FileTable

Learn about this new feature in SQL Server 2012 and how to move your binary data.

2012-09-18

2,896 reads

Distributed Computing - Hybrid Systems Considerations

by Additional Articles

SimpleTalk

Cloud Computing

When the Cloud was new, it was often presented as an 'all or nothing' solution. Nowadays, the canny Systems Architect will exploit the best advantages of 'cloud' distributed computing in the right place, and use in-house services where most appropriate. So what are the issues that govern these architectural decisions?

2012-09-17

1,736 reads

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

by Additional Articles

Microsoft MSDN

Business Intelligence

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.

2012-09-14

3,452 reads

Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test

by Additional Articles

SimpleTalk

tSQLt

The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the one being tested. In retrospect, after using tSQLt for a while, what are the 'gotchas'; those things that you'd have been better off knowing about before you get started? David Green lists a few tips he wished he'd read beforehand.

2012-09-13

4,444 reads

Gail Shaw's SQL Server Howlers

by Additional Articles

SimpleTalk

Simple-Talk Series

For the latest in our series of SQL Server Howlers, we asked Gail Shaw which common SQL Server mistakes and misunderstandings lead to tearful DBAs and plaintive cries for help on the forums.

2012-09-10

3,694 reads

SQLskills training goes online worldwide (and free in September!)

by Additional Articles

SQLskills

Training

SQLskills is recording their knowledge in conjunction with Pluralsight for you to view from the time and place of your choosing. And it's free in September. Read more to find out how you can get access.

2012-09-10 (first published: 2012-09-05)

6,654 reads

Practical PowerShell for SQL Server Developers and DBAs – Part 2

by Additional Articles

SimpleTalk

PowerShell

Having shown just how useful PowerShell can be for DBAs in executing queries, Michael Sorens now takes us through navigating SQL Server space and finding meta-information - valuable information for anyone looking to be more productive in SQL Server.

2012-09-07

2,770 reads

All authors

Additional Articles

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

Report Builder 3.0: Formatting the Elements in your Report

Run an Oracle package from SQL Server Integration Services

SQL Server 2012: Migrating BLOBs to FILETABLEs

Distributed Computing - Hybrid Systems Considerations

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test

Gail Shaw's SQL Server Howlers

SQLskills training goes online worldwide (and free in September!)

Practical PowerShell for SQL Server Developers and DBAs – Part 2

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Future IT Roles – Agentic Architect and AI Boom!!

Free Webinar about Columnstore Indexes

Forums

There's Too Much to Learn

How to Calculate Distance Between Coordinates in SQL Server

SSoL Support on the OS

Question of the Day

SSoL Support on the OS