Christa Carpentiere

On to new challenges

I'm moving on to a new role over on the MBF UE team. Euan Garden has graciously assented to be the blog for the SQL dev center, and the DataWorks team blog will fill that role on the Data dev center, so you'll see those up starting the end of this week.

I'm looking forward to learning a new technology, but that does mean I'll be shifting focus from SQL Server, and I will subsequently be letting this blog wind down. Look for me on the msdn blogs in the future, once I know enough about my new technology to have something to say about it :)

Cheers,
Christa

Chat 4/19 1:00 PM PST: Visual Basic 2005 Data Enhancements

Join members of the Visual Basic team to talk about Visual Basic 2005's new data-related features, such as drag-and-drop data binding, binding to objects, working with local data, and new data components.

Add to Calendar

ADO.NET dupe ID issue from Duncan

And he posts about it in http://blogs.duncanmackenzie.net/duncanma/archive/2005/04/12/1295.aspx. He ran up against a problem getting duplicate IDs in an offline scenario, turns out he needed to change how he used AutoIncrement.

Sorry, disabling comments for now

Spending too much time deleting ads for online poker and the like. Vivisection is too good for spammers...

Reducing avenues of attack in SQL 2005

Good article by Mike Gunderloy on developer.com on this subject, Managing the "Surface Area" of SQL Server 2005. Provides concise coverage of some of the new tools that will help you enhance security by reducing the surface area of your 2005 installation.

Data Webcasts 4/7 and 4/8

Webcast 4/7 10:00 AM PST: Data-Disconnected: Working with Disconnected Data Using ADO.NET 2.0 (Level 400)

What's so great about Microsoft ADO.NET 2.0 and the disconnected model? Check out this webcast and find out about the strong and powerful disconnected model built into ADO.NET that allows applications to work with databases that exist in memory. Learn how to use ADO.NET to implement online/offline smart client applications, and how to take advantage of the new abilities of ADO.NET 2.0.

Webcast 4/8 11:00 AM PST: Native Data Access Technologies for SQL Server 2005 (Level 300)

Learn about all of the ways to connect natively to Microsoft SQL Server 2005 from your smart client application. This webcast looks at ODBC, OLE-DB, and SNAC, and highlights what has changed for SQL Server 2005 in terms of native data access technologies.

Data Mining APIs in SQL Server 2005

Thanks to Bogdan Crivat (dev in the SQL Data Warehouse group) for a great new article on the topic, SQL Server Data Mining Programmability. If you want to get familiar with this area, here's a great place to start.

New SQL 2005 webcasts coming in April

This batch is focused on integration with VS 2005, especially smart client development. You can check out the offerings at http://www.microsoft.com/events/series/msdnsqlserver2005.mspx.

Jim Gray, Part II

And here is the second part of that Jim Gray interview I mentioned a few days ago.

Interesting security article

Michael Howard and Steve Lipner have authored The Trustworthy Computing Security Development Lifecycle, which should make good reading for anyone in development these days. It covers how MS groups have gone about adding security goals and processes into the development lifecycle, and what they've learned from this experience.

Channel9 interview with Jim Gray

Jim Gray is a distinguished engineer in Microsoft's Scalable Servers Research Group, and the manager of our Bay Area Research Center. He's also a winner of the ACM Turing Award, and one of the great minds on the topic of databases and transaction processing. You can get his take on the latest trends in this area in this interview.

VSTS webcast series next week

There will be one every morning from 3/21 - 3/25 at 9:00 AM PST. Monday's will be a general intro, then the subsequent ones will drill down into the different editions as well as Team Foundation. Check out the upcoming webcasts page at http://www.microsoft.com/events/webcasts/upcoming.mspx for more info.

Profiler article

Mike Gunderloy has a new one, SQL Profiler Tips and Tricks, on developer.com. Dev-oriented, (as you might have guessed from the location :) it touches on some features of this tool you might want to try if you want to dig a little deeper into it.

MSDN Events Spring Program starts soon

First session should be in early April. Topics covered in this program will be ClickOnce, Web Services, and most importantly, Universal Data Access with SQL Server 2005. For more information, as well as dates & locations, see http://www.msdnevents.com/.

Webcast 3/15 1:00 PM PST - Data access with SQL Server Mobile Edition

Webcast 3/15: Data Access with SQL Server 2005 Mobile Edition and the .NET Compact Framework v2.0 (Level 200)

Learn about SQL Mobile architecture, accessing SQL Mobile databases with Visual Studio 2005, and how to use the new SqlCeResultSet class from within your .NET Compact Framework 2.0 applications.