Andrew Karcher's Bits o' Data

in
SoCal Rock 'n' Roll Code Camp - Call For Speakers

Have you attended one of the previous 9 Code Camps and said to yourself that you would like to try and give speaking a try?  Are you interested in giving back to the SoCal Technical Community?  Now is your prefect opportunity!  The Code Camp Website for the 4th Code Camp at Fullerton on January 24th & 25th is up and we are looking for speakers and that means you. 

Who is speaking at Code Camp? YOU are, YOUR PEERS are, and YOUR LOCAL EXPERTS are…all are welcome! This is a community event and one of the main purposes of the event is to have local community members step up and offer some cool presentations! Don’t worry if you have never given a presentation before, we’ll give you some tips if you need help, and this a great opportunity to spread your wings.

Anyone from an experienced speaker to first time speaker are welcome and encouraged to come out to speak.  Code Camps rely completely on YOU the community to come out and help support the Code Camp.  Go out to the Code Camp Website http://www.socalcodecamp.com and submit your sessions. 

I am really looking forward to seeing everyone at the Code Camp and being a speaker alongside all of you.  Feel free to ping me via the contact form if you are interested in speaking and have any questions.

Cheers!

Free Windows FireStarter Event - Friday, Dec 12th!

Are you curious about all the latest and greatest information about developing on Windows?  If so, Mithun Dhar is hosting another FireStarter Event up in Redmond on Friday, December 12th.  And the best part about this event is that everything is going to be streamed for FREE through Live Meeting.  So you do not have to leave the 75 degree weather (at least for me in San Diego) to head up to Redmond for the event. 

He has lined up a great speaker list along with some great sessions.  Even a little Windows 7/ Server 2008 R2 teaser session.  For all the details check out Mithun's post:

http://blogs.msdn.com/mithund/archive/2008/11/18/windows-firestarter-dec-12th-friday.aspx

Hope to see you there, virtually anyway.

Free SQL Server 2008 E-Book

SQL Server gurus Peter DeBetta, Greg Low and Mark Whitehorn just released a new E-Book on SQL Server 2008 through MSPress and it is now available online.  And the best part about it is that it is FREE.  You can download the E-Book by going here: http://csna01.libredigital.com/?urss1q2we6.

Fall Tech Day by the San Diego .Net User Group

Are you a developer in the SoCal region that is interested in learning about some of the new technologies, the San Diego .Net User Group is hosting a Fall Tech Day featuring Jeffrey Palermo and Daniel Egan.  Jeffrey Palermo will giving a 1/2 day session on the ASP.Net MVC Framework to start the day. Jeffrey is a Microsoft MVP, INETA speaker and certified Agile Development expert.  He is also the author of the upcoming ASP.Net MVC in Action book.

In the afternoon, Daniel Egan, . INETA speaker, MVP and Microsoft Regional Director, will be giving everyone an overview of LINQ.  This is one technology that as a developer you will need to be up to speed on as all future data access technologies are integrating LINQ. The second speaker in the afternoon will be myself giving an overview of the new developer features in SQL Server 2008.

This is going to be an content filled day for any developer.  If you are interested in attending you can access the registration site here: https://www.123signup.com/event?id=tryjn

Look forward to seeing some of you there.

Setting up Reporting Services on Windows Vista

In the past I have tried setting up Reporting Services on Windows Vista with no success and always reverted to Windows XP.  Well I finally had to get this working and, of course, found some help on the web.  So I had to install both 2005 and 2008 so I got to have fun with both.

After installing SQL 2005, everything seemed to be fine.  However, opening up Report Manager left me with a page with only the Header and no ability to add folders or manage anything.  Luckily I found this article on TechNet that helps you get around this very problem.  http://technet.microsoft.com/en-us/library/ms159704.aspx#VistaAdmin.  Once I got that setup Reporting Services 2005 is all happy and I can open IE without having to Run As Administrator

So on to SQL 2008.  Since I was running side-by-side, I setup SQL 2008 to run as Named Instance "SQL2008".  So I install with the default configuration and after the install I fire up the Reporting Services Configuration Manager.  And I get this very helpful error "No Report Server Found - Invalid Namespace".  Hmm. Well let's see what we can find about this one.  Luckily I found this blog entry by Justin King.  Once I went through all the steps the Configuration Manager correctly saw my Report Server so I was pass that roadblock.   The last step was to apply the TechNet instructions above as well for SQL 2008

So I am now the proud new owner of Reporting Services Instances on Vista for SQL 2005 and SQL 2008.  Hope this helps someone else struggling through the same problem.

New SQL Server User Group in Orange County - First Meeting on 8/14/2008

For all my Orange County readers you might be excited to know that you now have another great option for getting your SQL content.  Reza Madani is starting a new Orange County SQL Server Users Group and their first meeting is this Thursday, August 14th.  Plus, they are bringing in a heavy hitter for their first meeting in the form of Lynn Langit giving a presentation on Business Intelligence in SQL Server 2008.  Here are all the details for the meeting:

SQL Server User Group SIG:

Date/Time:    

August 14th, 6:00PM

Presenter:

Lynn Langit, Author, Business Intelligence Expert, Microsoft Certified and Evangelist

Topic:

Business Intelligence with SQL Server 2008

Location:

Microsoft Offices, 3 Irvine Plz, Irvine, CA 92614

Meeting Agenda:

    * 6:00p Mixer/Networking/Pizza
    * 6:30p Presentation Starts
    * 7:15p Break
    * 7:30p Presentation Resumes
    * 8:45p Raffle

Session Abstract:
In this demo-filled session, Lynn will explain architectural considerations around implementation of OLAP cubes and Data Mining models using the SQL Server 2008 product stack. Here she will demonstrate SSAS, SSIS and SSRS. Her talk will include research for her new book, along with lessons learned from the real world (from her previous practice as BI architect).

Presenter Bio:
Lynn Langit is a developer evangelist for Microsoft. In addition to presenting information about new .NET developer technologies, such as WCF, LINQ and Silverlight, Lynn speaks about SQL Server Data Warehousing and Data Mining. She also speaks about SharePoint. She has been a Microsoft Certified Trainer for 9 years and holds these certifications: MCP, MCT, MCSD, MCSE, MCDBA, MCITP (SQL Admin/Dev/BI) and MSF. In April 2007 Lynn published “Foundations of SQL Server 2005 Business Intelligence (APress)” and plans to publish “Smart Business Intelligence Solutions with SQL Server 2008” in November 2008.

San Diego Code Camp Resources

Wow!  San Diego Code Camp was awesome!  Over 300 people over two days, 90 Sessions, Free Geek Dinner, Awesome Music, what a weekend.  Big plug to my co-organizers Woody Pewitt, Daniel Egan and Mark Rosenberg.

I wanted to get my slides and sample code for all my talks.  Luckily, my voice lasted through all three sessions.  It died shortly there after and was pretty rough all weekend.

You can find all my sample code and slides below.

Into to the ADO.Net Entity Framework

We had a good crowd for this one.  People were dragging in chairs from other rooms to make up for the lack of seats.  It is obvious that everyone is interested about the topic and we had a lot of good discussion.  I hope everyone came out of the session with a beginning understanding of the Entity Framework and encouraged to learn more.

Slides: http://shrinkster.com/zz0

 

SQL 2008 New Data Types

Another capacity crowd.

Slides and Sample Code: http://shrinkster.com/zyz

 

SQL 2008 Policy Based Management

A little bit smaller crowd, but was definitely the most interactive session of the day.  Lots of good discussion about implementing PBM and lots of interest among the attendees.  It seems like a feature that has kind of flown underneath the radar, but I think will be really useful of SQL Server Environments.

Slides: http://shrinkster.com/zyy

 

All in all, a great weekend and I am looking forward to up coming Code Camps in L.A. and San Luis Obispo.

SharePoint Developer Resources

If you are interested in SharePoint Development there are a couple interesting items care of Lynn Langit's blog.  We recently had a SQL Server FireStarter event here in SoCal a few weeks ago.  Keeping the Fire going Mithun Dhar is hosting a SharePoint FireStarter event on Wednesday, June 11th up in Redmond.  Can't attend the event in person?  You are in luck all the events will be broadcast via Live Meeting.

Register for the In Person Event

Register for the Live Meeting

In addition, there is a new website dedicated to building applications on SharePoint.

Enjoy!

SQL Server 2008 is the owner of a brand new Logo!

They announced at Tech-Ed this week that SQL Server 2008 is the owner of a brand new logo.

 

 

I am liking the new "dynamic grid symbol" that will be used on products in the Server and Tools Division.  Check out the Data Platform Insider post for more info on the larger branding strategy using the grid symbol

Slides from SQL Firestarter Event

It has been a really busy couple weeks, so my apologies for getting these slides up a little late.  The Firestarter event has a great turnout.  You can find all my content here:

SQL 2008 New Data Types

SQL Server Reporting Services

It was a great event, so a big thanks to Lynn, Joey and Stephen for helping to organize the event.

I am going to be on MSDN geekSpeak!

If you are interested in talking about SQL Server 2008, be sure to tune in on Wednesday, June 4th when I will be a guest on MSDN geekSpeak with Lynn Langit and Mithun Dhar.  We will be talking about some of the new features of SQL Server 2008 and taking your questions.  Hopefully, we will be able to answer all them as well.  I am really excited to able to participate in the event.  Be sure to tune in at 12pm if you are interested in SQL 2008 development.

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 with Andrew Karcher (Level 200)

Southern California Events

There are a bunch of really great events coming up in the Southern California region that I wanted to get on everyone's calendar if they are not already.

SQL Firestarter Learning Event

This event will be held on Saturday, May 17th at the Microsoft MTC up in Irvine.  Registration still looks like it is open.  I would register soon as there are a limited number of attendees for this event.  If you are Developer or IT Pro for SQL Server there are some great sessions at the event.  There are also some great (wink, wink) speakers at the event.  Get more info and register here: http://www.firestarterevents.com/

Team System Education Day

The San Diego .Net User Group is proud to be hosting Chris Menegay from Notion Solutions for our Team System Education Day taking place on Saturday, May 31st at the AMN Healthcare Conference Center.  This will be an all-day session dedicated to giving you the education you need to know about Team System.  You will be walking away from this conference with a wealth of knowledge about Team System.  The price for the conference includes Continental Breakfast, Lunch and snacks throughout the day.  There is something here for developers, testers, and architects alike.  If you are doing any team development you will want to attend this conference.  Get more details and register here: https://www.123signup.com/event?id=tjnyb

SoCal Rock & Roll Code Camp

Make your plans now to attend the latest and greatest version of the SoCal Rock & Roll Code Camp to be held on June 28th-29th on the UCSD Extension Campus in La Jolla.  There is always an impressive lineup of speakers and a wonderful variety of topics.  Also, there is also an awesome Geek Dinner on Saturday night featuring great food and live Rock and Roll.  Be sure to sign up and attend.  Also, if you are interested in speaking sign up to deliver a session.  It is fun and educational, and you are helping support the local technical community.  You can get more information here: http://www.socalcodecamp.com.

Honored to be joining such an Elite Group

I am honored to have been chosen as a SQL Server MVP for the upcoming year for my work in the SQL Server Community.  When I look at the list of MVPs I am truly humbled to be joining their company.  I am looking forward to joining them in a couple weeks at the MVP Summit up in Seattle.  Participating in your local communities is such a great and rewarding experience, I would recommend that everyone look for ways that they can contribute to their own communities.

I am also looking forward to Partying with Palermo

Party with Palermo
Rock and Roll Code Camp Recap

First things first, hats off to the wonderful team that put together the Code Camp again this year in Fullerton.  Many thanks to Woody Pewitt, Michele Leroux Bustamante, Daniel Egan and Mark Rosenberg for a great Code Camp in Fullerton.

I came up from San Diego to give a talk on Delivering Data with SQL Reporting Services.  This is obviously a topic that has a ton of interest as there were about 45 people in the room and there were a lot of great questions.  For those of you that were at the session, or had a conflict with another session you can download the slides and code HERE

There was one example that we were not able to get to that I thought might be interesting showing a bit more regarding the power and flexibility of drilling through to other reports.  There is an alternate report for the last example that uses a calculation to dynamically calculate a range and send via parameters to the drill through report.  They are the same reports, but with the filename suffixed with RangeParam.

There were a bunch of questions that I will answer in follow up posts within the next week.  I wanted to get the slides and sample code out to everyone as soon as I could.

If you were at the session or not, feel to send me any questions via the contact form.  Looking forward to the next Code Camp in June in San Diego.

The West Coast Code Trip

So the local Developer Evangelists out here on the West Coast managed to somehow get marketing and their bosses to approve The Code Trip.  The idea is that our esteemed Evangelists will be packing up and going around and visiting 28 cities traveling around in a pimped out RV spreading cheer and good tidings to developers along the way. Sounds like a recipe for some very interesting podcasts, blogging and demos along the way.

They are still in the planning phase so if you want them to come to your city (or avoid it ;-) ) let them know by submitting your ideas via the website.  You can also subscribe to their RSS Feed.

As for ideas, their definitely needs to be a stop in San Diego which happens to be right across the border from Tijuana.  I wonder what the border agents would think of this thing rolling across the border.  I am sure you can follow each of the evangelists individually as well via their respective blogs:

More Posts Next page »