Answer / selvaraj.v

Sql Reporting Services :
-----------------------

Full Reporting Life Cycle Support
SQL Server Reporting Services supports the full reporting
life cycle, including:

• Report authoring. Report developers can create reports to
be published to a report server by using Microsoft or other
design tools that use Report Definition Language (RDL), an
XML-based industry standard used to define reports.

• Report management. Report definitions, folders, and
resources are published and managed as a Web service.
Managed reports can be executed either on demand or on a
specified schedule, and are cached for consistency and
performance. New in SQL Server 2005 Reporting Services,
administrators can use SQL Server Management Studio to
organize reports and data sources, schedule report
execution and delivery, and track reporting history.

• Report delivery. SQL Server Reporting Services supports
both on-demand (pull) and event-based (push) delivery of
reports. Users can view reports in a Web-based format or in
e-mail.

• Report security. SQL Server Reporting Services implements
a flexible, role-based security model to protect reports
and reporting resources. The product includes extensible
interfaces for integrating other security models as well.

Analysis Services :
------------------

SQL Server 2005 Analysis Services (SSAS) provides, for the
first time, a unified and integrated view of all your
business data as the foundation for all of your traditional
reporting, online analytical processing (OLAP) analysis,
Key Performance Indicator (KPI) scorecards, and data mining.

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

Tell me what do we need queues in sql service broker?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---

What is difference between createstatement and preparedstatement?

0 Answers  

---

Tell me in brief how sql server enhances scalability of the database system?

0 Answers  

---

difference between truncate, delete aur drop?

2 Answers  

---

What is normalization?

9 Answers  

---

What is an index. What are the types?

0 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

What are the main sources of data?

0 Answers  

---