Roger Doherty's SQL Server Evangelism Blog

Now that you understand how to design and query Analysis Services cubes, this eighth unit in the SQL Server 2008 R2 Business Intelligence Training Course (a.k.a. SQLInsights ) on MSDN describes how to access cube data from familiar tools like Reporting...

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

Dashboards are a fundamental component of any performance management solution, and SharePoint 2010 PerformancePoint Services provides a rich set of tools and services for building highly interactive dashboard experiences that can help organizations of...

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

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

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

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

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

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

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 June 2010 update. This update includes two additional units of new content covering SQL Server 2008 R2 related improvements in Excel 2010...

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

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

Well, I've violated the most sacred commandment of blogdom: " Thou shalt blog regularly. " I won't bore you with lame excuses for why it's been so long since I've posted. I had the privilege of hosting a Yukon Ascend Business Intelligence (BI) for Developers...

Well I have to apologize for my long absence. I'm just not a very consistent blogger. I'll just have to do better. Here's the good news: you won't see any smarmy posts from me about my personal life, I prefer to be a nameless / faceless Microsoft automaton...

In my last post I talked about how I used SQL Server 2005 log shipping to create a hot standby of the Airframe production database to be used for both disaster recovery and as a data source for operational reporting. In this post I'll discuss how to configure...

In my last post I discussed how to configure database security on two SQL Server 2005 instances outside a firewall to enable operational reporting. In this post I’ll examine the security configuration of the SQL Server 2005 Reporting Services (SSRS) instance...

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