I hardly ever use my blog to publish unrelated subjects to programming. This is one of them.
Our company Faraconesh Corporation is bound to hire new talented and professional .NET developers. If you like working with me in person in a small-growing company which offer good salary, insurance, flexitime working beside experts which are pioneers in Iran in their skills and you meet the following needs
Faraconesh Corporation appreciates in advance your kind request to join and will arrange a meeting with you in next few days.
This is the Persian text for this advertisement.
من به ندرت در این وبلاگ مطالب غیرمرتبط با برنامه نویسی مینویسم. این مطلب یکی از آنهاست.شرکت ما، فراکنش قصد استخدام چند برنامهنویس بااستعداد و حرفهای دات نت را دارد. اگر شما دوست دارید که با من از نزدیک در یک شرکت کوچک رو به رشد که حقوق کافی، بیمه، زمان کار آزاد و کار شانه به شانه با متخصصینی که در زمینه کاری خودشان از پیشروان هستند همکاری کنید و نیز درصورتی که شرایط زیر را دارید
حداقل سه سال سابقه کار مرتبط
درک و تسلط کافی و عمیق از .NET, C#, SQL Server و NHibernate
همچنین توانایی کار گروهی و استفاده از ابزارهای کار تیمی مانند ایشوترکر ها و سورس کنترها
توانایی کار با WPF, WCF, WF و REST مزیت به شمار میآید
Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. These packages may be used to upgrade any edition of SQL Server 2008. Service Pack 2 contains updates for
SQL Server Utility,
Data-Tier Application (DAC),
as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies.
Service Pack 2 introduces support for a maximum of 15,000
artitions in a database,
and includes SQL Server 2008 SP1 Cumulative Update 1 to 8.
While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs.
Note: Microsoft SQL Server 2008 Service Pack 1 is not a prerequisite for installing SQL Server 2008 Service Pack 2.
You Can check the Release Notes here.
New Features of SQL Server 2008 SP2
15K partitioning Improvement. Introduced support for a maximum of 15,000 partitions in tables and indexes in Microsoft SQL Server 2008 Service Pack 2 in the Enterprise, Developer and Evaluation Editions. For details on how this support can be enabled and disabled, along with recommended operation paramaters, see the white paper Support for 15000 Partitions.
Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services integration with SharePoint products. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in to support the integration of SQL Server 2008 R2 report servers with SharePoint 2007 products. For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What’s New (Reporting Services).
SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.
• SQL Server 2008 Instance Management.With SP2 applied, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server. For more information, see Overview of SQL Server Utility in SQL Server 2008 R2 Books Online. • Data-tier Application (DAC) Support. Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.
As you all know nowadays reporting is one of the important sections of each application, specially official and financial ones. So that there are lots of reporting services which provide some feature for developers to create custom reports. Most of you are aware of some reporting services in each programming language like Crystal Report, Jasper Report and etc. most of these reports create xml document from your custom reports and show it to users with a report viewer which compile the xml and show the result.
In order to creating powerful and robust reports, since 2005 SQL Server provides a Reporting Service which formerly named SSRS or SQL Server Reporting Services. So to use SSRS you have to buy a Developer or Enterprise edition. After installation you’ll have a ‘SQL Server Business Intelligence Development Studio’ which allows you create Server-side reports.
SSRS 2005 used schema 2005 and SSRS 2008 using schema 2008 for creating server-side reports. I wrote many posts about SSRS before so if you are a fan of this blog, you’re aware of these schemas and differences. Visual Studio has a built-in reporting system which allows you to create client-reports (RDLC) and it use schema 2005 to do its job.
When we use SSRS instead of VS Reports
Client reports which provided by VS are suitable for available data. For example you have a list of users or asset and you want to get a report from it.
Server reports which provided by SQL Server, use for reports which need calculation and in some cases take some minutes to generate, cause data have to generate based on some parameters.
SSRS (schema) 2005 has lots of issues with RTL and Unicode but SSRS 2008 resolve most of them and there are only a few problems that can be neglected.
Upgrading reports from schema 2005 to schema 2008 is a real nightmare that I wrote about it and its solution, but you have to know that it’s not an easy job.
How to create a server side report in SSRS 2008
Open Visual Studio
Create a new project and choose Business Intelligent Projects from the left pane and then select Report Server Project
Give a Name to your project
Your server-side project is ready, now you have toad a new server reports to it to do this
Add a new Item and select Report (note to format of the report, it is RDL)
Now you have an empty report and you can design it with Toolbox items and bind it to your database with Store procedure or via a simple query