Month: September 2010

3rd Annul Back To School Event Presentations

First of all, thanks to everyone whom participated in this year’s event! It was a blast interacting with everyone and see a lot of new faces in the crowd! The event went off very well …and the only issue seemed to be my laptop and the wireless playing nice together….oh well maybe @PerpetualTech will but me a new laptop with solid state drives so I can run everything virtually:)  As always, I had my trusty backup ..my tethered Blackberry non-3G network. This actually worked in my favor because when the questions came about performance of things like SQL Azure and BING maps I could just point to the phone and say….I just pulled down 300 geocode points and put them on a BING map through the phone! The first of my presentations was an overview of CRM 2011. The group was small but asked a TON of questions so obviously people are interested. In retrospect I should have probably got in touch with the local Windows Users Group in order to ensure that they knew about the event. This presentation went well though although I could not demo the Outlook client because for whatever reason my local copy won’t synch with the ‘mothership’ to initialize it. Oh well, I will get it fixed and then maybe work up a couple of webcasts to go over everything in much more...

Read More

#sqlsat50 East Iowa: Post-Mortem

Well, finally back at work after a glorious weekend in Iowa City for the SQL Saturday #50. What a great event! I have to give kudos to the team up there. I had to make a choice about which event I would attend, since there were three actually going on at the same time, and they definitely did not disappoint. They had tons of notable SQL Server people in attendance… Jason Strate – @StrateSQL ( blog | twitter ) , Michelle Ufford – @sqlfool ( blog | twitter ), Ted Krueger – @onpnt ( blog | twitter ) , Jes Borland @grrl_geek ( blog | twitter ), Kathi Kellenberger – @auntkathi ( blog | twitter ), Bob Pusateri – @SQLBob ( blog | twitter ) , Kendra Little – @Kendra_Little ( blog | twitter ), Louis Davidson – @drsql ( blog | twitter ) ..OKAY THAT’s enough …..if I left anyone that I met off then I am sorry…please add your taglines to the comments section…my little fingers are cramping up here! Anywho, it was a great time and the event organizers pulled it off without a hitch! So if you were in the area … and you slept in on Saturday…. or spent the day roaming around in your PJs …then it was your loss. Just look what came across the ol Twitter channel this morning… I had...

Read More

Why #SQLSaturday Matters

I remember when I got out of the academia scene(physics) and started working for the federal government. My position was one that required me to be an active member of the military so part of the gig was that you had 2 weeks worth of training that you had to complete each year. My first year I picked out a conference I had found called DevConnections in Orlando, FL. and figured it would be kind of like a boot camp type of training event. My first day consisted of signups for the event prior to the pre-conference. Standing in line a young guy from Israel asked me what sessions I was going to. So we started talking and got into what each of our work lives was like and what it was like in Israel compared to the USA. So here I was talking with someone halfway around the world and it was like we worked in the same office. Hooked! The next day was Microsoft day and since I was in charge of Microsoft development and database architecture I definitely wanted to join. My main goal was to figure out what path I needed to get on in order to get my DoD group on the beta test groups for Visual Studio and SQL Server. So I attended a session with Scott Guthrie ( Blog | Twitter )...

Read More

SQL Server Reporting Services 2008 R2: Lookup Fields!

Well, I promised the XRM Virtual Users Group ( website | twitter ) and Julie Yack ( blog | twitter ) that I would provide them a blog of an example of using the Lookup feature in SQL Server Reporting Services 2008 R2….well, that time has come. I will throw out the caveat that I have been ill all day and am now under the heavy influence of, my friend, Mr. Nyquil. So if the post seems kind of disjointed then you will understand why. So to start out with I am going to just create a simple Reporting Services project with a shared data source to the AdventureWorksLT database. Nothing fancy here. However, please note that I could have 2 separate data sources pointing to 2 totally different databases. I am just trying to keep things simple here for demonstration purposes. So now let’s create a report with a couple of datasets in it. We are going to pretend that we have Sales information in one database while we would have all of our Customer information in another database. So I will create one dataset for Sales based off of the SalesLT.SalesOrderHeader table and the other one of Customer details off of the SalesLT.Customer and associated tables. Nothing crazy going on here. So now the problem is that since the data for the customers is in a totally...

Read More