Category Archives: Business Intelligence

Customizing the Default Logging in SSIS

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, Sometimes definitions are wacky. I thought of writing this article on default logging where I could modify it with my application requirements. And guess what… “Customization with default logging” title rendered in mind. Just for fun if you think about it, when you customize the default logging; it would be custom logging. But custom is also that where you define everything from scratch. So ultimately it makes 2 types of custom logging: one – by using somebody’s readymade logging work and extend it. And second – by developing it from the scratch. 🙂 Today I would show you, … Continue reading →

Singapore SQL User Group – Special Meet Up: “SQL Server for Private Cloud”

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, Singapore SQL User Group is running a special meet up with Microsoft’s visiting speaker from U.S. Topic: SQL Server for Private Cloud Primary Focus: Many customers are deploying virtualized SQL Server in production environment. Join this session to find out about “SQL Server for Private Cloud“, a solution that is part of overall Microsoft Hybrid IT story. It will cover new features & functionalities of SQL Server 2012, System Center 2012, and Windows Server “8” that greatly enhance the capabilities of database applications running in Microsoft Private Cloud and the steps on putting this solution in your customer … Continue reading →

Find all SSRS Reports, Report Locations & Data Sources in ReportServer

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, sometimes opening ReportServer or Reports (Report Manager) takes a while. On the other hand querying database for information is faster than waiting for websites to respond. Here is the quick way to check the number of SSRS reports deployed on report server, their locations (paths) and available data sources. Use <Report Server Name> Go

Continue reading →

Fastest way to find-out/understand relationships between tables in MS SQL Database

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, For most of the BI developers, getting BI related tasks (SSAS, SSIS, SSRS etc.) from multiple teams in company is very common. So in this situation, developer completes a task(s) for one team and goes to another team for different task(s). Once you go to the team for their requirements … lets say for few SSRS reports development or ELT Jobs, you will realize that, they neither have time to give you the proper knowledge transfer nor they could explain the requirements up to the mark how we wanted know in detail. And you have to give the … Continue reading →

Everything about MSBI to learn @ one Place

Khilitchandra's Business Intelligence Blog Posted on by

Guys, Check this out: http://www.microsoft.com/en-us/bi/default.aspx What you will find here: 1. BI TV – industry’s leading Analytics and Business Intelligence TV show 2. BI Lab – a collection of experimental business intelligence projects and applications 3. Blog – BI Subject related Blog entries 4. Evidence – BI Case Studies Thanks, Khilit

Continue reading →

Demo Site is ready with full featured “SQL Server 2012 RC0” to play with

Khilitchandra's Business Intelligence Blog Posted on by

Note: This site requires Windows 7, Windows Vista with SP1/SP2 or Windows XP wth SP3 to have the correct RDP client to use this site. Go to this site http://fs.mssalesdemos.com/, Login with your live ID. Select the “Catalog” tab. Select “New SQL Server 2012-RC0 fully integrated Demo“. The new SQL Server 2012-RC0 demo is fully integrated with SQL Server 2012, SharePoint 2010 and Office 2010 including: • PowerPivot and MDS Excel integration • Reporting Services integration with SharePoint • Power View integrated with SharePoint • Data Quality Services

Continue reading →

12th ‘BI Conference’ on February 11, 2012 in Pune

Khilitchandra's Business Intelligence Blog Posted on by

IBM, Capgemini experts will congregate to speak@Business Intelligence Conf (Feb 11, Pune). The Agenda of the BI is deliberated in such way that it gives realistic skills for Developers and Architects. It is a forum of BI Developers, Architects, Project Managers and Teams, IT Managers and Professionals, Analysts and Business Decision Makers imminent together to build their BI proficiency. Eavesdrop to the BI Expert Mukund Deshpande, AVP – Head BI/Analytics Business Unit, Persistent Systems speak on “Relevance of BIG Data technologies for the Enterprise” and know more about how Big Data can be used to derive intelligent insights and to … Continue reading →

Data Mining for Social Moderation – Event @ Microsoft, Singapore on 6th Feb 2012

Khilitchandra's Business Intelligence Blog Posted on by

The BBC (the British Broadcasting Company), a known media force in Europe, implemented an in-database data mining solution for their public-facing website. The BBC encourages users to post comments and become part of their social media community. In this project, the BBC needed a way to improve the social moderation of millions of posts on thousands of forums. This presentation covers how SQL Server helped designing a model to dramatically help improving the quality and efficiency of the moderation. We also discuss cost efficiencies obtained in this project. More and more organizations will need to use enterprise solutions to handle … Continue reading →