SQL Server 2008 : Intégration de Reporting Services 2008 dans WSS V3 SP1 Dans la foulée des différents articles sur Windows Server 2008 et SQL Server 2008, le nouvel article sur l'installation de Reporting Services 2008 en mode intégré à SharePoint vient d'être publié. Vous le trouverez sur le site Technos-Sources : · Intégration de Reporting Services 2008 CTP Novembre dans WSS V3 SP1 Vivement les versions finales de ces nouveaux produits. Romelard Fabrice [MVP] Technorati Tags: SharePoint,SQL Server,Reporti... lire la suite
Dans la foulee des differents articles sur Windows Server 2008 et SQL Server 2008, le nouvel article sur l'installation de Reporting Services 2008 en mode integre a SharePoint vient d'etre publie. · Integration de Reporting Services 2008 CTP Novembre dans WSS V3 SP1 Technorati Tags: SharePoint,SQL Server,Reporting Services,2008
Voila une nouvelle qui devrait ravir tous les administrateurs systeme retissant a l'installation et l'utilisation de SQL Server Reporting Services dans leur infrastructure. En effet, comme pour les procedures stockees de SQL Server 2005, le moteur de rapport de SQL Server 2008 utilise directement HTTP.SYS. On ne doit plus installer IIS sur le serveur SQL, ce qui simplifie considerablement certaines installations et parametrages. · SQL Server 2008 Reporting Services no longer depends on IIS Technorati Tags: SQL Server,Reporting Services,IIS
The Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.
Les recomiendo inscribirse en el evento virtual de SQL Server 2008 del 24 de Enero, Incluira varios temas importantes de BI como : Reporting Services con SQL Server 2008 , Integracion con MOSS y como desarrollar Data Cleansing con Integration Services, Inscribanse en el siguiente link : http://events.unisfair.com/index.jsp?eid=157&seid=291&code=solidqsig es gratuito ...
SQL Server 2008 has been released to manufacturing. SQL Server 2008 is now available to MSDN and TechNet subscribers and will be available for evaluation download on Aug. 7, 2008. SQL Server 2008 Express and SQL Server Compact editions are available for free download. As previously announced, pricing for SQL Server will not increase with SQL Server 2008. According to the Microsoft press release, Microsoft Releases SQL Server 2008, "This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive and intelligent platform necessary for business-critical applications." SQL Server is an industry leader in both scalability and performance. · It is the first and only database management system to be proven capable of delivering scalable results on TPC-E, the Transaction Processing Performance Council’s (TPC) newest and most challenging online transaction processing (OLTP) benchmark, with 13 published benchmarks to date. Full results are available at http://www.tpc.org. Results referenced are current as of July 29, 2008. · Seven benchmarks are published on Windows Server 2008 and SQL Server 2008 by multiple hardware vendors, demonstrating strong price-performance and performance results, including IBM Corp.’s new No. 1 performance result using SQL Server 2008 on a 64-core System x3950 M2 server. [IBM System x3950 M2, 1250 tpsE, 1311 $/tpsE, available Aug. 30, 2008.] · Unisys Corp. and Microsoft set a new extract, transform and load (ETL) performance record by loading 1 terabyte of data in less than 30 minutes using SQL Server 2008 Integration Services. In addition, SQL Server 2008 has proven its scalability in large-scale data warehousing, as demonstrated by its recent 10-terabyte TPC-H benchmark. [HP Integrity Superdome, 63651 QphH@10TB, 38.54 $/QphH@10TB, available Aug. 30, 2008.] SQL Server 2008 is available in the following editions: · SQL Server 2008 Enterprise. SQL Server 2008 Enterprise is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics and reporting support for running business-critical applications. With this edition, it is possible to consolidate servers and perform large-scale online transactional processing. · SQL Server 2008 Standard. SQL Server 2008 Standard is a complete data management and business intelligence platform that provides best-in-class ease of use and manageability for running departmental applications. · SQL Server 2008 Workgroup. SQL Server 2008 Workgroup is a reliable data management and reporting platform that delivers secure, remote synchronization and management capabilities for running branch applications. This edition includes core database features and is easy to upgrade to the Standard or Enterprise edition. · SQL Server 2008 Web. SQL Server 2008 Web is designed for highly available, Internet-facing Web-serving environments running on Windows Server. SQL Server 2008 Web provides the tools necessary to support low-cost, large-scale, highly available Web applications or hosting solutions for customers. · SQL Server 2008 Developer. SQL Server 2008 Developer allows developers to build and test any type of application with SQL Server. This edition features all of the functionality of SQL Server Enterprise but is licensed only for development, test and demo use. Applications and databases developed on this edition can easily be upgraded to SQL Server 2008 Enterprise. · SQL Server 2008 Express. SQL Server 2008 Express is a free edition of SQL Server that features core database functionality including all of the new SQL Server 2008 data types, in a small footprint. This edition is ideal for learning and building desktop and small server applications, and for redistribution by ISVs. · SQL Server Compact 3.5. SQL Server Compact is a free embedded database designed for developers and is ideal for building stand-alone and occasionally connected applications for mobile devices, desktop Powerful New Business Intelligence Capabilities Join SQL Server 2008s and Web clients. SQL Server Compact runs on all Microsoft Windows platforms, including the Windows XP and Windows Vista operating systems, and on Pocket PC and smartphone devices. For more information, see SQL Server 2008. For key features of SQL Server 2008 of interest to ISVs, see Powerful New Business Intelligence Capabilities Join SQL Server 2008 and SQL Server 2008 To Ship in August, No Price Increase. · SQL Server 2008 Case Studies · SQL Server 2008 SKUs
The wait is over. SQL Server 2008 has been released and is ready to deliver a rich set of integrated services that enable you to do more with your data, such as query, search, synchronize, report, and analyze. Many of you have been evaluating the SQL Server 2008 betas, and may be ready to try out the RTM version. TechNet Plus subscribers can find RTM versions now available for download. Speaking of TechNet Plus, read Keith Combs’ Blahg for his take on the UI improvements for the newly revamped TechNet Plus Subscriber Downloads page. TechNet Magazine recently published an overview of the key changes and what you can expect from SQL Server 2008. You can also get a rundown of the various editions and components of SQL Server 2008 and take part in SQL Server 2008 tutorials. • SQL Server 2008 Videos • Webcasts: 24 Hours of SQL Server 2008 for IT Professionals • Webcasts: 24 Hours of SQL Server 2008 for Developers If you are looking for assistance with SQL Server 2008 planning and installation, here are some helpful links: • Planning a SQL Server Installation • Installing SQL Server 2008 • Locating Previous Versions of SQL Server for SQL Server 2008 migration using Microsoft Assessment and Planning Toolkit Once you’ve installed SQL Server 2008, these resources can help you optimize your database environment: • Configuring SQL Server 2008 You can also find guidance for upgrading to SQL Server 2008 or migrating to SQL Server 2008. If you are upgrading, be sure to check out Using Upgrade Advisor to Prepare For Upgrades.
SQL Server 2008 has been released and is ready to deliver a rich set of integrated services that enable you to do more with your data, such as query, search, synchronize, report, and analyze. MSDN subscribers can find RTM versions now available for download. SQL Server 2008 evaluation versions are available for free download as are free downloads of SQL Server 2008 Express and SQL Server Compact editions.
Ok so not everything for SQL Server 2008 is available yet, Report Builder is going to have a lag, you can find RC 1 here. This should work with RTM SQL 2008. Here are some of the changes from the last RC; · Support for directly opening and editing reports stored on the report server. · Support for using server resources such as shared data sources. A query designer for Microsoft SQL Server data sources.
Well now that SQL Server 2008 has shipped, Zach and I are starting to put the finishing touches on all of our SQL Server 2008 early adopter initiatives and move on to planning for future releases. Before we do that I have some unfinished business to take care of. My boss, Mauricio, has been on me for months asking me to list the top 10 features of SQL Server 2008. I have been stalling. I think every single feature in the product is compelling, and inevitably I am going to leave something out and will hear about it later from the team that built it. But with PDC '08 just around the corner, it's now or never. So let me qualify my post by saying that this list represents the 10 things I talk to developers about when I discuss SQL Server 2008. Often I don't have the luxury of spending all day (which I could) having this discussion, so I have to pick a few things that I think will stick. · Improved BLOB Support via FILESTREAM: Finally, a high performance streaming option for BLOBs (binary large objects) in SQL Server. This is exposed as an attribute on varbinary(max), and uses NTFS to persist the BLOBs in chunks rather than cluttering up your precious data and index pages, SQL Server takes care of the garbage collection. It's fully integrated from a transactional and management perspective and supports backup/restore with your database data. Getting at the data programmatically requires some rethinking. If you are familiar with Win32 file streaming API's (which are the highest performance way to access BLOB data in Windows) you will have a head start. Native code developers will find new FILESTREAM API's in SNAC (SQL Native Access Client), and managed code developers will find a new SqlFileStream managed class in Visual Studio 2008 SP1. See my post here. Note that this post is a bit dated as well, the managed code api's were not yet available. · Improved Date and Time Types: Quentin Clark told me this was the single largest engineering effort for SQL Server 2008. I started thinking about it and realized how pervasive a change to a data type is, from the storage engine, to the query processor, to data programmability API's, to backward compatibility. I have to say I'm glad the SQL team decided to take the hit, these new types have already come to the rescue in a couple of projects I've worked on. DateTime2 is the "new and improved" DateTime, with up to seven digits of accuracy (100 nanoseconds) and improved range with no goofy start date in the 1700's. Alas the last of the Sybase holdovers appears to be slipping away!! DateTimeOffset is the new "timezone aware" version of DateTime2, allowing you to save a timezone offset value along with your DateTime2 value. Now datetime calculations can include values from different timezones. Tired or storing that extra baggage if you just want to store a date or a time? Enter the Date and Time types. There are definitely some nuances to using these new types and converting systems from the old types to the new types. You should manipulate them programmatically with care, remember that these new types have increased precision and you don't want to lose data during a conversation operation. Also, from a .NET data programmability perspective, you'll want to use the standard System.DateTime and System.DateTimeOffset (introduced in the .NET Framework 3.0) types to host these values, as the old .NET System.Data.SqlDateTime type only handles old DateTime values. If you need to support null values, you'll need to implement them as .NET Nullable types. · CLR Everywhere: While not exactly new for 2008, support for managed code in all of the core services has improved significantly. So much so that the SQL team itself is starting to build core capabilities using managed code, Spatial Types are just one example of this. On a recent project, I was able to take some C# functions I wrote and use them in the database engine, in Reporting Services and in Integration Services. The ability to break out of the core server programmability paradigms such as Transact-SQL and SSIS expressions and leverage the power of the .NET Framework is an absolute life saver. · Transact-SQL Improvements: There are many, including Table-Value Parameters (TVPs), row constructors, rich assignment operators, and the ability to do variable assignment right in the DECLARE statement. There is an important new DML command in MERGE, a.k.a. "UPSERT" that allows you to either insert a new row or update an existing row in the same statement. And for those relational die hards who refuse to be drug into the world of Analysis Services, a new aggregation capability called GROUPING SETS will make it easier to roll up those aggregate functions. · Change Data Capture: CDC is the closest thing to a log reader that you will ever see from Microsoft. We open up some virtual tables against the transaction log and surface any changes to affected tables, which you can then grab in your application and do interesting things with. CDC is a low-level thing that you would use if you want to build your own sync capabilities. SQL Server Replication is what you would use if you don't want to have to build all that plumbing. · Change Tracking: Applications that support occasionally connected sync capabilities have to track a lot of metadata to make sure that offline changes get applied correctly and to handle conflicts. In SQL2K8 you can enable change tracking at the table level, and SQL Server will manage all that for you. When used in conjunction with the Microsoft Sync Framework, developers now have fine-grained sync support all the way from the database engine out to the API level to build rich occasionally connected solutions. For SQL Server-only installations that don't need a lot of fine-grained control, SQL Server Merge Replication may still be the solution of choice. · LINQ for SQL: Application developers who are not database developers have long wished for a more tightly bound way to express SQL in their source code. Dynamic SQL can't be checked at compile time, and stored procedures aren't visible in application source code. Enter LINQ for SQL, or "Language Integrated Query". LINQ for SQL allows developers to code their queries against local pre-generated classes, not remote database objects. The classes isolate the developer from the specifics of where the data is stored and in what format, and offer a higher degree of type fidelity and developer productivity. With that isolation comes certain tradeoffs, such as fine grained control over the SQL that gets generated, update semantics etc. Most solutions will be a blend of LINQ and dynamic SQL, but one thing is for sure, LINQ is here to stay. · Entity Framework: The Entity Framework offers an even higher level of abstraction to collections of "entities". These entities are modeled prior to developing against them, and highly productive programming paradigms (such as LINQ for Entities) are enabled on top of them which further isolate the developer from ugly data access plumbing and physical database goo. While this is definitely version 1.0 technology, it is clear that the data programmability team is very serious about moving this technology into the future, so give it a good look now so you can understand how it works. The same tradeoffs apply here as with LINQ to SQL, but at a larger degree of abstraction. You can see various incarnations of the Entity Framework showing up in other projects, such as ADO.NET Data Services. · BI Programmability Enhancements: This category needs another top 10 list, but in my world every developer should know how to build integrated reporting and analytics solutions, and therefore should know about what's new for developers in SQL Server 2008 Integration Services, Reporting Services and Analysis Services. Here's my top picks for each of these three important components · Integration Services: Support for C# scripts, especially in the Transformation Script Components, is an absolute life saver. Lookup Transformations have been completely re-worked for the better, with much improved caching options and the ability to share cache's across data flows and packages. I also really like the new Data Profiling Task which can help you get a handle on a new data source very quickly. · Reporting Services: Big investments have been made in providing a more productive report design experience for both the Visual Studio based "BI Development Studio" and the new stand-alone report designer known as "Report Builder 2.0". The new RDL Tablix element make's it easier to build complex reports that may have previously required multiple data regions and or reports. · Analysis Services: Our flagship OLAP server, and its integrated Data Mining functionality have seen a lot of improvements. I particularly like the design-time guidance when building cubes, reminding you on the right way to build attribute hierarchies and the like before you shoot yourself in the foot. From a data mining perspective, the time series algorithm has been updated and should see a lot of use, and the data mining add-ins for Excel 2007 have also been improved. Whew, I'm glad I have that done! Best of luck to all you eager database developers out there, I hope your experience with SQL Server 2008 will be as exciting and interesting as mine has.