• MSDN Unleashed - Tuesday, November 18, 2008 1:00 PM - Tuesday, November 18, 2008 4:00 PM Central Time (US & Canada)
  Session 1 - What’s New in SQL Server 2008 for Developers
  Session 2 – Build next generation applications with Silverlight 2.0
  https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&eventid=1032391568&flag=1
  
  
• Microsoft Executive Briefing-Nashville, TN - Tuesday, November 18, 2008 8:30 AM - Tuesday, November 18, 2008 11:30 AM Eastern Time (US & Canada)
  In an effort to provide visibility into our software roadmap as well as deeper integration with the local Microsoft team, we will be hosting a monthly invitation only executive briefing series for our enterprise and select agreement customers.
  https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&eventid=1032395341&flag=1
  
  
• Microsoft ArcReady: Professional Patterns On The Job - Tuesday, November 18, 2008 9:00 AM - Tuesday, November 18, 2008 11:45 AM Central Time (US & Canada)
  Session 1: Mastering the Soft Skills
  Session 2: Organizational Dynamics
  https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&eventid=1032391707&flag=1
  
  
• Join Microsoft and Compuware for a Developer Tools and Platform Roadmap Presentation - Thursday, December 11, 2008 6:00 PM - Thursday, December 11, 2008 9:30 PM Central Time (US & Canada)
  Welcome Time: 5:30 PM
  Topics for this presentation include: · What is coming in Visual Studio Team System 2010 ·  .NET 4.0 and C# futures · Azure and Software + Services
  https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&eventid=1032396380&flag=1
  
  
• Connect + Share Summit - Tuesday, January 27, 2009 8:30 AM - Tuesday, January 27, 2009 12:00 PM Eastern Time (US & Canada)
  The Microsoft Connect + Share Summit is an executive-level event designed for business and technical decision makers, that will demonstrate how leveraging Microsoft solutions can help overcome costs, optimize the organization, and respond to changing needs. This innovative executive session is designed to showcase the benefits of the full integrated Microsoft platform.
  https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&eventid=1032393582&flag=1
  
  

Share this post :

Another excellent year at TechEd!  After all these years, I still enjoy the lengthy, opinionated and inebriated conversations over technologies, implementations, products, etc.

I did make it to a few interesting sessions and spoke to a few 'official' types about various things ASP.Net MVC, Velocity, Unity, Oslo, etc...  The presentation I actually enjoyed the most was Andrew Connell's 'Don't be a Tool...' SharePoint dev talk...really good stuff from an outstanding presenter.  I was just happy to hear someone actually tell developers to be developers again and quit whining...this could turn in to a <rant/>...I'll stop now.

As usual, the most interesting stuff happens after hours ;-P  Every year I say I'm going to capture more evidence, but I always forget to take pictures...here's the few I ended up with this year.  It was great to see all my old friends and meet quite a few new ones.  I love all of you nerds.  Big props to the Fl crew for organizing the ]inbetween[ event.  And oh, btw, before I forget....SHAREPOINT NATION!!!

Share this post :

@alanstevens has organized a Meetup of tweeps, twitters and the like...see you there...

Info/links on Allan's Blog

Share this post :

May 1st

Register --> MS Launch Event - Heroes Happen

The Nashville Visual Studio .NET User Group Leadership will be staffing the INETA booth, so stop by for a visit.  I'll be there...and you should all buy me drinks afterwards! ;-)

Someone ask me about working with dates recently in TSQL...I was too busy at the time to stop and remember this...I did get back to them later ;-)

Here it is. I'm sure most people know this, but at least I want forget next time...

DECLARE @CurrentDateWithTime datetime

DECLARE @CurrentDateZeroTime datetime

DECLARE @TomorrowZeroTime datetime

SET @CurrentDateWithTime = GETDATE()

SET @CurrentDateZeroTime = CAST(FLOOR(CAST(@CurrentDateWithTime AS float)) AS datetime)

SET @TomorrowZeroTime = CAST(CEILING(CAST(@CurrentDateWithTime AS float)) AS datetime)

PRINT @CurrentDateWithTime

PRINT @CurrentDateZeroTime

PRINT @TomorrowZeroTime

Why does it work? Add the following PRINT statements and it becomes obvious.

PRINT CAST(@CurrentDateWithTime AS float)

PRINT CAST(@CurrentDateZeroTime AS float)

PRINT CAST(@TomorrowZeroTime AS float)

The output should be :

Mar 26 2008  6:22PM

Mar 26 2008 12:00AM

Mar 27 2008 12:00AM

39531.8

39531

39532

I won't make this a long,drawn-out rant, but I have to vent (just for peace of mind)...
I actually saw the following in code recently :

if("A Literal String".ToUpper() == someRandomVariable.ToUpper()){...}

and

string vbcrlf = "\r\n";

How/When will development on the Microsoft platform ever mature to the point where any bozo who can spell his name and have a conversation with a recruiter will not be allowed to actually create code on real software systems?

I know the dream is that creating LOB systems/applications becomes as easy as using an iPOD, but, for god's sake, we're not there yet.  STOP IT!  You actually do have know more than simple syntax to do this job!

Oh...here's another one...
I just found a situation on a SQL server:  In true Microsoft DBA fashion, a bozo had set the log file initial size for a particular database to the exact size of the physical drive it was located on - and had it configured to auto-grow by 10% !

okay...I'm calming down now...see the the daily WTF for more evidence that our industry is a mess.  I can't believe I've reached the point that I hate hobbyist...in the past I had a great deal of respect for the hobbyist programmers...now they all have programming jobs, but no clue.  I created an excel macro once, so I should be qualified to design your fulfillment system....jeez!!!

This was from an email I sent to some peeps for a quickie how-to...I was told that this kind of junk was worth posting on a blog.  Of course I want to do my part in cluttering up the world...

DECLARE @x as xml
SET @x = '<test att="1">
                  <node1 att="test att val node 1">test data 1</node1>
                  <node1 att="test att val node 2">test data 2</node1>
              </test>' --query a node set like a table
SELECT xd.rows.value('(.)','nvarchar(50)') AS result
FROM   @x.nodes('/test/node1') xd(rows)
--WHERE xd.rows.value('(.)','nvarchar(50)') LIKE '%test data 1'--to get values of attributes and nodes
select @x.value('(/test/@att)[1]', 'int' )--select @x.value('(/test/node1/@att)[1]', 'nvarchar(50)' )
--select @x.value('(/test/node1/@att)[2]', 'nvarchar(50)' )
select @x.value('(/test/node1)[1]', 'nvarchar(50)' )
--select @x.value('(/test/node1)[2]', 'nvarchar(50)' ) --to get nodes/sections/sets/doc fraagments
select @x.query('test/node1')

FYI, the way to dynamically create the xPath statement : use sql:variable to amend the xPath statement - if you try string concats you'll find this out ;-)