Exchange Server 2010 Windows PowerShell: Mailboxes and Reports
PowerShell is now an integral part of Exchange Server management and you need to learn the basics and have a point of reference for building your own scripts. If you're completely new to PowerShell, the concept may be familiar if you've worked with UNIX command shells. In this article, the mailbox management tasks like moving mailboxes and generating some basic reports are dealt with.
In this article by Mike Pfeiffer, author of Microsoft Exchange Server 2010 Windows PowerShell Cookbook, we will cover:
- Reporting on the mailbox size
- Working with move requests and performing mailbox moves
- Generating mailbox folder reports
- Reporting on mailbox creation time
Microsoft SQL Server 2008 R2 MDS: Creating and Using Models
This article by Jeremy Kashel, Tim Kent and Martyn Bullerwell, authors of Microsoft SQL Server 2008 R2 Master Data Services, introduces the reader to the concept of creating a Model within the Master Data Manager front-end, which will be the beginning of an example solution that will run for the rest of the article. Each of the different objects within the MDS object hierarchy will be covered, guiding the reader on how to build a model up step-by-step.
A sample script will be provided that will populate the user's newly created model, and the user will then be guided through the process of editing and creating members using the front-end.
In this article, we will cover the following topics:
- MDS object model overview
- Models
- Entities and attributes
- Members
- Attribute Groups
Microsoft SQL Server 2008 R2: Hierarchies, Collections, and MDS Metadata
In the previous article on Creating and Using Models, some of the different objects within the MDS object hierarchy was covered. This article will detail more MDS objects, guiding the reader on how to build a model up step-by-step. A sample script is provided to populate the user's newly created model, and the user is guided through the process of editing and creating members using the front-end.
In this article by Jeremy Kashel, Tim Kent and Martyn Bullerwell, authors of Microsoft SQL Server 2008 R2 Master Data Services, we will cover the following topics:
- Hierarchies
- Collections
- Master Data Services Metadata
Communicating from Dynamics CRM to BizTalk Server
One can imagine many scenarios where Dynamics CRM either publishes data to BizTalk Server or queries BizTalk-exposed service endpoints. For instance, when a customer requests a refund for a defective product, the call center agent may record this request in Dynamics CRM. After the phone call is over, Dynamics CRM should send a message to a returns processing system which handles the crediting of a customer's account. In another scenario, BizTalk Server may be the host of a data aggregation service which queries three enterprise systems that store "customer" data and aggregates the responses. Dynamics CRM may want to execute that service when a call center agent views a customer record so that they get a fuller picture of that customer's interactions with the company.
In this article by Richard Seroter, author of Microsoft BizTalk 2010: Line of Business Systems Integration, we will see how Dynamics CRM sends data to BizTalk Server.
Read Communicating from Dynamics CRM to BizTalk Server in fullIntegrating BizTalk Server and Microsoft Dynamics CRM
Microsoft Dynamics CRM 2011 is the latest and greatest relationship management software from Microsoft. This release of the product introduced a wide range of improvements to the user interface, a new WCF programming model, role-based forms, data analysis dashboards, tight integration with SharePoint 2010, Windows Azure integration, and much more. Dynamics CRM 2011 should be considered by anyone evaluating small or large CRM projects. But how do we make Dynamics CRM an integrated part of our enterprise landscape? This article focuses on that question.
In this article by Richard Seroter, author of Microsoft BizTalk 2010: Line of Business Systems Integration, we will cover:
- What is Microsoft Dynamics CRM and what problems does it solve?
- Why you should integrate Dynamics CRM with BizTalk Server
- How BizTalk Server makes requests to Dynamics CRM
Microsoft SQL Server 2008 R2 Master Data Services Overview
This article by Jeremy Kashel, Tim Kent and Martyn Bullerwell, authors of Microsoft SQL Server 2008 R2 Master Data Services, provides an overview of SQL Server 2008 R2 Master Data Services (MDS), outlining the main features of the product as well as covering the architecture. In addition to covering the architecture, the purpose of this article is to get the reader comfortable with navigating around the main MDS interface, namely Master Data Manager.
In this article, we will cover the following:
- Master Data Services overview
- Master Data Services architecture
- Master Data Manager
Excel 2010 Financials: Identifying the Profitability of an Investment
Building financial function into Excel, as shown in the previous article, will augment the Excel toolset with user defined functions broadening the abilities of Excel. In this article wee will focus on depreciation, and the value of a dollar.
In this article by Andre Odnoha, author of Excel 2010 Financials Cookbook, we will learn:
- Calculating the depreciation of assets
- Calculating the future versus current value of your money
- Identifying the profitability of an investment
- Calculating and planning for inventory requirements
Building Financial Functions into Excel 2010
Building financial function in to Excel will augment the Excel toolset with user defined functions broadening the abilities of Excel. This article by Andre Odnoha, author of Excel 2010 Financials Cookbook, will focus on real-world scenarios and the use of Excel functions to make sound business decisions. In essence, the following recipes will assist you as a financial manager to track and follow your monetary decisions closely.
In this article, we will learn:
- Determining standard deviation for assessing risk
- Analyzing benefits between interest and payment investments
- Calculating the number of payments in a loan
- Identifying the difference between effective and nominal interest rates
SQL Server 2008 R2: Multiserver Management Using Utility Explorer
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 fullBest Practices for Microsoft SQL Server 2008 R2 Administration
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


