Building Financial Functions into Excel 2010
by
Andre Odnoha | July 2011 | Cookbooks Microsoft
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
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 fullBest 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
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
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
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 fullGetting 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
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
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
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
