Roger Doherty's SQL Server Evangelism Blog

Zach and I just spent a couple of days figuring out how to make use of the new FILESTREAM support in SQL Server 2008 and we thought we'd share a little bit about the experience in hopes it might save somebody some time. There's a ton of information out...

So picking up from where I left off in my last post, I want to talk about my experience using the XML Source adapter in SSIS 2005 to load the data I extracted from SharePoint using the Data Retrieval service I blogged about in my last post. I had gotten...

In my last post I talked about associating the SQL Server 2005 Reporting Services (SSRS) application pool with a domain service account rather than NETWORK SERVICE to enable access to a data source outside a firewall. One thing I forget to talk about...

In our last series of posts Zach and I talked about using SQL Server's new FILESTREAM support to store, manage and retrieve media in SQL Server to enable rich user experiences. We've been at it again this week trying to get some traction with the new...

How are these two topics possibly related you ask? Well, I'm in Mexico City, I'm eating a burrito, and I'm bogging about data flow tasks in SQL Server 2005 Integration Services. So there you go. I'm going to start to use some Business Intelligence / Data...

We just shipped a whole bunch of new content for the SQL Server 2012 Developer Training Kit and you can get it right now via the Web Installer Preview : http://go.microsoft.com/?linkid=9785999 This update includes eleven new hands-on labs covering...

If you want to learn how to develop database and business intelligence solutions that fully exploit SQL Server 2012 improvements, this resource is for you! The SQL Server 2012 Developer Training Kit includes technical content like labs, demos and presentations...

Well now that SQL Server 2008 has shipped, Zach and I are starting to put the finishing touches on all of our SQL Server 2008 early adopter initiatives and move on to planning for future releases. Before we do that I have some unfinished business to take...

Microsoft is busy preparing the next release of SQL Server Code Name “Denali”.  This exciting new release will include improvements that are interesting to developers, DBA’s and business intelligence pros alike, including: Tons of new developer improvements...

We use a really unattractive term here at Microsoft to describe the use of pre-release software internally to get our jobs done. We call it dog food. I think SteveB may have come up with this very descriptive term, as in "Eat your own.... dog food." Anyway...

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

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

Well look no further!  I’m pleased to announce that the MySemanticSearch Sample is now available on CodePlex at: mysemanticsearch.codeplex.com MySemanticSearch allows a user to upload Word documents into a SQL Server 2012 table, then visualize the...

In my last post I introduced the first phase of the Airframe RA project called Operational Reporting. The gist of this phase is to augment an existing production system, in this case Airframe, with some quick and dirty reports to help everyday users of...

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

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

The Data-tier Application Framework (DAC Fx) was introduced in SQL Server 2008 R2 as part of an improvement category known as “ Application and Multi-Server Management ” (AMM).  It’s a completely new way to manage the handoff of database schemas...

That’s right, just in time for SQL Server 2012 launch madness, every single presentation and demo included in the SQL Server 2012 Early Adoption Cook Book now has a corresponding video on Channel 9!  There are 50 videos covering every imaginable...

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

If you are on the “bleeding edge” of SQL Server 2012 early adoption, and you need content, samples or upgrade resources to move the ball forward, read on! Microsoft creates a lot of content designed to drive early adoption for new releases of SQL Server...

Welcome to Roger Doherty's SQL Server Evangelism blog. If you are a developer who builds commercial software applications which utilize SQL Server as a database engine, you may be interested in following my blog. What is SQL Server Evangelism you ask...

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

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

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