Excel 2007 – How to connect to and import data from an XML Web Service

Many organizations have adopted a Service-Oriented Architecture (SOA) as the architecture of choice. SOA allows a company to expose its services and data in a manner that is compliant with industry standards. SOA is the buzzword these days. Down the wire of SOA is XML data that is exchanged between entities. Microsoft Office Excel 2007…


Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE) – Home

This is a great project for those of us who need to work with lots of ETL operations. Do check it out. Microsoft SQL Server Metadata-Driven ETL Management Studio (a.k.a. MDDE) provides a tool for rapidly generating SQL Server Integration Services (SSIS) packages from a shared central metadata repository. MDDE is a software factory for…


My favourite Visual Studio Team System Resources

Hello, everyone Just wanted to share some of my favourite resources for Visual Studio Team System that I love most. I hope you enjoy them as much as I did: Visual Studio Gallery The Visual Studio Gallery is a central place for Visual Studio developers to find productivity tools, controls, and other products that integrate…


SQL Load Test

Project Description This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed to be used in a Visual Studio Load Test. The code generated is easily modifiable so that data variation can be introduced…


Business Objects Solutions for Microsoft

If your organization invested in SAP’s Business Objects and the Microsoft Platform, then you’d definitely need a way to integrate both platforms and provide your users with the best possible productivity tools. Business Objects makes this possible via the Business Objects Solutions for Microsoft. There are solutions for integration with SharePoint, Visual Studio, Office, Dynamics…


My arsenal of resources for development on top of SQL Server and the Visual Studio Team System

Hello, everyone Just wanted to share my arsenal of great resources I use during my development and proof of concept engagements with my customers. Hope you find these resources useful. Visual Studio Team System for Database Professionals  I use Visual Studio Team System for Database Professionals a lot. I find it very useful and beneficial….


The MSDN Tester Center is now Live!

Yes, it’s now live! The Microsoft Tester Center showcases the test discipline as an integral part of the application lifecycle, describes test roles and responsibilities, and promotes the test investments required to deliver high quality software. At the Tester Center, our goal is to provide a community where software testers can share knowledge and learn…

TechEd 2007 VSTS sessions ready for you – On Demand

During TechEd 2007 in Orlando, a lot of interesting sessions were delivered about the Visual Studio Team System.   Session recordings and decks are now available online. Anybody can access these, regardless of whether or not they attended TechEd.   http://msdn2.microsoft.com/en-us/teamsystem/bb676080.aspx     Enjoy.

SQL Server Books online now searchable using Live.com

I wonder about you, but I love the new live.com search engine. It’s fast, reliable, and is returning more accurate results every time I use it. I was hoping we can come up with something that could make using Live.com even better. Now, with the help of Dirk Meyers, SQL Server Books Online is now…