Microsoft SQL Server Integration Services 2008 (SSIS) is a full service Extract, Transform, and Load (ETL) program tightly integrated with SQL Server 2008 with a Rapid Application Development (RAD) user interface. Microsoft SQL Server Reporting Services 2008(SSRS) is a third generation reporting program that is also tightly integrated with SQL Server 2008, which hosts the Report Server providing full support with a web service frontend for a variety of reporting needs—from web-based reporting to embedded reporting.
In this article by Jayaram Krishnaswamy, author of Microsoft SQL Azure Enterprise Application Development, we will be leveraging SSIS, SSRS, and the tools used to address ETL processes, and Report authoring with SQL Azure as the source of data. We will be looking at the following data-related items in some detail:
- Moving a MySQL database to SQL Azure database
- Creating a report using SQL Azure as data source
- Accessing SQL Azure from Report Builder 3.0
In the previous article, Microsoft Enterprise Library: Security Application Block, we saw an overview of the Security Application block in Microsoft Enterprise Library.
In this article by Sachin Joshi, author of Microsoft Enterprise Library 5.0, you will:
- Be introduced to Authorization Providers such as Authorization Rule Provider and AzMan Authorization Provider
- Be introduced to the Security Cache Provider
- Learn to save user Identity in cache and obtain a temporary token for an Authenticated User
- Learn to retrieve a token from cache and authenticate user
- Learn to terminate a User session by expiring cached identity
- Learn to implement a custom authorization provider
Security is of prime importance for any application, especially enterprise applications where the business impact is potentially high. At the very core, security is a two step mechanism.
In this article by Sachin Joshi, author of Microsoft Enterprise Library 5.0, you will be introduced to the Security Application Block.Read Microsoft Enterprise Library: Security Application Block in full
This article explains the details of creating and using ordered and generic tests. Visual Studio 2010 provides a feature called Ordered Test to group all or some of these tests and then execute the tests in the same order. The main advantage of creating the ordered test is to execute multiple tests in an order based on the dependencies. For example, Web Performance Tests might depend on the results produced by executing the unit tests. So we need to run these tests in an order so that the Unit Test can be executed before starting the Web Performance Tests.
Let us create sample tests in this article and see the usage of both Generic and Ordered Tests. This article by Satheesh Kumar N and Subashni S, authors of Software Testing using Visual Studio Team System 2010, covers on the following topics:
- Creating, executing, and learning properties of an Ordered test
- Creating, executing, and learning properties of an Generic test
Technically, web services are part of the web role, but their use and development are so distinctly different than web forms that we'll look at these separately. The web services themselves can be written in any language supported by Azure, but utilizing the Windows Communication Foundation (WCF) libraries in .NET greatly simplifies the development of web services. The simple storage services have their own REST API and client library developed, but if we want to add data into SQL Azure, we'll have to create our own web services.
In this article by Richard J. Dudley and Nathan A. Duchene, authors of Microsoft Azure: Enterprise Application Development, we'll:
- Gain an overview of WCF services
- Build the WCF service for the Jupiter Motors portal
Get a quick overview of the latest RAW books from Packt Enterprise.
Packt's RAW books are a true example of 21st century publishing - they allow you to download the eBook before it's published, and then read as it's written, with your eBook instantly updating as new chapters are completed.
What's more you also receive a 40% discount when purchasing RAW eBooks and the RAW pre-order bundle.
In this article by Victoria Yudin, author of Microsoft Dynamics GP 2010 Implementation, we will go through the implementation planning phase and focus on the following topics:
- How many companies to set up in Dynamics GP
- Integration with other systems
- General Ledger account framework and account format
- Numbering schemes for master records
- Fiscal year and period setup
During 2010 Packt Publishing has really excelled in terms of its Dynamics books, cementing our reputation as a leading Dynamics publisher.
Packt's current collection of Dynamics titles is wide ranging, both in terms of technology and audience - receiving an unprecedented number of positive reviews.
In 2011 Packt hope to continue this success, with a further focus on branching into the area of CRM. To receive notifications for when these and other Dynamics books are published, simply sign-up to the Packt Enterprise Newsletter via your Packt Publishing Account.