Posts tagged SQL Server 2008 R2

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_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 >

sqlserver2008_250

SQL Server 2008 R2 Reporting Services, SharePoint List Data Source

Apr 27th

Posted by Jibran Jamshad in MS Office - SharePoint

View Comments

Increasing numbers of companies use SharePoint lists to store information that needs to be shared with a broader audience or in a standard report format. Although there are some creative ways you could employ to get that data into Reporting Services, custom code was always part of the solution.

SQL Server 2008 R2 Reporting Services has a new data extension provider that allows you to access SharePoint 2007 or SharePoint 2010 lists. After you create the data source using the Microsoft SharePoint List connection type and provide credentials for authentication, you must supply a connection string to the site or sub-site in the form of a More >

hardware

SQL Server 2008 R2 Hardware Requirements

Apr 27th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

HARDWARE COMPONENT REQUIREMENTS Processor type: (64-bit) x64 ■ Minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64Tsupport ■ Processor speed: minimum 1.4 GHz; 2.0 GHz or faster recommended

Processor type: (32-bit) ■ Intel Pentium III-compatible processor or faster ■ Processor speed: minimum 1.0 GHz; 2.0 GHz or faster recommended

Memory (RAM) ■Minimum: 1 GB ■Recommended: 4 GB or more ■Maximum: Operating system maximum

Disk Space Database ■Engine: 280 MB ■Analysis Services: 90 MB ■Reporting Services: 120 MB ■Integration Services: 120 MB ■Client components: 850 MB ■SQL Server Books Online: 240 MB

More >
sqlserver2008_250

SQL Server 2008 R2 Editions

Apr 27th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

SQL Server 2008 R2 Editions

SQL Server 2008 R2 is available in nine different editions. The editions were designed to meet

the needs of almost any customer and are broken down into the following three categories:

■ Premium editions

■ Core editions

■ Specialized editions

Premium Editions

The premium editions of SQL Server 2008 R2 are meant to meet the highest demands of

large-scale datacenters and data warehouse solutions. The two editions are

■ Datacenter For the first time in the history of SQL Server, a datacenter edition is offered.

SQL Server 2008 R2 Datacenter provides the highest levels of security, reliability,

and scalability when compared to any other edition. SQL More >

image.png

Creating a Map Report using Spatial Data in SQL Server 2008 R2

Apr 16th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

Note: We are using AdventureWorks2008R2 DB in this step by step lab as it contains Resellers Addresses as Spatial Data.

1. Start Microsoft SQL Server Business Intelligence Development Studio from Start | All Programs | Microsoft SQL Server 2008 R2.

2. Create a new Report Server Project.

3. Create a new report named Resellers Location.

Note: Maps cannot be created using the Report Wizard;

4. Add a Map item to the Resellers Locaion. To do this, drag a Map item () from the Toolbox to the Design surface. This will start the New Map Layer wizard.

5. In the New Map Layer wizard, select SQL Server spatial query and click Next as displayed in Figure

Note: The Sample More >

sql_server_2008_r2

PowerPivot in SQL Server 2008 R2

Apr 9th

Posted by Jibran Jamshad in SQL Server - BI

View Comments

Microsoft SQL Server 2008 R2 delivers many powerful new features. PowerPivot is one of the most significant, arguably Microsoft’s most important Business Intelligence (BI) advance since the advent of Microsoft SQL Server Analysis Services 2005. It seriously delivers on the long-awaited promise of “self-service BI” and “BI for the masses”, by leveraging Microsoft Excel, the world’s most-used analysis platform, Microsoft SharePoint, the rapidly growing collaboration platform, and a new, in-memory version of Analysis Services. PowerPivot enables end users to build high performance analytic applications without having to wait for IT to build cubes and develop the extract transform and load (ETL) More >