#1 Connectivity to SQL Azure

November 13, 2009

I’m enjoying the weekend, with Microsoft SQL Server R2 November CTP and its new features from Database engine features to Analysis Services features, Reporting Service features, etc…

I’ll post a series about those features en shaaa ALLAH in the next days, but let’s begin with Database engine features
#1 connectivity to SQL Azure: what’s SQL Azure? is a cloud-based relational database service built on SQL Server® technologies. To learn more about SQL Azure press here

First you need to have Microsoft SQL Server R2 November CTP, get all about it from here and SQL Azure account (I got it from Microsoft Connect)


Open SSMS, and using your Azure account (Server name, username and password) try to login
Read the rest of this entry »


SQL Server 2008 R2 November CTP3

November 11, 2009

SQL Server 2008

Updated on 11/11/2009 7:47 PM

Note: The download links below will launch the Akamai download manager which is designed to provide you with more control over your download experience.

Download now Microsoft SQL Server 2008 R2 November CTP http://care.dlservice.microsoft.com/download/7/B/4/7B4A1F68-4D05-42C1-8982-E5CD8492C6FA/SQLFULL_x86_ENU.exe

Microsoft SQL Server 2008 R2 add-in to Excel that allows very large sets of data to be manipulated efficiently aka Microsoft Gemini now its formal name is PowerPivot

Download: What’s New in SQL Server 2008 R2 November Community Technology Preview (CTP) http://www.microsoft.com/downloads/details.aspx?FamilyID=89550298-D564-40C5-B586-30DC3F909F6F&displaylang=en

It’s now available for download for MSDN and TechNet subscribers,  and it will be available to the general public on November 11th http://blogs.technet.com/dataplatforminsider/archive/2009/11/09/announcing-the-sql-server-2008-r2-november-ctp.aspx

First official video about Gemini from Microsoft

September 1, 2009

Project Gemini for Excel 2010

What’s GeminiProject code-name “Gemini” for Excel 2010 provides ground-breaking technology, such as fast manipulation on large data sets (often in millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through SharePoint 2010.

Video | http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Geminiv

Overview of Gemini features

August 25, 2009

From Microsoft Gemini team blog

The key question behind Gemini is: how much value can an Excel user derive from Microsoft’s BI stack without having to pick up a book on OLAP, Dimensional Modeling or Analysis Services?

More on http://blogs.msdn.com/gemini/archive/2009/08/24/overview-of-gemini-features.aspx

All about Microsoft SQL Server 2008 R2

August 16, 2009

Download SQL Server 2008 R2: http://www.microsoft.com/downloads/details.aspx?familyid=E19689BD-38DD-46C4-8645-F58CA4D61D1F&displaylang=en

What’s new in SQL Server Integration Services: No new features they just fixed some bugs: http://blogs.msdn.com/mattm/archive/2009/08/14/no-new-features-in-for-integration-services-in-sql-server-2008-r2.aspx

What’s new in SQL Server Analysis Services: I didn’t find any information about that!! if you know please drop a link.

What’s new in SQL Server Reporting Services: http://blogs.msdn.com/sqlrsteamblog/archive/2009/08/11/sql-server-2008-r2-august-ctp-what-s-new-in-reporting-services.aspx

Microsoft Gemini: http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Gemini or https://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=21090 to know about Microsoft Gemini

A small stand-alone MSI for Report Builder 3.0, August CTP, is now available for download here: http://go.microsoft.com/fwlink/?LinkID=160384

Download packages for SQL Server 2008 R2 August CTP are available here:

Source: http://blogs.msdn.com/sqlrsteamblog/archive/2009/08/14/report-builder-3-0-august-ctp.aspx