Webcast: Agile Business Intelligence – Proven Techniques that move BI Development into the Agile World
As more and more organizations embrace agile development methodologies, tools and agile processes are becoming more mainstream and almost transparent to the developer; however, the problem of embracing agile development is still an issue for those working on Business Intelligence projects. This problem is exacerbated by the fact that tools for BI development haven’t quite caught up to the unique problems presented by Business Intelligence development. This session will discuss Agile techniques as they relate to Business Intelligence Projects, with a particular focus on Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Analysis Services (SSAS) development. Attendees will learn how to adapt the Microsoft Solutions Framework (MSF) for Agile process template for Business Intelligence, and will show how to integrate Visual Studio Team System and Team Foundation Server into your agile BI projects. Attendees will leave this session with a good understanding of how agile can apply to the BI world.
Presented by: Ted Malone
> Register Now
> Live date: 10/27/2010 at 12:00 Pacific
Featured Article(s)
Data Access Madness: Choosing the Right Data Strategy for your .NET (Part 3 of 3)
Choosing the right data access technology and strategy for any particular application can be daunting. We have many data access choices to use in our applications and because the best choice is always dependent on each application, we can often feel overwhelmed when selecting a data access technology or crafting a data access strategy. This session will cover an overview of the available data access technologies and how they are used in today’s applications. We’ll also review key differences between ADO.NET Core Libraries, LINQ to SQL, Entity Framework and ADO.NET Data Services and how you can use these differences to your advantage in both existing and new applications.
SQL Server Services
Do you know the Windows NT Services implementing SQL Server 2008 R2?
Depending on the components installed the following services are created. Some of the services are created more than once, depending on how many instances of the feature are installed on the server (or virtual server). I’ll list those separately. Following are the services with names as they appear under the NT services management console.
Instance Specific Services:
- SQL Server Agent ([Instance])
Executes jobs, monitors SQL Server, fires alerts, and enables automation of some administrative tasks. - SQL Server Analysis Services ([Instance])
Provides Online analytical processing (OLAP) and data mining functionality for business intelligence applications. - SQL Server Reporting Services ([Instance])
Manages, executes, creates, schedules, and delivers reports - SQL Server Integration Services (Instance])
Provides management support for Integration Services package storage and execution. - SQL Full-text Filter Daemon Launcher ([Instance])
Quickly creates full-text indexes on content and properties of structured and semistructured data to provide document filtering and word-breaking for SQL Server.
Global Services:
- SQL Server Browser
The name resolution service that provides SQL Server connection information for client computers. - SQL Server Active Directory Helper
Publishes and manages SQL Server services in Active Directory. - SQL VSS Writer
Allows backup and restore applications to operate in the Volume Shadow Copy Service (VSS) framework.
The configuration of these services (primarily the windows NT account authorizing their execution) determines how they interact with each other and with resources outside the SQL Server Suite, or other instances of SQL Server.
One of the common questions for configuring SQL Server is what account should be used to support the SQL Server services; should it be a local system account, a local user account, or an Active Directory account? What privileges should the service accounts be granted?. Read more about the details of the SQL Server 2008 services at msdn.microsoft.com/en-us/library/ms143504.aspx.
Why not share your experience with our readers? Send you comments and/or standards/practices here and I’ll post them in our newsletter for the rest of our readers.
Cheers,
Ben