posts - 219, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

October 2003 Blog Posts

Overview of .NET Programming Features in SQL Server "Yukon"

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.

posted @ Wednesday, October 29, 2003 2:39 PM | Feedback (0) | Filed Under [ SQL Server Stuff ]

Microsoft SQL Server "Yukon" Website

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.

posted @ Wednesday, October 29, 2003 2:37 PM | Feedback (0) | Filed Under [ SQL Server Stuff ]

Yukon Articles

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

posted @ Tuesday, October 28, 2003 6:38 AM | Feedback (2) | Filed Under [ SQL Server Stuff ]

DBCC CHECKIDENT weirdness

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

posted @ Tuesday, October 21, 2003 10:04 AM | Feedback (7) | Filed Under [ SQL Server Stuff ]

Reporting Services Beta

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.

posted @ Thursday, October 16, 2003 2:44 PM | Feedback (1) | Filed Under [ SQL Server Stuff ]

Yukon Beta 2 in May 2004

MS announced at their partner event  that Beta 2 for Yukon will begin in May 2004.

posted @ Tuesday, October 14, 2003 6:38 AM | Feedback (0) | Filed Under [ SQL Server Stuff ]

Kansas City SQL Server Users Group (Oct 9th, 2003)

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.

posted @ Tuesday, October 07, 2003 4:47 PM | Feedback (1) | Filed Under [ Events SQL Server Stuff ]

SQL Server Developer Edition really is under $50

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.

posted @ Wednesday, October 01, 2003 2:16 PM | Feedback (0) | Filed Under [ SQL Server Stuff ]

Feedback now on the main page

FYI - I've updated the main page to display the feedback information about each post.

posted @ Wednesday, October 01, 2003 11:04 AM | Feedback (0) | Filed Under [ Miscellaneous ]

Powered by:
Powered By Subtext Powered By ASP.NET