SqlServer-QA.net

If you remember about editions of SQL Server from 2000 onwards you will see Enterprise, Standard, Personal & Desktop Edition (MSDE) and when it comes to 2005 version Enterprise, Standard, Workgroup, Express & Express Advanced Services. So what's new with SQL Server 2008 version, in addition to 5 editions the newest one is Web ...

Until SQL Server 2000 the sample databases or files are installed along with binaries & program files, since version 2005 this has been changed and they are available from Microsoft download site and SQL Server Reporting Services (SSRS) has no exclusion.   No doubt that Reporting Services API is a comprehensive, server-based ...

SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know how to perform routine maintenance tasks for server components, and how to manage the content and ...

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their own Windows domain credentials and integrated security. TO change this criteria you can also ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting ...

During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend to read through BOL if you need a basic information you can further see ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server 2005 Reporting Services reporthttp://support.microsoft.com/kb/951194/en-US When you use ...

Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse platform you can set, with the  features and functionality you need to ...

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped by measure group. Simplified and enhanced Aggregation Design and Usage-Based ...

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always havea primary focus in providing protection for the data assets stored in SQL Server. Protection that covers the security and data recoverability is also equally important, during this process ...