The MVP Summit has been pretty interesting so far. Much of what has been covered is under NDA and I'm not going to be the first to break it. But I can tell you about the Summit itself. Microsoft has 1,300 MVP's staying in downtown…
I'll be attending the Microsft MVP Summit in Seattle next week. Hopefully I'll be able to pass on at least some of what I hear :) I'm also hoping to hear a schedule for Beta 2.…
Well here's something I never knew. When you declare a table variable it does get instantiated into tempdb.dbo.sysobjects. I was under the impression it wouldn't. If you run this code... declare @junk table(i int) select * from tempdb.dbo.sysobjects where name not like…
Microsoft recently released a list of the largest SQL Server databases in production [http://www.microsoft.com/sql/evaluation/compare/wintercorp.asp]. Topping the list is a 5 TB monster from Verizon Communications. Actually Verizon appears 6 times on the top 24. It seems they've made a pretty…
I'm speaking at PASS [http://www.sqlpass.org/events/seattle03/index.cfm] on Wednesday at 3PM. For some unknown reason, I can't link directly to my presentation (PASS???). You can visit the search [http://ew.sqlpass.org/ew/pass/displaymod/SearchEvents.cfm] page and list the…
Many of the PDC presentations [http://msdn.microsoft.com/events/pdc/agendaandsessions/sessions/default.aspx] are now online. Most of the Yukon stuff is in the data track. There were some pretty interesting presentations. I especially enjoyed DAT401 - T-SQL Enhancements in SQL Server "Yukon" [http://www.gotdotnet.…
MSDN posted Overview of .NET Programming Features in SQL Server "Yukon" [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_ovyukonnetprogfeatures.asp] . The article has quite a few examples of CLR code inside SQL Server. It gives good examples of how things will actually…
Microsoft's Yukon web site [http://www.microsoft.com/sql/yukon/productinfo/default.asp] 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 [http://www.microsoft.com/technet/prodtechnol/sql/next/SQLSBDTS.asp]An Overview of SQL Server Yukon for the DBA [http://www.microsoft.com/technet/prodtechnol/sql/next/SQLYDBA.asp]Introduction to…
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.…