What 2011 Will Bring in Microsoft SQL Server Land

I am going to continue in this blog, on SearchSQLServer, SQL Magazine BI Blog and Twitter (@MSSQLDUDE) to focus on these core areas that you should watch for in 2011 for those of you that follow Microsoft SQL Server: Oracle integration, best practices, BI visualizations and SQL 11 (Denali).

But what are the new investment areas @ Microsoft and new & exciting outside of the classic SQL Server 2005/2008/2011 topics? Let’s focus on these for 2011 because it is clear this is the direction that Microsoft will take us:

1. Cloud Computing (SQL Azure & Windows Azure)

2. Database scale-out and load balancing with virtualization, SQL Azure and Parallel Data Warehouse

3. Silverlight BI hyper-cool visualizations on PCs, Slate and Windows Phone 7

4. How to take things to the next level with SQL 11

5. Cloud BI

What else interests you for SQL world in 2011?

Sample Cool Silverlight BI Controls

Sorry about this being a few weeks late, but I finally had the time today to grab copies of the JScript and XAML from the old Silverlight BI controls from a project that I worked on when I was with Microsoft Services a few years back. I demo’d this at the NYC SQL Saturday last month as part of my demonstration of some cool ways that BI developers can add Silverlight to your dashboard to spruce up your Microsoft BI solutions.

I am including the bar chart example with time sliders and smooth transitions. Keep in mind that these are only examples of what a Silverlight BI control would look like on your dashboard and that you would need to host it via a Web page to incorporate into a solution or into SharePoint / PerformancePoint. Also, I do not have code samples for data binding to this control. Also, it is Silverlight 1.0 (I think, I don’t remember, it was a while back) and so you should use this as a guide to recreate it in Silverlight 4.0. Maybe I’ll get some time to do that over the next couple of weeks.

The XAML is the Silverlight code and the JScript adds the values to the control so that you can demonstrate how it look, feels and works. Click on this link here to go to my Live SkyDrive and download the files.

Silverlight Map Controls for Microsoft BI

Just up with latest post on SQL Mag BI blog to complete the series on Silverlight for Microsoft BI here. It’s a final part of the series that Derek and I worked on to show Silverlight, mobile apps and other cool ways to visualize your Microsoft BI solutions and make them more compelling. Check it out, enjoy and send me your feedback & comments! Thanks, Mark