Posts Tagged ‘server’

This is the best explanation yet I’ve seen of the TFS 2010 pricing structure…

See Ewald Hofman | License costs of Team Foundation Server 2010.


Read Full Post »

Want to programmatically access your Sql Server Reporting Services Server? (SSRS) Turns out there’s an app for that! Or more precisely, a SOAP web service.

The Reporting Services SOAP API provides several Web service endpoints for developing custom reporting solutions. The endpoints currently fall into two categories: management and execution. The management functionality is exposed through the ReportService2005 and ReportService2006 endpoints. The ReportService2005 endpoint is used for managing a report server that is configured in native mode and the ReportService2006 endpoint is used for managing a report server that is configured for SharePoint integrated mode. The execution functionality is exposed through the ReportExecution2005 endpoint and it is used when the report server is configured in native or SharePoint integrated mode. The following topics show how these endpoints can be used for developing reporting solutions in Microsoft Windows, SharePoint, and Web applications.

via Integrating Reporting Services Using SOAP.

Read Full Post »

Caught an even better than average podcast from .NET Rocks!, this time regarding Team System. Steven covered a lot of material, but I found his discussion around the need for deliberate planning to be particularly useful, as well as his outline of why investing time and resources in TFS is worthwhile. At the end of the session Steven mentions how to get training material for free.

Steven Borg talks about his experiences delivering solutions with Microsoft Team System, with a special focus on automated builds.

Steven BorgSteven Borg is the founder of Northwest Cadence, a Gold Certified Microsoft Partner focused on Visual Studio Team System. He was selected as a VSTS MVP in the first round back in 2005, and has been a Team System MVP even since. He’s little ‘a’ agile, and big on understanding what makes successful development teams tick.

via .NET Rocks!.

Read Full Post »

I’ve used SSRS multiple times in the past and know of at least one instance where I’ll be using it again in the future so I was quite pleased to stumble upon Paul Litwin’s recent article regarding the current state of SSRS.

We’ve all heard that version 3 of a Microsoft product is when that product really hits its stride. And while I’m not sure of the truth of that software urban legend, I do have to say that Microsoft, with the release of SQL Server 2008 Reporting Services (which happens to be its 3rd major version), has released a gem of a reporting solution that is sure to please users of prior versions and bring more converts into the Reporting Services fold. The newest version of SQL Server Reporting Services is faster, can handle larger reports, supports a wider variety of browsers, and is more flexible thanks to the new Tablix data region, support for rich text content, and Microsoft Word as an output format.

One of the biggest, yet mostly invisible, changes Microsoft has made to SQL Server Reporting Services (SSRS) for SQL Server 2008 is that it has decided to ditch Internet Information Services (IIS).

I was dismayed to find that Reporting Services still doesn’t support a form-based security model out of the box.

One of my favorite improvements to SSRS is hardly mentioned by Microsoft but I know it will be very exciting for organizations like mine that need to support multiple browsers and platforms: the HTML rendered by Reporting Services renders nicely in most major browsers, including Internet Explorer, Firefox, Chrome, Opera, and Safari.

Speaking of rendering, Microsoft made a number of other improvements in this area too, including improved output to Excel and Text formats.

However, the big story here is the newfound support for the Microsoft Word format.

The Visual Studio-hosted report designer has gotten a significant makeover in this version.

Reporting Services textbox control now supports rich text formatting… Now imagine using the rich text support in SSRS to replace all of your desktop-based mail-merge solutions. In fact, when combined with SSRS support for scheduled subscriptions and the Word output format, one can easily envision a mail-merge operation that runs in the middle of the night and e-mails the “merged” documents to users or drops the documents in a network share folder. The only thing left to do is to print the documents!

A number of new chart types are also supported by the new release including stepped line, polar, Gantt, funnel, pyramid, histogram, and box charts.

via CODE Magazine – Article: SQL Server Reporting Services Hits its Stride.

Read Full Post »

Like most applications, a database plays a critical role in what I’m working on. Fortunately, two higher-end versions of Visual Studio are supposed to provide a Microsoft security blanket for developing a database, managing and tracking changes to a database, and deploying those changes. (Among other things)


Unfortunately, Microsoft left the security blanket for getting these pieces all working on a dirty bus seat in downtown Seattle.

First, you need the Enterprise or Developer edition of Sql Server installed. If you upgrade from a previously installed version and change the instance name be prepared for an rather unhelpful error message.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces,  Error Locating Server/Instance Specified)

You’ll receive this error message if you don’t have the correct instance name specified.

Database projects require a connection to a local instance of Microsoft SQL Server 2005 for design-time validation. To perform this operation, you must open the Tools menu, click Options and specify an instance of SQL Server 2005 that is running and to which you can connect in the Database Tools, Design-time Validation Database property page. When that is corrected, you must then refresh or reload the database project.

Or if you don’t have the correct version of Sql Server installed.

As it turns out, the error messages were a bit misleading. The actual problem was that I had the wrong edition of SQL Server installed on this machine. I had SQL Server Standard Edition installed, but to create a Database Project from within Visual Studio you must have either the Developer or Enterprise editions of SQL Server 2008 installed.

As with all software make sure to install the latest patches.

Although the name “GDR”, which stands for “General Redistribution Release”, implies otherwise, this really is a complete new release, based on a new architecture. We have taken the architectural changes from the Rosario project (Visual Studio Team System 2010) and rolled them forward in time. Rolling forward these changes help us align the GDR release with the upcoming Visual Studio Team System 2010 release and provide numerous new features and extensibility points in this release. If you would compare the GDR release with the “Visual Studio 2005 Team Edition for Database Professionals” or “Visual Studio Team System 2008 Database Edition” you will agree this is a completely new product!

And oh wait the latest patch just happens to remove that Sql Server requirement! Did I mention that you MUST use Sql Server 2005 if you don’t install this patch? And just ignore the fact that the references below to “SQL Express or SQL Server” should in fact be “SQL Server 2005 Developer or SQL Server 2005 Enterprise”.

Database Edition no longer requires a Design Database. Therefore, it is no longer necessary to install an instance of SQL Express or SQL Server prior to using Database Edition.

After all that fun the Validation feature seems to be broken but hopefully I’ll figure that out soon and everything will be downhill from here on out.

Yeah right. 🙂

Read Full Post »