Andrew Karcher's Bits o' Data

SQL Saturday #44 – Huntington Beach – Recap

akarcher — Thu, 29 Apr 2010 19:17:13 GMT

What a great day. It was long and tiring, but rewarding in so many ways. On Sunday morning, I was driving home and I decided to take the Pacific Coast Highway from Huntington Beach. It was a great chance to exhale and just enjoy the sun and smells of the beach (I really love SoCal sometimes). And for future reference for all you speakers, the beach and ocean are only 5 minutes from the SQL Saturday location.

I just could help noticing also the shocking number of high priced cars on the road (4 Bentleys, 3 Ferraris, 1 Aston Martins, 3 Maserati, 1 Rolls Royce, and 2 Lamborghinis). It made me think about this: Price of all those cars: $ 150,000+. Impacting the ability of people to learn: Priceless. We have positively impacted the education, knowledge, capabilities of not only our attendees, but also all of their companies and people they might help as well. That is just staggering and something to be immensely proud of. To all of my fellow community leaders, I salute you.

So let’s talk about the event

Overall

We had over 220 people register for the event and had 180+ people attend the event. I was shooting for the magical 200 number, but I guess it just gives us more motivation to make it even bigger and better next time. We had a few snags along the way, but what event doesn’t, but I think everything turned out great. I did not hear any negative comments and heard lots of positive comments along with people asking when the next one is going to be (More on that later).

Location- Golden West College

We could not have asked for a better partner for the event. Herb Cohen from Golden West College was the wizard behind the curtains. From the beginning, he was our advocate to the GWC Board and was instrumental in getting our event approved. The day off, Herb was a HUGE help getting any and all logistics that we needed taken care of. In the craziness of the early morning registration crush it was a big help knowing that he and Bret Stateham (Blog | Twitter) were taking care of testing projectors in all the rooms. Anything we needed he was there and was even proactive in getting some things that I had not even thought of (i.e. a dumpster for all of our garbage). I cannot thank Herb enough along with other members of the GWC staff including Minnie Higgins of the Career and Technical Education Division office, Jack Taylor, public safety, and Ron Pryor, Tech Services Support. And last, but not least, the Wireless on campus was absolutely FANTASTIC!

Some lessons learned

Unless you are a glutton for punishment, as I no doubt am, you most certainly want to give yourself more than six weeks to plan the event. I am lucky that I have a very understanding wife and had a wonderful set of co-coordinators helping me out. A big thanks goes out to Phil, Marlon (Blog | Twitter), Nitin (Twitter), Thomas (Blog | Twitter), Bret (Blog | Twitter), Ben, and Laurie. Thankfully, the sponsor and speaker community was hugely supportive and we were able to fill out the entire event with speakers and sponsors.

I have to say that there is not a lot that I would change after this year’s event. There are obviously going to be some things that we can do better or differently next time, but overall I think it was a great event and I was more than happy with the response we received from the community.

Sponsors

We obviously could not have put together our event without our sponsors. So certainly have to show them some love.

Platinum Sponsors

Quest Software – h ttp://www.quest.com
My Space – http://www.myspace.com/

Gold

Strategy Companion – http://www.strategycompanion.com

Silver

Fusion-IO – http://www.fusionio.com

Bronze

WestClinTech – http://westclintech.com
Professional Association For SQL Server – http://www.sqlpass.org
Attunity – http://www.attunity.com
Sharepoint 360 – http://www.sharepoint360.com

Some additional Thanks

Andy Warren (Blog | Twitter)

Always there to answer my question and help out when I had some issues or questions with the website. The amount of work that he and everyone else put into SQL Saturday is very amazing. What a great gift to the community!

Einstein Bros. Bagels

They were our Breakfast Vendor and arrived perfectly on time with yummy bagels, sweets and most importantly coffee.

Lucci’s Deli (http://www.luccisdeli.com)

Lucci’s was out Lunch Vendor. They were great to work with and the food was excellent. They worked with us to give us a great price. Heard lots of great comments about the lunches. Definitely not your ordinary box lunch.

Moving Forward

Unfortunately, the work does not end after the event. We have a few things to clear up such as surveys, sponsor stuff, presentations uploaded to the website, expense reimbursement, stuff like that. Hopefully, all that should be cleared up within the next couple weeks. After that as a group we are going to get together and decide what our next steps are. We definitely want to keep some of the momentum that we are building as a SQL Community and channel that into future SQL Saturdays and other types of community events.

In the meantime, for additional training be sure to check out your local User Group and PASS.

San Diego SQL Server Users Group ( http://www.sdsqlug.org/home/index.cfm )
Orange County SQL Server Users Group ( http://www.sqloc.com/ )
L.A. SQL Server Users Group ( http://www.sql.la/ )
SQL PASS ( http://www.sqlpass.org/ ) – 24 Hours of PASS ( http://www.sqlpass.org/24hours/2010/ )

So stay tuned, there will be more events to come in SoCal!!

Building KPIs to monitor your business – It’s not really about the Technology

akarcher — Tue, 09 Mar 2010 07:47:05 GMT

When I have discussions with people about Business Intelligence, one of the questions the inevitably come up is about building KPIs and how to accomplish that. From a technical level the concept of a KPI is very simple, almost too simple in that it is like the tip of an iceberg floating above the water. The key to that iceberg is not really the tip, but the mass of the iceberg that is hidden beneath the surface upon which the tip sits.

The analogy of the iceberg is not meant to indicate that the foundation of the KPI is overly difficult or complex. The disparity in size in meant to indicate that the larger thing that needs to be defined is not the technical tip, but the underlying business definition of what the KPI means. From a technical perspective the KPI consists of primarily the following items:

Actual Value – This is the actual value data point that is being measured. An example would be something like the amount of sales.
Target Value – This is the target goal for the KPI. This is a number that can be measured against Actual Value. An example would be $10,000 in monthly sales.
Target Indicator Range – This is the definition of ranges that define what type of indicator the user will see comparing the Actual Value to the Target Value. Most often this is defined by stoplight, but can be any indicator that is going to show a status in a quick fashion to the user. Typically this would be something like: Red Light = Actual Value more than 5% below target; Yellow Light = Within 5% of target either direction; Green Light = More than 5% higher than Target Value
Status\Trend Indicator – This is an optional attribute of a KPI that is typically used to show some kind of trend. The vast majority of these indicators are used to show some type of progress against a previous period. As an example, the status indicator might be used to show how the monthly sales compare to last month. With this type of indicator there needs to be not only a definition of what the ranges are for your status indictor, but then also what value the number needs to be compared against.

So now we have an idea of what data points a KPI consists of from a technical perspective let’s talk a bit about tools. As you can see technically there is not a whole lot to them and the choice of technology is not as important as the definition of the KPIs, which we will get to in a minute. There are many different types of tools in the Microsoft BI stack that you can use to expose your KPI to the business. These include Performance Point, SharePoint, Excel, and SQL Reporting Services. There are pluses and minuses to each technology and the right technology is based a lot on your goals and how you want to deliver the information to the users. Additionally, there are other non-Microsoft tools that can be used to expose KPI indicators to your business users.

Regardless of the technology used as your front end, the heavy lifting of KPI is in the business definition of the values and benchmarks for that KPI. The discussion about KPIs is very dependent on the history of an organization and how much they are exposed to the attributes of a KPI. Often times when discussing KPIs with a business contact who has not been exposed to KPIs the discussion tends to also be a session educating the business user about what a KPI is and what goes into the definition of a KPI. The majority of times the business user has an idea of what their actual values are and they have been tracking those numbers for some time, generally in Excel and all manually. So they will know the amount of sales last month along with sales two years ago in the same month. Where the conversation tends to get stuck is when you start discussing what the target value should be.

The actual value is answering the “What” and “How much” questions. When you are talking about the Target values you are asking the question “Is this number good or bad”. Typically, the user will know whether or not the value is good or bad, but most of the time they are not able to quantify what is good or bad. Their response is usually something like “I just know”. Because they have been watching the sales quantity for years now, they can tell you that a 5% decrease in sales this month might actually be a good thing, maybe because the salespeople are all waiting until next month when the new versions come out.

It can sometimes be very hard to break the business people of this habit. One of the fears generally is that the status indicator is not subjective. Thus, in the scenario above, the business user is going to be fearful that their boss, just looking at a negative red indicator, is going to haul them out to the woodshed for a bad month. But, on the flip side, if all you are displaying is the amount of sales, only a person with knowledge of last month sales and the target amount for this month would have any idea if $10,000 in sales is good or not.

Here is where a key point about KPIs needs to be communicated to both the business user and any user who might be viewing the results of that KPI. The KPI is just one tool that is used to report on business performance. The KPI is meant as a quick indicator of one business statistic. It is not meant to tell the entire story. It does not answer the question “Why”. Its primary purpose is to objectively and quickly expose an area of the business that might warrant more review. There is always going to be the need to do further analysis on any potential negative or neutral KPI.

So, hopefully, once you have convinced your business user to come up with some target numbers and ranges for status indicators, you then need to take the next step and help them answer the “Why” question. The main question here to ask is, “Okay, you see the indicator and you need to discover why the number is what is, where do you go?”. The answer is usually a combination of sources. A sales manager might have some of the following items at their disposal (Marketing report showing a decrease in the promotional discounts for the month, Pricing Report showing the reduction of prices of older models, an Inventory Report showing the discontinuation of a particular product line, or a memo showing the ending of a large affiliate partnership. The answers to the question “Why” are never as simple as a single indicator value.

Bring able to quickly get to this information is all about designing how a user accesses the KPIs and then also how easily they can get to the additional information they need. This is where a Dashboard mentality can come in handy. For example, the business user can have a dashboard that shows their KPIs, but also has links to some of the common reports that they run regarding Sales Data. The user’s boss may have the same KPIs on their dashboard, but instead of links to individual reports they are going to have a link to a status report that was created by the user that pulls together all the data about the KPI in a summary format the user’s boss can review.

So some of the key things to think about when building or evaluating KPIs for your organization:

Technology should not be the driving factor
KPIs are of little value without some indicator for whether a value is good, bad or neutral.
KPIs only give an answer to the “Is this number good\bad?” question
Make sure the ability to drill into the “Why” of a KPI is close at hand and relevant to the user who is viewing the KPI.

The KPI is a key business tool when defined properly to help monitor business performance across the enterprise in an objective and consistent manner. At times it might feel like the process of defining the business aspects of a KPI can sometimes be arduous, the payoff in the end can far outweigh the costs. Some of the benefits of going through this process are a better understanding of the key metrics for an organization and the measure of those metrics and a consistent snapshot of business performance that can be utilized across the organization. And I think that these are benefits to any organization regardless of the technology or the implementation.

Utilizing Custom Fonts with SQL Reporting Services (SSRS) and Exporting to PDF

akarcher — Mon, 18 Jan 2010 08:41:08 GMT

I recently had a unique challenge with SSRS which was the utilization of a Custom Font on an SSRS Report. Normally, I do not think about fonts other than what get installed as system fonts in Windows so this was a fairly new experience. I know a few people who REALLY enjoy fonts in the Design Practice at Clarity, but had never considered the impact and usefulness they can play in SSRS. It was somewhat difficult to find information about this so I figured I would summarize to save some other people some trouble.

The report that I had to develop was going to be a customer facing report so there were some fairly exact standards that it needed to comply with both from an aesthetic and regulatory perspective, much more so than most SSRS reports which are generally for internal consumption only. As an idea of some of the requirements take a look at a statement from your cell phone provider, local utility or television provider, and that is similar to what I had to build. If you have never looked very closely at something like that you probably have missed the sheer amount of different fonts, font sizes, font weights, font decorations, and so on that is used in building that statement. Some of the formatting is done based on aesthetics and some is also based on regulations, such as minimum font sizes for those disclaimers that you can barely read on the statement.

So before I get into the nuts and bolts of this, I need to give a shout out to Andre Milbradt from the SSRS team who was very helpful in clearing up some of the confusion out there for me on font embedding and the PDF Renderer.

Before we get into SSRS, let’s go into a bit about the different types of fonts out there (Reminder: I am not a Font guy). There are two major types of Fonts out there: True Type (wiki: http://en.wikipedia.org/wiki/True_Type_Font ) and Open Type (wiki: http://en.wikipedia.org/wiki/OpenType). Of these two, SSRS fully supports True Type Fonts and has limited support for Open Type Fonts. Essentially, any Font that can be instantiated by the .Net System.Drawing.Font (http://msdn.microsoft.com/en-us/library/system.drawing.font.aspx) class is supported by SSRS. Because the custom font that we needed was available as both a True Type Font and an Open Type Font, we went with the True Type font since we knew that it would be fully supported.

So we went ahead and installed the fonts on the developer machine and the SSRS server. On the development machine, you do have to restart Visual Studio after you install the fonts for Visual Studio to pick up on the font. On the server, we were having issues with SSRS picking up the newly installed Font until we restarted the Reporting Services Server. We probably could have just restarted SSRS, but we ended up just restarting the server. If you have never installed a font before (I hadn’t before this project) you can get to the installed fonts by going to Control Panel -> Fonts. For Windows XP and above you can just copy and paste the font files into this directory. For Vista and above, one of the right-click options on the .ttf font file is “Install”.

I first started developing the report in SSRS 2005, using my custom font and it all looks good. Then I try to export to PDF for the first time and “Uh-Oh”. That doesn’t quite work. And after a bit of research and some verification from the PG team, SSRS 2005 does have limited support PDF Font Embedding, but it is limited to Unicode Data. You can check out the Books Online here (http://technet.microsoft.com/en-us/library/ms159713(SQL.90).aspx) about the behavior in SSRS 2005. You can also check out this post from Robert Bruckner (http://blogs.msdn.com/robertbruckner/archive/2008/10/27/unicode-in-pdf-font-embedding.aspx ) on the feature in SSRS 2008 CU1, which is the same feature that was also added SSRS 2005 in SP3. So since I was using ANSI text data, it was on to SSRS 2008.

So I started looking at Books Online for SSRS 2008 and noticed the same restrictions on Font Embedding in PDF as there are in SSRS 2005. If you take a look at the same topic for SSRS 2008 (http://technet.microsoft.com/en-us/library/ms159713(SQL.100).aspx) in the Font Embedding section it still lists the following as a restriction, “The characters in the string that has the Font property set are Unicode, not ANSI. No font embedding occurs for ANSI characters.” After confirmation from the product group, this is incorrect and a User Education bug was submitted to have this documentation fixed. So with that out of the way and we had confirmation that SSRS 2008 will embed fonts within a generated PDF, we developed our report.

At this point I want to remind you to restart the server after installing your font, because I forgot my own rule to restart the server after installing fonts and was pulling my hair out at one point.

So after you have developed and deployed your report, you export to PDF and want to verify that your Font got embedded. There are a number of ways to do this. First, check the properties of the PDF. In Acrobat Reader, go to File->Properties and then click on the Font tab. There should be a listing of Fonts there which should include your custom font. Second, send the PDF to someone who does not have the Font installed. They should see the new custom font as well in their PDF. Lastly, if your custom font is not obvious, having a nice trained designer eye is the best tool you can have to verify the font for you.

So hopefully this post clears up some confusion on custom fonts and Font Embedding with the PDF Font Renderer.

Someone call a Weatherman, the Clouds have shifted

akarcher — Wed, 11 Mar 2009 15:39:36 GMT

In a move that I think is great from feature perspective, the SQL Server Data Services team has made important changes to the SQL Data Services feature. Essentially, the team is moving away from the name\value pair implementation that was released with CTP 1 and is moving to a full relational database model. You can read the announcement on the SDS blog HERE.

I am VERY excited at this announcement and I think this opens up SQL Data Services to being utilized for a whole host of applications without changing your applications. That being said there is going to be a limited set of functionality that you will be able to do in the cloud, but your core SQL Server functionality is going to be there. It will be very interesting to see how this evolves as more information comes out at MIX.

Enjoy!

Roundup (2/15) – Things you might find interesting…

akarcher — Sun, 15 Feb 2009 20:17:49 GMT

So I see all these great posts during the week and I think, “I wonder if everyone else is seeing this post, this is good stuff”. Usually, I read it, file it away and think, “Yeah, I blog about it tomorrow”. So here are some posts from the last week or so that I thought were really good that I think you, my readers wherever you are, might find interesting.

Public Speaking – A Primer by Paul Randall
I have heard so many great things about Paul’s talks. Unfortunately,I could not get into any of sessions at last year’s PASS as evidently you have to camp out in the session before to get a seat. This is a great post about public speaking with a lot of good tips in there. One of the best is on eliminating the use of the word “um”. I spent a whole semester in college trying to eliminate that. One item not in the post that I would suggest is to enlist the services of a friend and have them videotape one of your sessions. This can be a somewhat brutal experience sometimes, but trust me it works. My first speech in college, I would have swore I only said “um” a couple times, but the video doesn’t lie. It was something like 40,50 times in a five minute speech or something like that. But, I would have never been able to fix that without seeing it for myself.

'How Do I...BI?' Screencasts by Lynn Langit
Lynn is a great resource when it comes to BI. Her book is really good and she is great and being able to explain things in a way that people can understand. Which is really hard when it comes to things like MDX and Data Mining Algorithms. So go out and buy her book and watch her Screencasts.

SQLCAT Team Whitepapers
The SQLCAT (Customer Advisory Team) team at Microsoft is a great resource for all things SQL Server. They were doing a number of sessions at the SQL PASS Summit last year and these were by far some of my favorite sessions. I learned so much about how SQL Server works and tips and tricks for getting excellent performance out of SQL Server. Well, they must have been cleaning the vault, because they release a trio of excellent resources recently.

Analysis Services 2008 Performance Guide - This white paper describes how application developers can apply query and processing performance-tuning techniques to their SQL Server 2008 Analysis Services OLAP solutions
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - This codeplex solution automates the collection of SQL Server 2008 performance data from any or all of the following data sources and stores the collected data into a single SQL Server 2008 relational database (SQL Server Profiler Analysis Services trace data, Performance Monitor counters, Analysis Services Dynamic Memory Views (DMVs))
The Data Loading Performance Guide 2008 - This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.

Visual Studio Team System for Database Professionals Workshop (Irvine 3/4 & San Diego 3/5) - Visual Studio Team System 2008 Database Edition provides advanced tools for database change management and testing and offers functionality to enable database developers and administrators to be more productive and increase application quality in the database tier. Visual Studio Team System 2008 Database Edition delivers a market shifting database development product that provides a foundation for managed database evolution through the use of an offline, Visual Studio project-centered source code control system together with a suite of tools designed to help understand the impact of proposed changes.

MS Press Book – Understanding Microsoft Virtualization Solutions for FREE! - This guide will teach you about the benefits of the latest virtualization technologies and how to plan, implement, and manage virtual infrastructure solutions. The technologies covered include: Windows Server 2008 Hyper-V, System Center Virtual Machine Manager 2009, Microsoft Application Virtualization 4.5, Microsoft Enterprise Desktop Virtualization, and Microsoft Virtual Desktop Infrastructure. The book also provides insight into the Core Infrastructure Optimization model, and how implementing virtualization technologies can help move a company further along toward the goal of building an efficient, reliable Dynamic IT infrastructure. Simply register at http://csna01.libredigital.com/?urmvs17u33

That’s it for this one. Happy Reading and Enjoy!

Upcoming SoCal Tech Events

akarcher — Sun, 15 Feb 2009 19:22:59 GMT

In a follow up to Lynn Langit’s post here, I figured I would I add the details on the SQL Server Users Group and also add a few other events. I was sad that the Vista for ITPros event was sold out, but I am looking forward to hitting up a couple of the events.

SQL Server Users Group with Lynn Langit
For those interested in the SQL Server Users Group you can check out our website here (http://www.sdsqlug.org/home/index.cfm) and get the details of Lynn’s session here. If you want to sign up for their mailing list it is via a Yahoo group here. The group is really growing and is a great resource for all you Database people. I hope to see some of you there.

TechNet Events: Software-plus-Services, System Center Configuration Manager and Virtual Machine Manager
Thursday, February 26, 2009 8:00 AM - Thursday, February 26, 2009 12:00 PM – Anaheim (Click link to Register)
Tuesday, February 24, 2009 8:00 AM - Tuesday, February 24, 2009 12:00 PM – San Diego (Click link to Register)
These are going to led by Chris Avis.

MSDN Events: Azure, Debugging and Mobility
Thursday, February 26, 2009 1:00 PM - Thursday, February 26, 2009 5:00 PM – Anaheim (Click link to Register)

Architect Council | The Importance of the Client
Over the last couple of years, there has been a lot of innovation around of technologies that make it easier for the end user of an application to interact with systems. This innovation has been a boon for the end user because it has provided them a more natural interface with systems that span the web, computer, and phone. However, this has caused the complexity of systems architecture and development to increase. The focus of this session will be on how to prepare and manage this complexity within your organization.

Facilitated by Microsoft, the premise of this event is to provide an open forum where architects can meet to discuss technologies with their peers. This forum will provide first-hand experience and best practices that will enable its members to learn from each other and transfer knowledge. Please join us for this great opportunity to learn, share and network with your peers and other company leaders.

Facilitated in SoCal by Woody Pewitt and Joe Shirey. For more details and links to register see the posts by Joe Shirey and David Chou. I am looking forward to attending the San Diego version on 3/31.

Look forward to seeing some of you at the events and enjoy!

Performance Point 2007 Roadmap Changes

akarcher — Sat, 24 Jan 2009 03:05:56 GMT

If you have worked with Performance Point Server before this change in strategy is not all that surprising. The product is ( at least the Monitoring and Analytics) is very focused on delivering items via SharePoint. In moving Performance Point Monitoring and Analytics into the SharePoint stack, this functionality is now available to all SharePoint Enterprise customers. And for free assuming you are licensed for SharePoint Enterprise.

Going forward the functionality will be further integrated into the Office stack increasing the inroads of these BI technologies into a large number of users within the enterprise. Here is another post from Russell Christopher on some of the benefits of this announcement.

In my opinion this is a great strategic move by Microsoft to promote these BI technologies in the Enterprise.

Microsoft All-Up BI VPC is available

akarcher — Thu, 15 Jan 2009 06:47:44 GMT

Have you ever thought, "Gee, I would really like to play with some of the cool BI technologies, but I really would rather not go out and install everything". "Plus, I would really not have to try and come up with a bunch of sample data so that I can play with some of the new functionality?"

If you have ever found yourself saying those things then the Microsoft All-Up BI VPC is what you are looking for. You can access the links to download all the parts of the VPC here: (http://performancepointblog.com/2008/12/all-up-bi-vpc-71-available-for-public-download/), I have setup up the VPC and played around a little bit and things seem to be working really well. I will definitely be looking at potentially using this for demos and presentations.

Enjoy!

SoCal Rock 'n' Roll Code Camp is next weekend!

akarcher — Thu, 15 Jan 2009 06:34:54 GMT

Just a reminder to all my SoCal readers out there that the SoCal Code Camp (http://www.socalcodecamp.com) is just around the corner. Next weekend hundreds of your fellow geek enthusiasts will be joining you at one of the best Code Camps out there. There are going to be over 90 sessions over two days to allow you to "geek out" until your heart is content. And not only that, we have an awesome Geek Dinner on Saturday night with live Music.

Remember, that this is all FREE, paid for by the generosity of our sponsors. Be sure to check them out and say thanks for being a supporter of the local Tech Community.

I look forward to seeing you all there.

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

akarcher — Tue, 02 Dec 2008 05:00:48 GMT

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!

akarcher — Mon, 01 Dec 2008 06:37:31 GMT

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

akarcher — Wed, 17 Sep 2008 15:46:44 GMT

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

akarcher — Sun, 14 Sep 2008 22:57:55 GMT

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

akarcher — Sun, 14 Sep 2008 22:17:57 GMT

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

akarcher — Wed, 13 Aug 2008 06:08:48 GMT

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.