SQL Server – BI

reportingservices.jpg

Reporting Services, Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

Jul 30th

Posted by Jibran Jamshad in -Microsoft Forums-

View Comments

My Reply was marked as an Answer of MSDN forums regarding this issue, kindly check out the in the following link:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e21dabb5-03e4-4ad7-85d0-f076ac678eaf/#078ce0de-6d2b-4e97-8718-27e626c786dd

performancepoint.jpg

Purchase Performance Point Server 2007

Jul 30th

Posted by Jibran Jamshad in -Microsoft Forums-

View Comments

My reply to this question was marked as an Answer on MSDN Forums, that can one still purchase Performance Point 2007 as the newer 2010 version is available freely with SharePoint 2010. Check out the link below:

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/024e6841-faae-41da-acdb-a70c4d4e8cfc/#a93c3ffd-7b5b-43d1-aca0-5607b10b78f0

image.png

SharePoint 2010 Recover Data of Deleted site from Content Database

Jul 14th

Posted by Jibran Jamshad in MS Office - SharePoint

View Comments

1) Open the Central Administration

2) Click the Backup and Restore link in the Quick Launch

3) Under the Granular Backup heading, click Recover data from an unattached content database

4) On the Unattached Content Database Data Recovery page, specify:

Database Server Name

Database Name

Choose Browse Content in Choose Operation section

5) On the browse content page change the site collection and choose the collection whose data you want to recover. Then specify the specific site and which data parts (lists) you want to recover.

6) Once you’re done with that you need to specify the path for share folder and click the start export.

7) This will More >

image.png

Microsoft Business Intelligence (BI) Platform & Tools

Jun 3rd

Posted by Jibran Jamshad in SQL Server - BI

View Comments

From boardroom executives to frontline operation managers, the uncertain economy has highlighted the necessity—and the benefits—of making informed decisions. To cut costs, streamline operations, and fuel continual process improvements, employees must be empowered to make better decisions at every level in the organization. Critical business data needs to be accessible to all employees, so that they can perform their own analyses and freely share insights with team members. With access to relevant data, employees can find opportunities to operate more efficiently and grow revenues, so the company can emerge stronger from any economic environment. Microsoft delivers a complete Business Intelligence More >

image.png

PowerPivot for Excel 2010 Features

Jun 3rd

Posted by Jibran Jamshad in MS Office - SharePoint

View Comments

PowerPivot for Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. You can transform enormous quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others. PowerPivot can even help your IT department improve operational efficiencies through SharePoint-based management tools.

Excel-Based In-Memory Analysis: Overcomes existing limitations for massive data analysis on the desktop with efficient compression algorithms to load even the biggest data sets into memory.

Data Analysis Expressions (DAX): Puts powerful relational capabilities into the More >

image.png

SQL Server 2008 R2, Master Data Services (MDS)

May 25th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

 

The recent emphasis on regulatory compliance, SOA and mergers and acquisitions has made the creating and maintaining of accurate and complete master data a business imperative.  IT is challenged with delivering high quality master data, creating, maintaining and delivering trusted versions of master data across their applications.

It’s no longer just about having a single version of the truth.  Master data services enables IT to deliver a single authoritative version of master data, while also making it easy for IT and end users to manage the data – and the data about the data; With capabilities like versioning, role security and More >

image.png

SQL Server 2008 R2; Vision evolves from Data to Information Platform

May 24th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

Over the past 5 years Microsoft has been delivering on a vision to build a data platform for its customers. It has been a transformational time for SQL Server and they have delivered innovation to help their customers adapt to the explosion of data in their organizations. They approached this in terms of delivering a platform that supports all types of data as well as all tiers – from the edge, to the datacenter and then to the cloud. They have also delivered robust capabilities to enable you to build access to your data through rich applications and to manage More >

image.png

Team Foundation Server 2010 Security Permissions

May 7th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

Team Foundation Server (TFS) 2010 is a system not a product and is a combination of WSS, SQL Server and TFS it’s self and most of the Errors and Issues We face during during its Installation and Deployment are releated to SECURITY this might not be possible in every case but if you go online and check this will be the case and that’s what i have learnt during my professional career and deploying TFS multiple times.

We need to understand the following components and the User(s) access rights on them are very important and are the root cause!.

1) SQL Server

a) Reporting Services User More >

image_thumb.png

Whats New in Team Foundation Server (TFS) 2010

May 7th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

This week around I spent some time in exploring Team Foundation Server (TFS) 2010. If you are familiar with 2008 and earlier releases of the Product you would find it a bit different and following are the changes which I have identified.

1) The Product is first installed and the files are copied on C:\Program Files\Your Path and then there comes a Configuration Wizard where the main game starts and you are required to configure TFS.

2) The Configuration Wizard is a cool add-up has a rich UI and allows you to configure the product in multiple ways such as you want More >

image.png

Installing and Configuring Team Foundation Server 2010 (Step by Step)

May 6th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

Team Foundation Server (TFS) 2010 is already available and you can deploy and start using it. One ideal scenario for it’s installation is as follows:

1) Take a machine and Install Windows Server 2008 (Enterprise)

2) Create a User Named TFS with Admin rights

3) Then You need to install its Service Pack 2 (NOT R2), Just Service Pack 2

4) Install SQL Server 2008 (Enterprise Edition with all components. Mind you Install Reporting Services in Native mode (not the SharePoint Integrated mode) and DON’T Configure the Reporting Services NOW!

5) Download and Install WSS 3.0 + SP2 and You should be able to successfully More >

123»