Two and a half minutes of awesome

These guys at SQL PASS presented on using Kinect to interact with SQL. Create databases by raising your arms. Delete databases by kicking them away. Back up databases by bringing your arms back. Awesome!

2

SQL Server Enterprise vs Standard

SQL Server 2008 R2 comes with a lot of features and functionality. Even the Standard version has a long list of capabilities to set DBAs drooling. But then there’s the Enterprise version. A question that comes up, more often than we’d like, is, “Why would I need Enterprise?” If there are so many features available…

5

Connecting to Report Server

Sometimes, people that have been working with a technology for a while assume that something is so obvious, they don’t feel it needs explaining. This means that those who are trying to wrap their heads around something for the first time could be missing a crucial step. They could be staring at the interface feeling…

35

BI Webinars

Is one of your New Years’ Resolutions to do more technical training? If so, you’re in luck. There are a couple of up-coming webinars on Business Intelligence being put on by the Technical Advisory Services. Microsoft Gold Partners are entitled to a number of hours of service from this team and these webinars can count…

0

BI Bites 26: Introducing SQL Server Integration Services

This video continues my series of short Microsoft Business Intelligence demos. Here I introduce SQL Server Integration Services, SSIS, in Microsoft SQL Server 2008 R2. I show how to perform a simple data import from a flat file to a SQL database. [View:https://www.youtube.com/watch?v=jaaWqi6QQfo] This video is available for download from my SkyDrive.

1

BI Bites 24: PowerPivot Management Console

This video continues my series of short business intelligence screencasts. In this demo, I show the Management Dashboard for PowerPivot in Microsoft SharePoint Server 2010. [View:https://www.youtube.com/watch?v=tNy3y5aCFrA] This video is available for download from my SkyDrive.

0

BI Bites 23: PowerPivot Data Connections

This video continues my series of demos showing Microsoft’s Business Intelligence technologies. In this demo, I show how to create a data connection to a SQL table from a PowerPivot file and how to use that data in a pivot chart containing information from other sources. [View:https://www.youtube.com/watch?v=02_pB6Rcq_M] This video is available for download from my SkyDrive.

0

BI Bites 21: PowerPivot Gallery

This video continues my BI Bites series, showing bite-sized demos of Microsoft’s Business Intelligence solutions. Here I show the PowerPivot gallery feature of the PowerPivot add-in for SharePoint Server 2010. [View:https://www.youtube.com/watch?v=Q-2wfcBHc9I] This file is available for download from my SkyDrive.

0

BI Bites 20: Introducing PowerPivot

In this video in my BI Bites series, I introduce the new in-memory analytics tool from Microsoft: PowerPivot. I show the Excel add-in and the new tab as well as introducing the range of data sources that can be used in a PowerPivot application. [View:https://www.youtube.com/watch?v=wOecO36nMe8] This file is available for download from my SkyDrive.

0

BI Bites 19: Gauges

This video continues my series of Business Intelligence bite-sized demos. In this demo, I show how to create a gauge in SQL Server Report Builder 3.0. [View:https://www.youtube.com/watch?v=0IXWEVJMhvw] This video is available for download from my SkyDrive.

0