Social Analytics and BI using SQL Server

Etienne Oosthuysen (Senior Consultant (Business Intelligence) – Consultant at Chamonix IT Consulting, and MS vTSP),  have been working on a solution that uses the MS BI stack (SQL Server 2012 and SharePoint 2010) to acquire data from Twitter and load it into a BI optimised database, and includes a xVelocity Analytic Engine and Interactive Reports, Dashboards and Decomposition. we are aware…


Country wide Briefing:- Mission Critical Confidence in the Enterprise

  High availability, manageability, performance, scalability, security and compliance – a heavy  set of requirements for meeting the needs of a mission critical workload.  SQL Server 2012 is setting the new standard for these criteria —helping customers achieve the uptime and performance they need at a low Total Cost of Ownership (TCO), backed by built-in…


TechEd Australia 2012: Call for Topics is Live!

Planning for TechEd Australia 2012! is well underway, and this year I have the opportunity to assist Database & BI track along with my colleagues Marcy Larsen, Shashank Pawar, Ron Dunn and Simon Brown. TechED wouldn’t be a success without great content from the field, and as such it presents an opportunity to showcase your…


Try Power View for a Chance to Win Prizes

Microsoft BI Team are kicking off a new contest today centered on Power View, and you will have the opportunity to participate and win prizes. Power View is the new interactive data exploration and visualization tool on SQL Server 2012. Starting today and continuing every Tuesday and Thursday until March 6, 2012, the BI Team…


Date Table for PowerPivot, without a valid table on the Source (On the Fly Generation)

Ever wondered on how to get a table with dates for various needs in PowerPivot where the source does not contain any such table?. Here is a short T-SQL Code to generate the Table with Dates. Since it’s a standard T-SQL code, you should be able to modify the columns returned as you need them…


Learn SQL Server 2012 Development Now!

If you want to learn how to develop database and business intelligence solutions that fully exploit SQL Server 2012 improvements, this resource is for you! The SQL Server 2012 Developer Training Kit includes technical content like labs, demos and presentations that you can use to learn SQL Server 2012 or to deliver your own training…


Denali – Feature Update Event @ Adelaide – SA

      The Next Major Release of SQL Server is Coming – Are You Ready?   SQL Server Codename “Denali” is the next major release of SQL Server following SQL 2008 R2. It is currently in pre-release (CTP 3) and the release date is expected to be announced soon. Denali is a cloud-ready information…


Connecting to SQL Server Analysis Services using a Different Domain Account that the user currently log on (SSAS on Different Domain and the user logon to another Domain)

If you have logged in to different domain (Domain XYZ) than the SSAS Server (Domain ABC) belong to (For Ex. SSAS server is member of Domain ABC and user normally log in to Domain XYZ, there is no trust exist between these domains) connecting to SSAS from the work station using various presentation tools (Ex….


SQL Server Code Name “Denali” CTP3 Product Guide

We are pleased to announce the release of the SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3) Product Guide v1. This is a single download that organizes the CTP3 content for easier viewing. It is available for download at   The SQL Server Code Name “Denali” CTP3 Product Guide includes useful resources…