Roger Doherty's SQL Server Evangelism Blog

Developers worldwide use SQL Server 2008 R2 Analysis Services to build comprehensive, enterprise-scale analytic solutions that reach users through familiar applications. If you have never developed a cube and you want to understand why you should, this...

Are you planning on attending TechEd North America 2011 in Atlanta?  If so I’d like to encourage you to register for a special pre-conference session entitled Build Your First Microsoft BI Solution with SQL Server 2008 R2 .  This is a special...

Now that you understand how to develop reports, the next step is to understand how to publish and access them from your applications. This fifth unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights ) on MSDN will introduce...

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...

Do you need to develop rich, interactive reports as an integrated part of a business intelligence solution? If so, then check out this fourth unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights ) on MSDN. In just a...

Hey SQL Server Reporting Services developers, have you ever wished you could deliver Reporting Services capabilities without having to install, configure and maintain a Reporting Services instance on your own hardware?  Well your wish has come true...

Check it out developers, today we published the third unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights ) on MSDN. I hope you will take some time from your busy schedule to learn how to develop an ETL process (extract...

Today I’m pleased to announce the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights ), a new self-paced online training course brought to you by Microsoft Developer and Platform Evangelism. This is a is a great resource...

Today I’m pleased to announce the availability of the SQL Server 2008 R2 Update For Developers Training Kit January 2011 Update. This is a great resource for developers, trainers, consultants and evangelists who need to understand the key improvements...

This post is intended for those who are already familiar with SQL Server and want to get started working with SQL Azure .  One of the best ways to get up and running quickly is to migrate an existing SQL Server database to SQL Azure.  I chose...

Okay MySQL developers, do you know what you’ve been missing out on? Microsoft SQL Server developers count on great features like online backup and rich data types to build great applications that are also industrial strength. That’s right...

My fellow evangelist Zach Owens has been busy these days evangelizing SQL Server as a great platform for running WordPress . Everything is coming together nicely and he’s launched a great site that pulls together a lot of good links and information...

Today I’m pleased to announce the availability of the SQL Server 2008 R2 Update for Developers Training Kit June 2010 update. This update includes two additional units of new content covering SQL Server 2008 R2 related improvements in Excel 2010...

Today I’m pleased to announce the availability of the SQL Server 2008 R2 Update for Developers Training Kit April 2010 update. This update includes an additional unit of new content covering SQL Server 2008 R2 Reporting Services improvements. SQL Server...

Today I’m pleased to announce the availability of the SQL Server 2008 R2 Update for Developers Training Kit March 2010 update 2. This update includes an additional unit of new content covering SQL Server 2008 R2 StreamInsight, a comprehensive development...

In my previous post I announced the availability of the SQL Server 2008 R2 Update for Developers Training Kit. Today I’m pleased to announce the availability of the March 2010 update, which includes an additional unit of new content covering Application...

I’m pleased to announce that the first release of the SQL Server 2008 R2 Update for Developers Training Kit is available as a free download from the Microsoft Download center, so download your copy today at the following URL: http://go.microsoft.com...

I just wanted to spread the word that I recruited Andrew Brust to deliver the first-ever PDC workshop focused exclusively on building business intelligence solutions. He’ll be teaming up with Dom Demsak to deliver an intensive all-day workshop designed...

I’m pleased to announce that the SQL Server 2008 Developer Training Kit is available as a free download from the Microsoft Download center, so download your copy today at the following URL: http://go.microsoft.com/?linkid=9665942 Read on for more details...

In my previous post I talked about how we used SQL Server 2008 Service Broker to improve the durability of a data collection service for our March Madness Video On-Demand Silverlight player. This post provides a bit of background on the architecture of...

One of the best things about my job is that I get the opportunity to jump in and lend a hand to other teams who are trying to accomplish big things and need some great database technology to back them up. Back in December I was approached by Eric Schmidt...

If you use the Microsoft® Visual Studio Team System 2008 Database Edition GDR and SQL Server CLR Integration , do me a favor and vote for this feedback item on Microsoft Connect : Connection : Visual Studio and .NET Framework Feedback ID : 418322 Title...

As a SQL Server Technical Evangelist I have a lot of customers. My internal customers include the SQL Server and Visual Studio development teams. The primary thing they are looking for from me is to drive great feedback back into the development teams...

My colleague Larry Clark contacted me today regarding my PDC presentation covering the 2008 Summer Olympics video monitoring project. Basically he wanted more information on some of the lessons I learned to make my SSIS package scale. This package I built...

At last, Visual Studio 2008 for DB Pros is fully in sync with the SQL Server 2008 release. The new "GDR" release sports a lot of new interesting capabilities as well. Full details can be found on Gert Drapers blog post here .