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 →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 →
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 →
Guys, I know we can simply Google this information. But believe me these links are quite enough to your quick start needs for SQL Server 2012 RC0 🙂 Where can I download it from? http://www.microsoft.com/download/en/details.aspx?id=28145
Continue reading →Well, the correct answer to this question is – “That Depends“. There are lots of things requires your attention when you start making your package configurable. For better illustration, lets take e.g. of one simple scenario. I have a package named “TransferDataPackage.dtsx“. This has only one data flow task in which, i have a OLEBD Source and OLEDB Destination tasks. In short, i am transfering data from “SourceServer” to “DestinationServer”. (Names in double quotes are exact names of entities used in example) And now i want to make this package configurable. Demo project is shown below:
Continue reading →