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
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
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.
Spending too much time deleting ads for online poker and the like. Vivisection is too good for spammers...
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.
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.
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.
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.
And here is the second part of that Jim Gray interview I mentioned a few days ago.
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.
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.
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.
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.
First session should be in early April. Topics covered in this program will be ClickOnce, Web Services, and most importantly,
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.
We've just published a new article, SQL Server 2005 Integration Services: Lessons from Project REAL, authored by some of the movers & shakers in the SQL data warehousing org. It provides some insight into best practices and potential issues when implementing business intelligence systems using Microsoft SQL Server 2005, based on lessons learned doing data extraction, transformation, and loading (ETL) work on data and scenarios from real companies.
Webcast 3/7: Introduction to SQL Server 2000 Reporting Services (Part 1 of 5) (Level 200)
Get an overview of SQL Server Reporting Services. Learn how to use the wizard to build simple reports and take a first look at the security model. The discussion also includes a demonstration of the report manager as well as simple examples of both push and pull delivery of reports.
Webcast 3/8: Introduction to SQL Server 2000 Reporting Services (Part 2 of 5) (Level 200)
Take a look at some more advanced ideas around report design. Learn how to create tabular reports, matrix reports, linked reports, charts and sub-reports. The discussion also covers reports that use cascading parameters and dynamic SQL queries.
Webcast 3/9: Introduction to SQL Server 2000 Reporting Services (Part 3 of 5) (Level 200)
This session focuses on SQL Server Reporting Services programmability, using a sample application that shows how to use the Web service to render a report. We also demonstrate a custom data source for SQL Server Reporting Services that reads data that is not accessible through SQL queries.
Webcast 3/10: Introduction to SQL Server 2000 Reporting Services (Part 4 of 5) (Level 200)
Learn more about security and manageability, beginning with a look at the Reporting Services security model, the sources of security information, and the security roles associated with reports and servers. Gain an understanding of the performance benefits offered by report snapshots, and how to create historical data for reports.
Webcast 3/11: Introduction to SQL Server 2000 Reporting Services (Part 5 of 5) (Level 200)
This session highlights report delivery methods, with special emphasis on the pull model of delivery through techniques such as report subscriptions and URL addressability. We also examine new features of SQL Server Reporting Services Service Pack 2, including client-side printing and SharePoint integration.
Looks like they have a batch scheduled starting tomorrow (3/3) and running through Monday 3/14 - you can check out the offerings at http://msevents.microsoft.com/CUI/search.aspx?culture=en-US. IMO, the most interesting one is on the Data Access Application Block, scheduled for Tuesday 3/8 at 11:00 AM PST.
One on SQL CE, Architecting Windows Mobile Solutions with SQL Server CE at 11:00 AM PST that covers best practices for designing mobile apps with CE, and an introductory one on Reporting Services, Microsoft SQL Server Reporting Services Technical Overview at 9:30 AM PST that covers components, common deployment scenarios, and beginning app development.