Tuesday, May 24, 2011

Top SharePoint, SQL Server, MDM White Papers, and Product Information on the topics you are interested in.

SHAREPOINT 2010

Encouraging SharePoint Collaboration
by AvePoint, Inc.
This paper discusses how Microsoft SharePoint is the platform of choice for organizations to store enterprise-wide content. New features in SharePoint Server 2010 take the platform to the next level by improving the platform’s scalability and usability to further enhance collaboration among knowledge workers.
Increasing SharePoint Adoption: Delivering Unfettered Scalability and Reliability
by AvePoint, Inc.
This paper examines how new features in Microsoft SharePoint Server 2010 vastly improve the platform’s scalability and usability, encouraging organizations to evolve their use of SharePoint.


BUSINESS INTELLIGENCE & SQL SERVER 2008/2008 R2

Microsoft SQL Server 2008 R2: What's New with PowerPivot?
by Global Knowledge
One of the most eagerly awaited features of Microsoft SQL Server 2008 R2 is the “Self Service Business Intelligence” technology known as PowerPivot. This white paper highlights the new PowerPivot features.
Embedding BI into Your Software Solution - Best Practices
by Birst
This paper offers practical advice on how to plan for, build, and market an analytics product. If you execute product development and rollout well, you can grow your business, build customer satisfaction, and improve the “stickiness” of your product. But like any great opportunity, success requires careful planning and attention to detail


NA: Situational BI: For Agile and Self-Service Analytics
by Tableau Software
Increasing competition and the need to react rapidly to today's fast changing business climate is leading BI to play an ever increasing and important role in driving and optimizing daily decision making. But being able to quickly and easily ask and answer questions of your data in a dynamic and constantly changing environment is not a simple task.
Improving Data Quality Through Data Modeling
by CA ERwin from CA Technologies
Enterprise data is largely falling short of a standard that makes it possible to utilize in how business will be conducted in the next decade. Most enterprise data is “adequate” for basic operational needs today. Download this paper to learn how to get the most out of your enterprise data.

SQL Server 2008 Upgrade Series: Performance
by Dell, Inc. and Intel
This article explores ways in which small and mid-sized businesses can improve the performance of their databases — and their businesses — by upgrading to SQL Server 2008.
Presentation Transcript: Reducing Cost in the Data Center with Windows Server 2008 R2
by Dell, Inc. and Intel
Managing power consumption in the data center is a huge concern for IT organizations today. In this presentation transcript, learn about the cost benefits of using Windows Server 2008 R2 for power and energy savings in the data center. The speaker will discuss the trends in this area and offer steps to improve power consumption and costs.


Siemens PLM Software Validated to Easily Support 5,000 Users with SQL Server 2008
by Intel
Read this case study to find out the results of the tests Siemens engineers conducted with deploying its software on SQL Server 2008 running on Quad-Core Intel Xeon 7300 processors. In addition, learn about the benefits identified in the tests including response rate, high concurrency for scalability, CPU and RAM savings and more.
Reduce Your Server Footprint with SQL Server 2008 -- Rely on SQL Server 2008 to Consolidate Database Servers
by Dell, Inc. and Intel
With its new unified management and auditing tools, SQL Server 2008 makes it easier to manage multiple instances on fewer servers. And by hosting these instances on Dell PowerEdge Servers powered by multi-core processors, you can guarantee the best levels of availability, as well as ensure the best possible performance
Reducing Costs in the Data Center with Windows Server 2008 R2, Through Extended Hardware Life  
by Dell, Inc. and Intel
Most IT organizations are still looking for ways to cut costs in this economy. One way is to extend hardware life in the data center.  In this videocast, learn why this strategy is especially valuable to SMBs.

SQL Server 2008 Upgrade Series: Availability & Disaster Recovery
by Dell, Inc. and Intel
With Microsoft SQL Server 2008, small and mid-sized businesses have a variety of options for creating state-ofthe art strategies for ensuring high availability and disaster recovery for their databases. This article explains why upgrading to SQL Server 2008 may help IT sleep better at night.
Consolidate SQL Server 2008 on Dell 4 Socket - Multi-Core Servers - Using Hyper-V
by Dell Inc., Microsoft and AMD
This Guide is a companion to How to Guide: Consolidating multiple SQL Server systems onto Dell PowerEdge Servers using Microsoft’s Hyper-V. In this Guide, we use the Dell PowerEdge R900 and PowerEdge R905 as target servers.


MASTER DATA SERVICE & MASTER DATA MANAGEMENT

Getting Started with Master Data Services
by Global Knowledge
This white paper highlights the new Master Data Services feature. This enhancement allows an organization to create a Master Data Hub that provides a “single source of truth” for the enterprise’s numerous data entities and hierarchies.
An Introduction to Analytical MDM: master data management for BI data
by DataFlux Corporation
In this eBook, IT, BI and data management professionals will get an overview of analytical MDM and learn how to develop and manage a successful program for mastering their BI data. Get insight and advice on analytical MDM’s potential benefits, challenges to watch out for and combining it with operational MDM for a full enterprise approach.


Practical Fundamentals for Master Data Management
by DataFlux Corporation
In this paper we look at the levels of maturity and capability necessary for deploying enterprise wide initiatives, such as comprehensive MDM, and ponder why these initiatives stall. Read on to learn more.

Tips for a Master Data Management (MDM) Requirements Gathering Process
by DataFlux Corporation
The requirements gathering process is a critical first step in MDM initiatives aimed at ensuring that data is consistent across different systems. But making sure to get all the business and technical information needed isn’t easy. This podcast provides expert tips and best-practices that help put MDM projects on the path to success from the start.
Master Data Management Projects in Practice - An Information Difference Research Study
by Talend
Organizations are often turning to Master Data Management as a key enabler in improving the timeliness, quality and reliability of BI with the ultimate goal of improving business performance. This survey report presents recommendations on the "do and don't" of MDM as well as some findings on the use of open source and manual coding in MDM projects

Master Reference Data: Extract Value from your Most Common Data
by Talend
Reference data is the lifeblood of an organization but inconsistencies can lead to inefficient processes and inaccurate analytics. Master reference data makes operational data more accurate, simplifies synchronization and migration projects and improves MDM effectiveness. Learn some key considerations for creating a reference data master.

Lesson 4: Developing a plan for addressing failure points in mission critical scenarios
by Intel and Microsoft
It’s important to identify failure points that can lead to downtime in mission critical scenarios. This lesson focuses on how to use SQL server to anticipate, prevent and solve issues with failure points that disrupt mission critical applications and services

Lesson 5: Securing a data platform to deliver optimal support for mission critical apps and services
by Intel and Microsoft
In this final lesson, learn about the best methods to access and test the security of your SQL Server data platform.
E-Guide – Ezine – EBook - Resources

SQL Server Insider E-zine - Volume 4: Master Data Services: A Work in Progress
by Dell Inc., Microsoft and AMD
This issue’s cover story explains what the SQL Server 2008 R2’s Master Data Services (MDS) feature can—and cannot— do. Also learn how to get the full value out of the SQL Server 2008 BI stack, and how to boost SQL Server performance with data collection and analysis.

E-Guide: Developing a Strategy for and Implementing Real-time BI and Analytics
by Tableau Software
Many organizations are realizing the interesting and paradoxical pattern that exists with BI applications: the more you use them, the more new and different requirements keep pouring in. Read this E-Guide and learn to gain a stronger understanding of your customers and business as well as to excel in today’s competitive market with real-time BI.

E-Guide: 7 Things You Need to Know about SQL Server 2008 R2
by Dell Inc., Microsoft and AMD
This expert e-guide from SearchSQLServer.com explains the top seven things you should know about SQL Server 2008 R2, including updates like increased SQL Server Express database size and new data source types.
eGuide: Mid-Market Guide to Architecting SQL Server for High Performance and 100% Uptime on a budget
by Dell Inc., Microsoft and AMD
Read this expert E-Guide from Dell to learn key concepts that will help you architect your next SQL Server installation.

E-book: Windows Servers and Storage - Choosing Your Server
by Dell and Microsoft
This eBook provides comprehensive information about servers and server implementation to help IT managers choose the best option for their storage needs.


SQL Server Insider E-Zine – Volume 1: Is Self-service BI the Answer?
by SearchSQLServer.com
Business intelligence is a hot topic in 2010, especially with the upcoming release of Microsoft's SQL Server 2008 R2 being dubbed as the "BI release." In this e-zine, one SQL Server expert breaks down exactly what goes into self-service BI, where it works and where it falls short.

Advancing the Data Agenda: Roles and Responsibilities in the Data Quality Trenches
by DataFlux Corporation
It is high-minded to observe that any data program requires a full partnership between business and IT. The real world is more mundane and far more demanding than that. Indeed, success with any data program depends on getting the right groups involved and assigning the right people the right roles and responsibilities. Read on to learn more

Three Fundamental Techniques To Maximize the Value of Your Enterprise Data
by Talend
This paper explores the details of three key methods used to improve and extend enterprise data utilization and examines technical considerations that suggest implementation techniques to address data reuse needs. Read this paper to learn the three basic capabilities that help organizations maximize data utilization to the fullest.
CA ERwin Data Modeler r8
by CA ERwin from CA Technologies
CA ERwin Data Modeler r8 is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment.  It provides state of the art visualization capabilities, coupled with a dynamic new user interface. Download this demo software to give it a try!


Migrate from Oracle or Sybase to DB2 in Weeks!
by IBM
See how much easier it can be to migrate to DB2, based on new features of the DB2 product.  Plus, leverage an e-kit that contains all the material you need to quickly learn about IBM DB2. Article is part of a full e-kit designed for fast, easy DB2 learning.
Whitepaper: Dell Storage Selection Guidelines for Oracle Databases
by Dell, Inc.
Dell strives to simplify IT in order to reduce complexity in data centers and has a broad storage product portfolio to meet database customers’ needs. These storage selection guidelines will help administrators choose an appropriate storage technology based on their requirements.


FEATURED SHAREPOINT 2010 Books:

SharePoint 2010 For Dummies
by Vanessa Williams
Professional SharePoint 2010 Administration
by Todd Klindt

Microsoft SharePoint 2010: Building Solutions for SharePoint 2010 (Books for Professionals by Professionals) by Sahil Malik

Inside Microsoft® SharePoint® 2010
by Ted Pattison

SharePoint 2010 Development with Visual Studio 2010 (Microsoft .NET Development Series)
by Eric Carter

Professional SharePoint 2010 Development (Wrox Programmer to Programmer)
by Reza Alirezaei


InfoPath with SharePoint 2010 How-To by Steve Mann
Business Intelligence in Microsoft® SharePoint® 2010
by Stacia Misner
Microsoft SharePoint 2010 Business Intelligence Unleashed
by Steven Mann
Microsoft SharePoint 2010: Building Solutions for SharePoint 2010 (Books for Professionals by Professionals) by Sahil Malik
Professional Microsoft PowerPivot for Excel and SharePoint (Wrox Programmer to Programmer)
by Wrox Puslishing
Professional SharePoint 2010 Administration
by Todd Klintd
MCTS Self-Paced Training Kit (Exam 70-667): Configuring Microsoft® SharePoint® 2010 (Training Kits) by Dan Holme

Microsoft SQL Server 2008 R2 BOOKS
:  (CLICK TO REVIEW BOOK DESCRIPTION)


The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset
by Joy Mundy

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010
by Philo Janus

Microsoft® SQL Server 2008 R2 Analytics & Data Visualization
by Doug Harts
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010
by Philo Janus & Stacia Misner

Microsoft SQL Server 2008 R2 Unleashed
by Ross Mistry
Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft))
by Mike Hotek

Foundations of SQL Server 2008 R2 Business Intelligence
by Guy Fouche'
Microsoft SQL Server 2008 R2 Master Data Services
by Tyler Graham

Knight's Microsoft Business Intelligence 24-Hour Trainer
by Brian Knight

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (Pro-Certification)
by Mike Hotek

Monday, May 23, 2011

SharePoint Environment Assessment Questionnaire

The questionnaire is designed to assess the existing SharePoint environment for Support transition and to collect key Information to propose the right support model for the transition
1.    Business
  • What is the primary business objective of the SharePoint environment? (What needs of your business are met by the existing system – Communication, Collaboration, Knowledge Management, Enterprise Content Management, Document Management, Dashboards, Complete Intranet Solution, Extranet for suppliers, customers etc.?)
  • Please share the status of all ongoing and planned activities for SharePoint (Development, migration and upgrade)?
  • Please enlist the sites that are most critical to business? 
2.    SharePoint
  • What is the level of custom development on current SharePoint environment? Please provide documentation.
  • Is there any custom development done by any other 3rd Party vendor? Do you have the source code, business requirements, design document, installation guidelines, and test cases for the changes?
  • Please provide us with the following statistics
1.       Total users for each SharePoint Site on Production (Top level)
2.       Number of Top level sites
3.       What is the size of Content DB?
4.       What is the peak site usage in last one month?
  • Please share the Backup and Recovery Process?
3.    Infrastructure
  • Please provide details or preferably Physical and Logical Architecture Diagrams for Production, Staging and Development Environment
(Farm Topology, deployment diagrams, Virtual environment, SharePoint version details, Directory Services)
  • Please enlist all Integration points (Interfaces) with LOB and other applications/ Software (Ex: imaging solution)
  • Please give a brief about all Web Applications and SSPs in scope.
  • Please provide the list of all 3rd party software (BPM, Search, Analytics, and BI – integrated to SharePoint) installed?
  • Is any sort of load balancing done for the intranet?
  • Is there any mirroring done on SharePoint DBs?
4.    Portals
  • Please share the brief about the most critical sites (in scope) on existing environment?
  • Please share the Site map.
5.           Content management
  • Please enlist the main kind of content (Text content, Documents, Images, flash, Audios, Videos, other formats)
  • Is there any other Content Management or Document management tool in place along with SharePoint?
6.    Security
  • Are there any secured sites? (Using SSL, encryption)
  • What is the current Authentication mechanism? (Windows Authentication, Forms based Authentication or Kerberos, AD, LDAP )
7.    Team
  • Who is supporting the existing environment? Please provide existing SLA and priorities for incident management.
  • Please give a brief about team structure for Support (OS, Hardware, SQL server, Security, Exchange server, SharePoint)
  • Do you have a distributed development team across multiple locations/geographies? Please provide details.
  • Do you have a distributed team of site owners?
8.    Support
  • What is the Support Type (L1, L2 or L3) expected? 
  • Please provide the call flow process. Find below a sample process flow.
SharePoint Environment Diagram
Determine your SharePoint Server Farm which woupld support your SharePoint structure
and Data flow within your organization.

 







 






















Call Flow Process / Diagram










Call flow
 

Incident Management

  • Do you have any system in place for Incident Management that is expected to use? If yes, please give details.
  • Please explain the Incident classification criteria. Find below the sample classification

  • What is the mode of communication for Support (Email only, Incident management, Phone, Pager)?
  • What is the scope of proposed SLA? Please select one of the following.
1.       Large enhancement including custom development (20 person days or more)
2.       small enhancement in existing code ( Less than 20 person days)
3.       Trouble shooting existing development
4.       Admin support
  • Please share the SLAs/ OLAs with existing vendors for 3rd party software, Infrastructure, Exchange Server, Security, SQL Server, OS and hardware.
  • It is assumed that content and configuration DB of all SharePoint sites are in scope for support. Please confirm?
  • Please confirm if following is out of scope for SharePoint Support
1.       OS level support like Server Performance Management, Memory Management, Disk Space and SQL Server Uptime.
2.       Installation, Implementation, Deployment of any Software
3.       Design, Development, Implementation or any issue on Development and Test servers.
4.       Evaluation of any Software, Tool and Processes and Results
5.       Design, Development and Implementation of Proof of Concepts
6.       Development and Enhancements of 3rd Party Products
7.       Environment Management / Infrastructure Support
8.       Platform Troubleshooting
9.       Application Migration & Upgrades
10.    Optimizing search for website or any other design changes to website

Recommended SHAREPOINT 2010 Books:  (CLICK on the book title to review)

Inside Microsoft® SharePoint® 2010 by Ted Pattison

SharePoint 2010 Development with Visual Studio 2010 (Microsoft .NET Development Series) 
by Eric Carter


Professional SharePoint 2010 Development (Wrox Programmer to Programmer)
by Reza Alirezaei

InfoPath with SharePoint 2010 How-To by Steve Mann

Business Intelligence in Microsoft® SharePoint® 2010 by Stacia Misner

Microsoft SharePoint 2010 Business Intelligence Unleashed 
by Steven Mann


Microsoft SharePoint 2010: Building Solutions for SharePoint 2010 (Books for Professionals by Professionals) by Sahil Malik

Professional Microsoft PowerPivot for Excel and SharePoint (Wrox Programmer to Programmer)
Professional SharePoint 2010 Administration by Todd Klintd

MCTS Self-Paced Training Kit (Exam 70-667): Configuring Microsoft® SharePoint® 2010 (Training Kits) by Dan Holme

Microsoft® SharePoint® 2010 Administrator's Companion
by Bill English


Microsoft SharePoint 2010 Business Intelligence Unleashed
by Steven Mann


Professional Microsoft PowerPivot for Excel and SharePoint (Wrox Programmer to Programmer)

by Sivamumar Harinath


Real World SharePoint 2010: Indispensable Experiences from 22 MVPs (Wrox
Programmer to Programmer)

by Randy Disgrill


Beginning SharePoint 2010 Development (Wrox Beginning Guides)
by Steven Fox


Microsoft SharePoint 2010 Unleashed
by Michael Noel



Microsoft SQL Server 2008 R2 BOOKS: (CLICK on the book title to review)


The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset by Joy Mundy


Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 
by Philo Janus


Microsoft® SQL Server 2008 R2 Analytics & Data Visualization
by Doug Harts

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010
by Philo Janus & Stacia Misner

Inside Microsoft Windows SharePoint Services 3.0 (Pro Developer)

Microsoft SQL Server 2008 R2 Unleashed by Ross Mistry

Microsoft® SQL Server® 2008 Step by Step (Step by Step (Microsoft))
by Mike Hotek

Microsoft SQL Server 2008 R2 Master Data Services
by Tyler Graham

Microsoft Business Intelligence 24-Hour Trainer
by Brian Knight

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance (Pro-Certification) by Mike Hotek


Pro SharePoint 2010 Business Intelligence Solutions
by Srini Sisla


The MicrosoftData Warehouse Toolkit: With SQL Server2005 and the
MicrosoftBusiness Intelligence Toolset
by Joy Mundy


Foundations of SQL Server 2008 R2 Business Intelligence 
by Guy Fouche'



SharePoint 2010 For Dummies by Vanessa Williams


Professional SharePoint 2010 Administration
 
by Todd Klindt
Microsoft SharePoint 2010: Building Solutions for SharePoint 2010 (Books for Professionals by Professionals) by Sahil Malik