October 2003 Blog Posts
MSDN posted Overview of .NET Programming Features in SQL Server "Yukon". The article has quite a few examples of CLR code inside SQL Server. It gives good examples of how things will actually work.
Microsoft's Yukon web site is up. They have links to articles and a demo video. I haven't looked through in too much depth yet.
Microsoft has posted a series of articles on Yukon.
A Practical Guide to SQL Server Yukon Beta 1 DTS
An Overview of SQL Server Yukon for the DBA
Introduction to SQL Server Yukon Relational Engine Security Features
Overview of Business Intelligence and Data Warehousing in SQL Server Yukon
Reporting Services Deployment Guide
DBCC CHECKIDENT is quirky. If you run it to reset an identity column such as
DBCC CHECKIDENT (jobs, RESEED, 30)
it acts differently depending on whether you've ever had data in the table. Books Online says
The current identity value is set to the new_reseed_value. If no rows have been inserted to the table since it was created, the first row inserted after executing DBCC CHECKIDENT will use new_reseed_value as the identity. Otherwise, the next row inserted will use new_reseed_value + 1.
I have a script that does a pretty extensive data load. In order to rerun it, I have a series of...
You can sign up to participate in the Reporting Services beta here. I don't know if they take everyone or not but it can't hurt to sign up.
MS announced at their partner event that Beta 2 for Yukon will begin in May 2004.
Just a quick reminder that the Kansas City SQL Server Users Group will be having their meeting on October 9th, 2003 at 6PM. I (Bill Graziano) will be presenting on Advanced Profiler topics. This is an early version of the presentation I'm going to present at PASS in November. The meeting is at Johnson County Community College in room 318 of the Carlsen Center. Hope to see a few of you there.
If you know of any other SQL Server users groups, please let me know and we'll post the information.
Microsoft announced that as of August 1st, 2003 SQL Server Developer Edition would cost $49. On that date I couldn't find anyone offering it at that price. I recently did a quick search and found that at least Amazon is offering at that price. I'm assuming most other vendors are also.
FYI - I've updated the main page to display the feedback information about each post.