Anith Gopal

Microsoft a annoncé cet été la publication de la première version de SQL Server Migration Assistant (SSMA) pour MySQL ! Avec cette version, Microsoft a actualisé la famille SSMA de produits pour Oracle, Sybase et l’accès avec la dernière version 4.2. SQL Server Migration Assistant pour MySQL est l’outil de migration de Microsoft. Il a été conçu pour aider la migration de bases de données

Choosing an edition of Microsoft SQL Server 2008 R2 is an important step when planning a Microsoft SharePoint Server 2010 deployment. This paper describes the benefits of deploying on SQL Server 2008 R2 Enterprise Edition and scenarios in which its features can be applied

Hey PHP and MySQL developers, did you ever wonder how to take full advantage of Windows, IIS and SQL Server?  You may be under the impression that breakthrough features like full-text search and smooth streaming are only available to .NET developers, but you would be wrong!  It’s time for you to learn why the Microsoft Platform is becoming more and more popular with PHP and MySQL developers. I am pleased to announce the availability of the PHP on Windows and SQL Server Training Kit February 2011 Update on the Microsoft Download Center.  You can download this release at the following URL: http://go.microsoft.com/?linkid=9763356 This training kit includes a comprehensive set of technical content including demos and hands-on labs to help you understand how to build PHP applications using Windows, IIS 7.5 and SQL Server 2008 R2.  We’ve refreshed the kit to support the latest version of tools, add-ins and drivers, and added some new content as well.  Here’s an overview of what’s included: Hands-On Labs (7) IIS 7.5 Access Control Features for PHP Updated: Using IIS 7.5 Media Features in a PHP Application (contains new smooth streaming exercise) Troubleshooting PHP Migrating PHP Applications to IIS 7.5 Introduction to Using SQL Server with PHP Using SQL Server Full-text Search and FILESTREAM Storage with PHP New: Getting Started with SQL Server Migration Assistant for MySQL Demos (2) Spatial demo SQL Server Reporting Services Demo The training kit also includes links to lots of resources including white papers, videos and more to help you get started hosting your PHP application on Windows and SQL Server.  We hope you find this content valuable, welcome to the Microsoft Platform!

  This update includes a rich new set of content designed for developers who want to learn how to build their first Microsoft Business Intelligence solution with SQL Server 2008 R2.   Microsoft BI solutions leverage your existing technology investments in .NET, SQL Server and Office to develop rich integrated reporting and analytics experiences that empower users to gain access to accurate, up-to-date information for better, more relevant decision making. This content is a complete training course that contains eleven units covering all the key aspects of Microsoft BI solution development.  Download it here: http://go.microsoft.com/?linkid=9710868 Here is a summary of what’s included: 31 presentations (PowerPoint slides, videos and transcripts included) 7 demos (installer scripts, videos and transcripts included) 12 hands on labs (installer scripts included) Here is a breakdown of each unit and its associated content: Build Your First Microsoft BI Solution with SQL Server 2008 R2 Presentation: Understanding Business Intelligence Demo: Delivering Information to Decision Makers with a Microsoft BI Solution Presentation: Introducing Microsoft BI Solution Development Demo: Introducing the Microsoft BI Development Toolset Introduction to BI Modeling Techniques Presentation: Designing Data Models for Microsoft BI Solutions Demo: Exploring a Sample Dimensional Data Model Presentation: Designing Semantic Models for Microsoft BI Solutions Demo: Creating a Data Model with the Microsoft Entity Framework Hands On Lab: Your First Look at the SQL Server 2008 R2 Sample Databases Hands On Lab: Building Your First Semantic Model with the ADO.NET Entity Framework Introduction to SQL Server 2008 R2 Integration Services Presentation: Introducing ETL Processing with SQL Server 2008 R2 Integration Services Presentation: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package Demo: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package Presentation: Implementing Data Flow Tasks in a SQL Server 2008 R2 Integration Services Package Presentation: Loading Fact and Dimension Tables in a SQL Server 2008 R2 Integration Services Package Demo: Implementing Data Flow in a SQL Server 2008 R2 Integration Services Package Hands On Lab: Building Your First Extract-Transform-Load Process with SQL Server 2008 R2 Integration Services Introduction to SQL Server 2008 R2 Reporting Services Presentation: Reporting Fundamentals with SQL Server 2008 R2 Reporting Services Presentation: SQL Server 2008 R2 Reporting Services Report Design Basics Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with a Relational Data Source Presentation: Adding interactivity to a SQL Server 2008 R2 Reporting Services Report Demo: Adding Interactivity to a SQL Server 2008 R2 Reporting Services Report Presentation: Extending SQL Server 2008 R2 Reporting Services Reports with Custom Logic Hands On Lab: Building Your First Relational Report with SQL Server 2008 R2 Reporting Services Publishing and Accessing SQL Server 2008 R2 Reporting Services Reports Presentation: Publishing SQL Server 2008 R2 Reporting Services Reports Demo: Publishing SQL Server 2008 R2 Reporting Services Reports Presentation: Enabling Self-Service Reporting with SQL Server 2008 R2 Shared Components Demo: Enabling Self-Service Reporting by Publishing SQL Server 2008 R2 Reporting Services Shared Components Presentation: Accessing SQL Server 2008 R2 Reporting Services Reports Programmatically Demo: Developing Embedded SQL Server 2008 R2 Reporting Services Applications Hands On Lab: Building Your First Reporting Application with the Visual Studio 2010 ReportViewer Control Introduction to SQL Server 2008 R2 Analysis Services Presentation: Analysis Fundamentals with SQL Server 2008 R2 Analysis Services Presentation: Understanding the Components of a SQL Server 2008 R2 Analysis Services Database Demo: Developing a SQL Server 2008 R2 Analysis Services Database Presentation: Introduction to SQL Server 2008 R2 Analysis Services Programming Demo: Developing a Time Dimension with SQL Server 2008 R2 Analysis Services Demo: Enhancing the End User Experience of a SQL Server 2008 R2 Analysis Services Cube Hands On Lab: Building Your First Cube with SQL Server 2008 R2 Analysis Services Introduction to SQL Server 2008 R2 Analysis Services Query Syntax Presentation: Introduction to SQL Server 2008 R2 Analysis Services MDX Presentation: Exploring SQL Server 2008 R2 Analysis Services MDX Query Techniques Demo: Introducing SQL Server 2008 R2 Analysis Services MDX Query Development Presentation: Exploring SQL Server 2008 R2 Analysis Services Cube Calculations Demo: Enriching a SQL Server 2008 R2 Analysis Services Cube with Calculations Hands On Lab: Building Your First Queries and Calculations with SQL Server 2008 R2 Analysis Services MDX Accessing SQL Server 2008 R2 Analysis Services Data Presentation: Developing SQL Server 2008 R2 Reporting Services Reports for Analysis Services Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with an Analysis Services Cube Presentation: Using Excel 2010 as an Analysis Services Client Demo: Creating an Excel 2010 PivotTable Using a SQL Server 2008 R2 Analysis Services Cube Presentation: Using SharePoint 2010 Excel Services with Analysis Services Data Demo: Publishing and Sharing SQL Server 2008 R2 Analysis Services Cube Data with SharePoint 2010 Excel Services Hands On Lab: Building Your First Multidimensional Report with SQL Server 2008 R2 Reporting Services Introduction to SharePoint 2010 PerformancePoint Services Presentation: Performance Management Fundamentals with SharePoint 2010 PerformancePoint Services Demo: Delivering an Interactive Performance Management Dashboard with SharePoint 2010 PerformancePoint Services Presentation: Developing KPI’s and Scorecards with SharePoint 2010 PerformancePoint Services Demo: Developing KPIs and Scorecards with SharePoint 2010 PerformancePoint Services Presentation: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services Demo: Developing Interactive Reports and Dashboards with SharePoint 2010 PerformancePoint Services Hands On Lab: Building Your First Dashboard with SharePoint 2010 PerformancePoint Services Introduction to Data Mining with SQL Server 2008 R2 Analysis Services Presentation: Data Mining Fundamentals with SQL Server 2008 R2 Analysis Services Demo: Developing Data Mining Models with SQL Server 2008 R2 Analysis Services Presentation: Programming SQL Server 2008 R2 Analysis Services Data Mining Demo: Embedding SQL Server 2008 R2 Analysis Services Data Mining in a Custom Application Hands On Lab: Building Your First Data Mining Model with SQL Server 2008 R2 Analysis Services Introduction to Self-Service Reporting and Analysis with SQL Server 2008 R2 Presentation: Self-Service Reporting Fundamentals with SQL Server 2008 R2 Demo: Self-Service Reporting with Report Builder 3.0 Presentation: Self-Service Analysis Fundamentals with SQL Server 2008 R2 Demo: Self-Service Analysis with SQL Server 2008 R2 PowerPivot for Excel 2010 Demo: Publishing and Sharing SQL Server 2008 R2 PowerPivot Workbooks with SharePoint 2010 Excel Services Hands On Lab: Building and Sharing Your First Report Builder 3.0 Report Hands On Lab: Building and Sharing Your First SQL Server 2008 R2 PowerPivot for Excel Workbook

You can download a free developer kit for SQL Server 2008 R2 (there’s also one available for SQL 2008, the link is at the bottom of the R2 download page). Each kit has videos, samples, labs, and more to help you learn about new features.

SQL Server 2008 R2 gets an official date http://blogs.technet.com/dataplatforminsider/archive/2010/01/19/sql-server-2008-r2-gets-an-official-date.aspx SQL Server 2008 R2 gets May release date http://www.infoworld.com/d/applications/sql-server-2008-r2-gets-may-release-date-497?source=rss_infoworld_news Get the SQL Server 2008 R2 November CTP and Self-Service BI Downloads http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx SQL Server 2008 R2 Books Online (November CTP) What’s New (SQL Server 2008…( read more )

The August CTP of SQL Server 2008 R2 contains a bug in Management Studio when connected to a Control Point.

  New Orleans was host to the Microsoft World Wide Partner Conference 2009 this week. With over 8,000 in attendance the WPC is a yearly opportunity for MS partners to connect with each other and gain insight into Microsoft’s strategy and direction.   I was able to attend the conference and wanted to provide a roundup for the exposure around Business Intelligence and some of the announcements that were made.

This video made its debut this week at TechEd 2009 during the Donald Farmer’s session on self service analysis with project Gemini. Watch for more details and recordings of the Business Intelligence TechEd sessions at TechEd Online         Get more details about SQL Server 2008 R2 and register for CTP notification   Follow the word on Twitter .