Welcome to MSDN Blogs Sign in | Join | Help

Jeff Papiez - SQL Server Test Developer

My random thoughts, ideas, comments, and brain dumping ground.

Browse by Tags

All Tags » Visual Studio 2005   (RSS)
Passing a DataSet to a SQLCLR Stored Procedure
Is it possible to pass a DataSet to SQL and process the data in a SQLCLR stored procedure? This is the question I set out to answer. The .NET Framework 2.0 adds some features to the DataSet that make this scenario possible (WriteXml, ReadXml). I created Read More...
HowTo: Debug a Managed Stored Procedure with Visual Studio 2005 and SQL Server 2005
In response to a newsgroup post, I wrote this quick little tutorial. This tutorial assumes you have the AdventureWorks database installed, but any database will do. 1. Create SQL Server Project in Visual Studio 2. Add a connection to AdventureWorks database Read More...
Databound List Boxes
This one had me stumped for a little while until I was kicked in the right direction. The Problem You have two tables, Address and State. Address contains an attribute StateId, which is a primary key in the State table. You create a GridView to allow Read More...
How do we Integrate?
Some background is probably in order. I'm a Software Tester here at Microsoft. I work in the Integration Test Team, Release Release Services, SQL Server. One of my new jobs is to look at how our products integrate. Currently I'm investigating SQL Server Read More...
New Databinding in ASP.NET 2.0
First off, my hat's off to the ASP.NET team for some very cool new controls. I have been developing web content, on and off, for quite some time (let's just say a long time). Sometimes I really get tired of coding the same thing over, and over, and over, Read More...
Visual Studio 2005 Beta Install Woes
I was all psyched to install Visual Studio 2005 Beta 1 today. After launching Setup, I got a nice little error message --------------------------- Visual Studio Beta Setup --------------------------- Setup has detected that previous versions of the product(s) Read More...
Page view tracker