Jeff Papiez - SQL Server Test Developer

Yesterday at the CES, we announced the future availability of Windows Home Server, a new server designed to be the central digital nervous system for the home. I've been running Windows Home Server at home for about 3 months now and I tell you it's just...

http://blogs.msdn.com/peterrosser/archive/2006/04/03/MCE_TechTalk_1.aspx

Windows Live Messenger is released! Pick it up here: http://get.live.com/messenger/overview

I came across this article on MSDN this morning about using P/Invoke in managed code. Had I came across this article a few weeks back it likely would have saved me some time! http://msdn.microsoft.com/netframework/default.aspx?pull=/library/en-us/dv_vstechart...

I don't know how many times I've had to search for this on TheGreenButton, so I thought I'd post the info here so I always know where to find it. The problem is this: I have 2 Media Center 2005 machines and one file server. Recorded TV that I want to...

SQL Server Express Edition 2005 (Express) installs a set of command line tools that it calls Workstation Components, which happens to collide with the Management Tools for the other SQL Server 2005 editions. This presents a problem if you first install...

Missed the PDC like I did? Well here's your chance to catch up. You can view all the sessions from here: http://microsoft.sitestream.com/PDC05/ My favorite so far: TLNL09: Tips & Tricks: Productivity Tips for the Visual C# 2005 IDE

If you've thought about using SQL Server 2005 Upgrade Advisor to determine the upgradability of your SQL Server 2000 cluster, be aware of the following issue. When you launch the Upgrade Advisor Analysis Wizard, you're prompted for the Server Name, which...

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...

Installing both SQL Server 2005 (SQL) and SQL Server Express 2005 (Express) on the same machine can present a problem that might not be easily identifiable. You can install both of these products on the same machine, though you must take care when...

A few things have changed since I blogged last. I've changed managers (though on the same team), and I'm working with a new product, SQL Server 2005 Upgrade Advisor. I own testing for the Upgrade Advisor engine and Report Viewer UI. I'll also own the...

For those folks out there using Windows Server 2003 SP1 Build 1277 along with the SQL Server 2005 December CTP, you may be unable to install SQL Server 2005 with the following error: Microsoft SQL Server 2005 Beta 3 Setup The SQL Server System Configuration...

... and if we don't stop and smell the roses... ah who am I kidding. I'm not word sleuth. But I do know this. My wife and I had our first child, a cute little boy named Jacob, back in March. He's growing like a weed. I can hardly believe how fast they...

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...

I was browsing the SqlServerCentral.com forums today and came across a post where a user was asking how to write a query to list all the stored procedures that contain a specific string. This might be useful, so I thought I better blog it lest I forget...

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...

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...

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...

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...

I suppose everyone has to have one of these, so here's mine. Not much to say right now at this late hour, but I wanted to get something up here before the day was up. Will I make it?