Jeff Papiez - SQL Server Test Developer

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

Browse by Tags

Tagged Content List
  • Blog Post: 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 a sample that proves this concept.   ...
  • Blog Post: 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 when prompted for a connection. ...
  • Blog Post: 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 users to edit the address records. But, rather...
  • Blog Post: 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 and Visual Studio 2005. My question to you is...
  • Blog Post: 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, and over again. Hm.. that's a mistatement. Not...
  • Blog Post: 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) listed below are currently installed....
Page 1 of 1 (6 items)