SQL Server

Ask An Expert Live Chat: May 1st, 2008

That's right!  We're having another ASP.NET Expert Live Chat on Thursday, May 1st, 2008 at 6 PM PST.  Here's more info on the event: Get your tough development questions answered by Microsoft MVPs, Regional Directors, and other industry experts. Community experts will be on hand to answer your .NET- and Visual Studio-related questions. No off topic questions please. Please note that questions regarding upcoming products and future product specs might not be answered. Would you like to participate as an expert? Contact Ryan Olshan at Ryan[dot]Olshan[at]strongtypes[dot]com. MSDN Online Chats - http://msdn2.microsoft.com/en-us/chats/default.aspx Chat Room...

posted @ Saturday, April 5, 2008 12:47 AM | Feedback (643)

Des Moines HEROES Happen Here Launch Event

That's right, there will be a HEROES happen {here} event in Des Moines on 4/24!    Here's some info on the event: The Des Moines event will celebrate the launch of Windows Server 2008, Visual Studio 2008 and SQL Server 2008. The event will bring together IT Pros and Developers to get an in-depth, up-close look at the new products and will give attendees an opportunity to meet with our Partners as well as members of the development teams who created the cutting-edge technologies. And all attendees will get a promotional pack containing all three new products....

posted @ Friday, February 22, 2008 11:14 PM | Feedback (611)

PDC 2008 Announced

That's right, PDC has been rescheduled to Oct. 27-30 2008 in Los Angeles, California.  Here's the info from their site: PDC 2008 October 27–30, 2008 Pre-conference October 26, 2008 Los Angeles, California OK, OK. We are delighted to announce the date and location of the next Microsoft Professional Developers Conference (PDC): October 27–30, 2008 at the Los Angeles Convention Center. PDC is the definitive Microsoft event for software developers and architects focused on the future of the Microsoft platform. Mark your...

posted @ Friday, December 7, 2007 3:18 PM | Feedback (612)

Free eLearning Passes From Microsoft

Denny Boynton, our regional Architect Evangelist, has just blogged information on how you can get free MS eLearning passes valued at $159.  If you have the time, and don't want to miss out on this opportunity, go check out his post.

posted @ Wednesday, April 18, 2007 9:40 PM | Feedback (632)

Thanks, Richard!

Just wanted to thank Richard Hundhausen for taking the time to present to our user group!  The presentation was great!  There were a lot of questions and interactions from the members.  You can check his reflection on the experience here. Today, Nick and I met up with Richard for a bite to eat and some geekin' out.

posted @ Thursday, December 7, 2006 10:03 PM | Feedback (614)

IADNUG Meeting: SQL Server 2005 is for Developers

Come join us tomorrow at our monthly .NET User Group meeting!  We'll have Richard Hundhausen, Team Foundation MVP & RD, present on SQL Server 2005! Also, we'll be discussing on severals ways the UG can get involved in helping keep the memory of Eric Jacobs alive. Hope to see you there!

posted @ Tuesday, December 5, 2006 8:53 PM | Feedback (612)

Design Question: Business Logic

Where does/should it live?  Middle tier (.NET/Java/Other technology) or data tier (SQL Server/Oracle/DB2)? Talk amongst yourselves.  I'm curious to find out what you have to say!

posted @ Wednesday, August 30, 2006 9:45 PM | Feedback (541)

Declarative Polymorphism

Ok, so today I'm working on setting up a simple ASP.NET website to test the new membership and role features.  Well, in order to use the correct database through the ASP.NET configuration site, you have to remove the default registration of the LocalSqlServer connection string and re-add it with the correct database location.  In other words, <system.configuration>  <connectionStrings>    <remove name="LocalSqlServer" />    <add name="LocalSqlServer" connectionString="Server=(local); Initial Catalog=aspnetdb; Integrated Security=SSPI;" />  </connectionStrings></system.configuration> When I told Nick about this needed change, all he could said. "Well, it makes sense. It's Declarative Polymorphism! ;-)"  Another “one-liner” from Nick....

posted @ Tuesday, April 11, 2006 10:54 PM | Feedback (612)

VS Express Editions Free For One Year

That’s right, the title is not wrong.  You can download VS Express Editions free for one year at MSDN.  Dan Fernandez posts more info about this great deal! Go download Happy!  Long live VS2005!

posted @ Monday, November 7, 2005 9:48 PM | Feedback (611)

XML & SQL symbiosis

While looking at this article on MSDN about the new features of ADO.NET 2.0 and SQL Server 2005, I was very pleased that finally we are started to look at XML as an independent technology rather than just data between < >. This article gives a brief show of the new XML SQL Type and how it can be used by client/server applications to make future SQL Server '05-dependent applications even more kick-a**.

posted @ Monday, December 13, 2004 10:51 AM | Feedback (613)

Crosstab Queries in SQL Server

Currently at work,  we are re-writing an Access project (.mdb) to an ADP.  As we battle through the process, we encountered something that's not 'natively' supported in SQL Server...crosstab queries. So, I took some time to research this problem and found out some pretty good resources on achieving 'crosstab-ness' using T-SQL.  The first method is by far the best method...since it's the most mathematically based.  It's called the Rozenshtein Method developed by David Rozenshtein, a Russian mathematician. This method uses the concept of Boolean aggregates so that each column has a numeric expression that resolves each row as a zero or one and...

posted @ Monday, October 11, 2004 8:29 PM | Feedback (614)