Recently in Data Architectures Category

A developer asked a question on MSDN that was similar to a question a few days earlier so I decided to help folks get over the problems of setting report parameters in ReportViewer projects.

I’m working the forums this week and I’ve already seen several questions asking if SQL Server Express Edition is up to the task. Shown below are the Microsoft links to Express’ limitations but I would like to clarify just what the mean (and can’t say).

It was brought to my attention that there was some concern that the “amateur” LightSwitch developers would be incapable of writing stored procedures so the tool should not support accessing them—it doesn’t. Here is my response along with a couple of other questions for Microsoft…

LightSwitch Arrives

| 2 Comments | No TrackBacks

Microsoft is gearing up to announce “LightSwitch”, it’s newest data application developer tool. Targeted to developers of “…all skill levels” it’s designed to permit access to local or remote data sources including SQL Server, Azure and SharePoint. I assume this means that amateur developers will have another tool to work with—assuming they can afford it and their IT organization will let them use it.

Frankly, I’ve known about this new offering for some time but until now, I was under NDA and could not reveal any of its details (or even the name). Now that it’s been released, I have a few choice words to add to the drumbeat…

This week I’m transitioning my existing Reporting Services catalog to SQL Server 2008 R2. I’m also building a separate VM where I can demonstrate the differences in “native” vs. SharePoint integration. This blog will serve as a notepad to log the issues I encounter along the way. Incidentally, I had to bump up the VM RAM to 3GB to get this install sequence to run without swapping. I also allocated 3 processors to the VM as it was also CPU bound with only one processor. I noticed that deploy performance was noticeably longer once SharePoint integration was enabled.


They’ve invited me to talk at the local SQL Saturday #47 on June 12th. I’m giving two talks—one on Report Builder 2.0 and another on Visual Studio Local Data Cache.

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 12 2010 at THE MIXER on the Microsoft campus, 15255 NE 40th Street, North Commons, REDMOND, WA 98052. Admittance to this event is free, all costs are covered by donations and sponsorships.

Please register soon as seating is limited, and let friends and colleagues know about the event.

Given the number of people that struggled with the intermediate to advanced topics in my SQL Server and Reporting Services 9-hour series of sessions for Progressive, we've decided to offer the first in a series of introductory webinar courses to be offered each month (for the forseeable future). We're also providing guided labs for this course--as if it's taking place in a classroom. I'll be there to answer questions and if necessary setup a SharedView session with the student to debug their work in real time.


Powered by Movable Type 4.38

About this Archive

This page is an archive of recent entries in the Data Architectures category.

SharePoint is the next category.

Find recent content on the main index or look in the archives to find all content.