Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.
MSDN Magazine July 2008
View Complete Post
Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.
MSDN Magazine August 2010
Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.
MSDN Magazine October 2006
Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.
MSDN Magazine July 2006
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.
MSDN Magazine June 2006
SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.
MSDN Magazine February 2005
In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.
MSDN Magazine September 2004
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.
MSDN Magazine May 2002
In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:
An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:
My ODC Connection Name
We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx). Excel Services is configured according to spec (global
settings, trusted file locations, trusted data providers and trusted data connection libraries). The Secure Store Service is configured with the ProjectServerApplication target application.
Non-OLAP data refreshes of spreadsheet data work fine in the browser. OLAP data refreshes in the Excel client itself work fine. Only the OLAP refreshes in the browser fail. The problem occurs whether using a Microsoft ODC or one that
we created (saved in a trusted location).
The ULS log has only one error, which is:
06/21/2010 13:47:17.86 w3wp.exe (0x1238) &
I'm using Visual Studio 2010. Project .NET 2.0 ASMX web service to SQL 2005. In the VS development server the data goes into the SQL Server correct but the page displays a blank http 500 page. When I load it to the local IIS webserver
the data does not go and it still displays the blank http 500 page.
Here's my code
/// Summary description for CourseEnquiry
[WebService(Namespace = "urn:portal.com:passportService")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class PassportService : System.Web.Services.WebService
public int PassportMethod(string PassNumber, string PassType, DateT
LINQ's ability to project randomly shaped data into anonymous types can be a blessing and a source of frustration, says Julie Lerman. It's great when you just need to grab a special view of your data, but it can be problematic in certain circumstances. She explains what the limitations are and how to get around them.
MSDN Magazine May 2010
Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.
MSDN Magazine April 2010