Microsoft

SQL Server 2008 R2: Multiserver Management Using Utility Explorer

by Satya Shyam K Jayanty | June 2011 | Cookbooks Enterprise Articles Microsoft

SQL Server 2008 R2 improves the ability to manage multiple servers centrally with Utility Control Point (UCP). In order to manage multiple instances efficiently, there are certain settings available within the Utility Explorer tool. In this recipe by Satya Shyam K Jayanty, author of Microsoft SQL Server 2008 R2 Administration Cookbook, we will focus on how to manage multiple instances using Utility Explorer by setting global policies for data-tier applications (DAC), and managed instances.

Read SQL Server 2008 R2: Multiserver Management Using Utility Explorer in full

Best Practices for Microsoft SQL Server 2008 R2 Administration

by Satya Shyam K Jayanty | June 2011 | Cookbooks Enterprise Articles Microsoft

As a DBA and advanced user of SQL Server 2008 R2, you have to develop best practices that combine a streamline of services for deployment, migration, and management of your data platform. SQL Server 2008 R2 has rich and intuitive GUI management tools, which lower the costs in data management by incorporating automation and delegation of administrative tasks. This article covers the SSMS features that are new and enhanced in SQL Server 2008 R2 to enable operational efficiency in developing the joint best practices and integrated solutions.

In this article by Satya Shyam K Jayanty, author of Microsoft SQL Server 2008 R2 Administration Cookbook, we will cover:

  • Implementing Utility and Non-utility collection sets
  • Designing and refreshing Scalable Share database features and enhancements
  • Managing SQL Server Replication processes
  • Implementing security for SQL Server Agent jobs management
Read Best Practices for Microsoft SQL Server 2008 R2 Administration in full

Microsoft SQL Server 2008 R2: Managing the Core Database Engine

by Satya Shyam K Jayanty | June 2011 | Cookbooks Enterprise Articles Microsoft

The core database engine is the main platform for managing all of the business data for your organization—both archived and current—in a relational database management system. Managing the Core Database Engine, enables the user to produce a resilient data platform, which is possible with new features of SQL Server 2008 R2 such as Utility Control point, multi-server management, and implementing central management feature enhancements.

In this article by Satya Shyam K Jayanty, author of Microsoft SQL Server 2008 R2 Administration Cookbook, we will cover:

  • Implementing Central Management feature enhancements
  • Designing Multi-server management from SQL Server 2008 R2
  • Managing Utility Control Point data warehouse database
Read Microsoft SQL Server 2008 R2: Managing the Core Database Engine in full

Excel 2010 Financials: Using Graphs for Analysis

by Andre Odnoha | June 2011 | Cookbooks Enterprise Articles Microsoft

Using graphs for financial and statistical analysis allows you to analyze and present data in a meaningful and functional way utilizing graphs that even Excel didn't know it could do. In this article by Andre Odnoha, author of Excel 2010 Financials Cookbook, you will learn to not only add reusable methods to automate graph production, but also how to create graphs and graphing sets that are not native to Excel.

In this article, you will learn the following recipes:

  • Charting financial frequency trending with a histogram
  • Creating a stem and leaf plot
  • Creating a Box and Whisker Plot
  • Using a graph overlay for profit and expenses
  • Graphing the principal of a loan automatically
Read Excel 2010 Financials: Using Graphs for Analysis in full

Excel 2010 Financials: Adding Animations to Excel Graphs

by Andre Odnoha | June 2011 | Cookbooks Enterprise Articles Microsoft

Graphs are an important and essential method of demonstrating information visually for analysis and ease of understanding. Graphs in Excel, however, are static visual representations. You can filter the data or adjust the dataset to change the information that is displayed; however, the graph itself is still a static image. Adding animation visualization to a graph will add an element of professionalism to a presentation.

In this recipe by Andre Odnoha, author of Excel 2010 Financials Cookbook, you will learn how to add animation to Excel graphs.

Read Excel 2010 Financials: Adding Animations to Excel Graphs in full

Getting Started with Microsoft SQL Server 2008 R2

by Satya Shyam K Jayanty | June 2011 | Cookbooks Enterprise Articles Microsoft

This article by Satya Shyam K Jayanty, author of Microsoft SQL Server 2008 R2 Administration Cookbook, begins with SQL Server 2008 R2 version's new features and enhancements such as master data services, data-tier applications, and adding the service pack features using Slipstream technology. We will run through the designing best practice approach in upgrading to SQL Server 2008 R2 and take advantage of federated servers enhancements.

In this article, we will cover:

  • Adding SQL Server R2 Service Pack features using Slipstream Technology
  • Designing a best practice approach in upgrading to SQL Server 2008 R2
  • Working with Data-Tier applications
  • Designing and adopting SQL Server 2008 R2 solutions
  • Designing applications to use federated servers
Read Getting Started with Microsoft SQL Server 2008 R2 in full

How to Build a RSS Reader for Windows Phone 7

by Todd Spatafore | June 2011 | Enterprise Articles Microsoft

This article will introduce programming Windows Phone 7 applications. We will use RSS feeds that are provided from lists in SharePoint to display information to the Windows Phone 7 user. Throughout the article, we will build a simple RSS Reader application for Windows Phone 7 and add complexity to it as we go along.

In this article by Todd Spatafore, author of Microsoft SharePoint 2010 Enterprise Applications on Windows Phone 7, we will cover the following:

  • Security in SharePoint 2010
  • Using WebClient to get data from the web
  • RSS feeds available from SharePoint
  • Parsing XML in Windows Phone 7
Read How to Build a RSS Reader for Windows Phone 7 in full

Customizing SharePoint Communities for Windows Phone 7

by Todd Spatafore | June 2011 | Enterprise Articles Microsoft

SharePoint is a powerful enterprise content management system. It has an impressive ability to bend to the needs of just about any use case imaginable in an enterprise. That list of use cases also includes several social aspects. When employees are sharing information across multiple departments, it can make a 90,000 employee enterprise feel like a 100 person small company.

This article focuses on customizing the SharePoint communities for use on Windows Phone 7. We will investigate the web-based output of the communities, and customize this output using Visual Studio 2010. This article by Todd Spatafore, author of Microsoft SharePoint 2010 Enterprise Applications on Windows Phone 7, will cover the following topics:

  • Blogs
  • Wiki
Read Customizing SharePoint Communities for Windows Phone 7 in full

Installing Data Protection Manager 2010

by Steve Buchanan | June 2011 | Enterprise Articles Microsoft

Microsoft Data Protection Manager (DPM) 2010 is a backup and recovery solution which provides continuous data protection for Windows application and file servers to seamlessly integrated disk, tape, and cloud.

The DPM installation as well as the upgrade process is pretty straightforward. The areas where the DPM installation can get tricky are prerequisites, hardware and software requirements, as well as making sure your operating system is properly updated and patched. All of these things need to be met or completed before you can start the DPM installation.

In this article by Steve Buchanan, author of Microsoft Data Protection Manager 2010, we shall cover the following topics:

  • Installing DPM
  • Installing Single Instance Store (SIS)
  • Installing DPM (on a local or remote SQL instance)
  • Migrating from DPM 2007 to DPM 2010
Read Installing Data Protection Manager 2010 in full

Packt Podcasts: Enterprise

by | June 2011 | Enterprise Articles IBM Microsoft Oracle

Packt Enterprise Podcasts

Sit back, relax, and listen to Packt Enterprise Authors discuss their books and specialist technologies

Read Packt Podcasts: Enterprise in full
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software