Wednesday, January 6, 2010

Dumbing Down a Report Engine? Another Episode of SSRS for SQL 2008 SUX

I never thought I'd say this, but working with SQL Server Reporting Services (SSRS) has taught me a valuable lesson...

It doesn't matter what report engine you use, they all have their quirks.

I have a Crystal Reports background thanks to the ERP system that I used to support. I learned how to work with it inside outside upside down. It got to the point that I knew how to get it to do what I needed, no matter how obscure my end users got with their requests. It was a good thing.

Now I'm in a SSRS environment, and I curse my unfamiliarity with this report builder. I have to keep reminding myself that it's a Microsoft tool - so many options that I'd be looking for in context menus are probably hidden in toolbars. For example, I was looking on doing conditionally-formatted row backgrounds, and I eventually found it in a toolbar - as soon as I reminded myself that it's a Microsoft product.

But then there's this other maddening (lack of a) feature. Why can I create an expression for my tablix's sort field but I can't use an expression to specify the sort order?

And what's this "A to Z" and "Z to A" sorting terminology? Who are they designing this tool for? As a database admin and a developer, I would know ASC and DESC or even ascending and descending. Dates sort on their date type, numeric types in a numeric order... and neither of those are handled the same way as a character sort. Is the report converting all of its data to strings and literally doing a character sort? Nope - it is sorting ascending and descending. Can SSRS get an update so that it accurately represents the sorting? Is it smart enough to possibly detect the data type of a field and show "highest to lowest" for numbers and "earliest to latest" for dates?

As I continue to work with SSRS, I hope my complaints will subside. But there are some quirks that, in my opinion, make it worthy of the SUX appearances.

Labels: ,


Share this post:             kick this!  live it!

posted by Sarah at 2 Comments Links to this post

My Thoughts on the WiT Discussion at SQLServerCentral

After seeing an email and after my friend DeeDee pointed it out to me, I figured I'd comment on this article (requires login) and its discussion on Women in Technology that appeared on SQLServerCentral today.

First of all, it was weird seeing her referenced as "Ada King". In college, I knew who Ada Lovelace was and about her contributions to the computing industry, largely thanks to my Data Structures I professor - Dr. Henry Ledgard - who worked on the Ada project. Then there's the "Ada Lovelace Day" mumblings that I've heard. So I found it weird to see Phil Factor reference her as "Ada King" and not by the name she's commonly known by in the industry.

Second of all, I knew that the discussion related to the article would take the forks like it did because it's a WiT topic, and those viewpoints almost always come out on a WiT post. There was one post in the discussion that caught my attention, and it touched on the following points:

* Not all WiT initiatives are useful. When they exclude men, they're harming things more than helping things.

* WiT gatherings with a "it's tough being discriminated against" approach aren't helpful.

I wholeheartedly agree that excluding men in WiT initiatives is a bad thing. Could it be that guys actually have opinions on women working in tech? Could it be that they're actually more supportive than what some WiT initiatives want us to believe? They may even be catalysts and sources of encouragement for us!

WiT gatherings that are more about sharing the negative experiences really don't get far. They're good at showing that other women have gone through the same headaches as you, and sometimes they're good at showing how to handle certain situations. But overall, negative topics can lead to discouragement, and that's not a goal of any WiT initiative.

This is part of why you don't see many WiT posts from me. I write for technically-minded people - not for a particular gender, race, or creed. I personally hate the gender card and wish it weren't such an issue. Growing up, I didn't see my gender as a problem. I saw it as - "Hey, I was good at this programming stuff in school, and my teachers and my boyfriend really thought I should look into it as career option." Not one of them ever mentioned the gender factor, so I never really considered it an issue.

It wasn't until I entered the workplace right out of high school before I had an idea that my gender (and at that time, my age) would cause issues for some of my teammates. When I entered college that fall, I became aware of the problems a little more. It made me curious as to why there was a Society for Women Engineers. Then again, I tended to discount groups with "Women" in their title as exclusively female groups and those are typically not groups I'd associate with. The way I saw it, since I was planning on working with guys in the field, I wanted to socialize with them as well. Add to it that most of my friends have been guys, so it really didn't strike me as odd getting into a male-dominated field. What made things more interesting is that I never felt the gender issues much in my classes or extracurricular activities, even when I was the only female in the class. When I was aware of gender issues, it'd be in the workplace or when dealing with outsiders who knew the generalizations that come with women in tech.

It bothers me that at many conferences, the WiT gatherings I've seen have been exclusively women. At a gathering at Central Ohio Day of .NET last year, I was relieved when Jeff Blankenburg and Josh Holmes showed up with more people. Don't get me wrong - I appreciate girls' nights out and a break from the guys. But at the same time, I also have been around guys long enough to appreciate their views. I look to those guys for advice and guidance sometimes, and I think it's important that other women in tech realize that their perspectives of getting women involved in our community are quite interesting and are exactly why men's perspectives on WiT need to be heard more.

It was good to see Phil mention that PASS was taking a role in making sure there isn't a sexist bias. This is the way it should be - a group for professionals regardless of their gender, race, or other discriminating factor.

In my WiTty Perspectives series, you will see me challenging women to get past the girls' club approach and realize that there are plenty of guys who also want more women in tech. I look forward to sharing my stories of getting ahead and the people who helped me get to where I am today and who keep me ahead of a lot of people.

Labels: ,


Share this post:             kick this!  live it!

posted by Sarah at 1 Comments Links to this post

Sunday, January 3, 2010

CODE Magazine Special for PyCon 2010 Attendees

I got an email from Catherine Devlin - PyCon's Publicity Pythonista Extraordinaire - for you .NET people who may be going to PyCon. So... check this out:

.NET's Dynamic Language Runtime has brought new prominence to the role of .NET dynamic languages like IronPython, and many .NET programmers are looking for ways to get up-to-date on this growing aspect of the .NET environment. PyCon, the world's largest conference of Python and IronPython programmers, is an unparalleled learning opportunity. For $450 or less, attendees can spend an entire week learning from and working with Python and IronPython programmers from raw beginners to the creators of Python and IronPython themselves.

This year, PyCon offers a bonus to .NET programmers - a free one-year subscription to CODE magazine, the leading independent .NET resource.

PyCon 2010 runs Feb. 17-25 in Atlanta, Georgia. The conference includes five tracks of standard talks, plus Open Spaces, Lightning Talks, hands-on lab, exhibit hall, and poster sessions. Feb. 17-18 are set aside for twenty-four intensive, half-day tutorials. PyCon's development sprints run Feb. 22-25, in which ordinary attendees work together with project leaders to cooperate on extending and improving Python, IronPython, or their own favorite libraries and projects.
IronPython, a full-powered .NET implementation of Python, lets .NET programmers easily use dynamic language capabilities in their .NET environments. An brief review of IronPython's benefits for .NET programmers is at http://ironpython-urls.blogspot.com/2009/12/why-ironpython.html

Early-bird registration (through January 6) is just $450, and further discounts are available for students and attendees without employer support.

For information and to register, see http://us.pycon.org. To claim your free subscription to CODE, use this coupon code during registration:

CODE-subscription-PyCon2010

(If you've already registered for PyCon, signup for a CODE subscription will be available at the conference.)

See you in Atlanta!


Unfortunately, I won't be able to make it to PyCon this year due to scheduling conflicts. However, if you are dabbling with Python, want to know more about IronPython or other implementations of Python., or just want to meet others who are working with Python, I highly recommend that you check out PyCon 2010!

Labels: , , ,


Share this post:             kick this!  live it!

posted by Sarah at 0 Comments Links to this post

Saturday, January 2, 2010

What's Coming Up in 2010...

Happy New Year to you all! I hope you enjoyed celebrating the Gregorian calendar's change in the year. I am currently celebrating with friends - my husband and I have an annual LAN party that runs over New Years weekend, and despite the snow, we have a great turn out.
Looking forward into 2010, I have quite a few things lined up for blogging here...

The SUX Series
In 2008, while frustrated with the Office 2007 packaging, I started the Sarah on User eXperience (SUX) series. I didn't realize that I'd actually run with it, but in 2009, I had 8 entries on things that had poor user experience or awesome user experience. In 2010, this series will continue.

The SoS Series
This is a new series in 2010 - Sarah on Social (SoS) will cover my thoughts on things related to social media and social networking. From what sites I use and how I use them to why businesses need social media policies but why they shouldn't be too restrictive, look forward to seeing social media and social networking covered a bit more in 2010.

Toughest Developer Puzzle Ever Lives On
Once again, I'm working on creating puzzles for the Toughest Developer Puzzle Ever v. 2.0. We're looking for more puzzle creators - so if you're interested, email us and we'll get in touch with you about what we're looking for and how you can help.
Want to see how well we did last year? Check out Jeff's post and see for yourself!
If you haven't seen it yet, definitely check out the Toughest Developer Puzzle Ever at http://tdpe.info (a nice, short, Tweetable URL).

WiTty Perspectives
More and more I'm finding myself writing down my thoughts on the joys and pains of being a woman in tech (WiT), so the WiTty Perspectives series will cover my adventures of being a woman in tech and the lessons and words of advice that I have for other women in tech.

Caught in the Web
As many of you know, as part of my day job, I'm a web developer. I've always enjoyed web development, and I take great joy in making my web sites working on more than just Internet Explorer. So in 2010, look forward to more blog posts on web technologies, web debugging tools, and other things that I'd find interesting for web developers.

Conclusion
2010 will be an interesting adventure to say the least, and I look forward to sharing my thoughts, my experiences, and my perspective with all of you. If you ever want me to cover something in particular, email me and let me know what you want to hear.

Labels: , , , ,


Share this post:             kick this!  live it!

posted by Sarah at 0 Comments Links to this post

Tuesday, December 29, 2009

SSRS for SQL 2008 + TERADATA Config on Install = SUX

Just when I thought I was done with the SUX series for the year, I came across this gem.

Recently, I've been working with SQL Server Reporting Services and trying to work with it in ASP.NET. While reading logs, I came across an error regarding TERADATA. Why is it that my SQL Server Reporting Services (SSRS) is giving me an error like this on a fresh install?

So I did some searching through Bing, which led me to this article on Troubleshooting Configuration Problems. And then I saw this...

This error occurs because the Teradata extension is registered in the Reporting Services configuration file by default, but the Teradata assemblies are not shipped with SQL Server 2008 or as part of the .NET Framework. If the error message does not bother you, you can ignore the error when it is logged.

Wow... really? Why is an extension registered by default if none of the assemblies are included? Why is it an acceptable practice to pollute the event log with errors right after a fresh install?

Granted, they included how to avoid the error. But still....

If the assemblies aren't included, I would expect the extension not to be registered. Let the installer detect if the assemblies are installed and then enable it by default if it is detected. Include instructions in the installer that the TERADATA extension is enabled by default and have a simple way of disabling it on install. Strike up a deal with TERADATA so that the assemblies can be included in the installer. And if that isn't feasible then don't include the extension in the installer and let an installer with the TERADATA assemblies handle registering the extension.

Why add unnecessary clutter to the event logs when it should be avoided in the first place?

Don't get me wrong - adding support for TERADATA may be a nice feature. But for those of us who aren't using it, it's cleaning up setup stuff that - in my opinion - shouldn't be included in the first place.

Because of this approach, the combination of SSRS with SQL 2008 and TERADATA on a fresh SSRS install truly SUX.

Labels: , , , , ,


Share this post:             kick this!  live it!

posted by Sarah at 0 Comments Links to this post

Monday, December 28, 2009

Netflix Silverlight App Does Not SUX

Ah yes - I'm back with another edition of the SUX (Sarah on User eXperience) series. This time, I'm singing the praises of the Netflix Silverlight app.

Recently, I had the house to myself and a day to rest. So I had the idea of playing World of Warcraft while watching movies over Netflix.

The laptop: ASUS G1

The Internet connection: Time Warner cable

A part of me thought this would be a flop and that I'd have to choose between the movie and the game. I had anticipated that streaming a movie would bog down my connection, making it impossible for me to run through the Blasted Lands - maybe more like grinding and then eventually lagging across the continent but not smoothly running through. However, I had forgotten about an awesome feature with the Netflix Silverlight app - it detects the current bandwidth and changes the streaming based on the bandwidth available. It was glorious to play World of Warcraft and watch movies and TV shows at the same time. The best part - the app didn't have to recalculate for bandwidth issues until my husband came home and logged in. Even then, it did its recalculation and resumed my Law & Order: Criminal Intent episode right where I left off. So it was steady Netflix streaming and gaming all day. The Netflix Silverlight app does not SUX - it ROCKS!

Labels: , ,


Share this post:             kick this!  live it!

posted by Sarah at 1 Comments Links to this post

Thursday, December 17, 2009

Why Google Chrome is Pinned on my Taskbar

Whenever I give a presentation, I try to turn off my desktop icons just to get rid of a distraction (and clutter) for my audience. However, I haven't started hiding my taskbar yet. This past Tuesday night, I spoke at the Cleveland WPF User Group, and one of our regulars noticed an icon on my toolbar - a Google Chrome icon! Yes, I am a Microsoft MVP... yes, I like Microsoft's tools. But at the same time, I don't have to use only Microsoft products - there are times when I will use others' products.

So why do I have Google Chrome pinned on my Windows 7 taskbar? I'm a web developer, and it's only natural for me to have more than one web browser. (On my primary work machine, I have at least 5 desktop browsers plus a few mobile emulators - cross-browser web development can be so much fun!) I have Internet Explorer 8 on my laptop, because it comes with the operating system. But lately, I've been spending more time in Google Chrome, as I've grown accustomed to its interface and it's growing on me more and more.

I presented on Google Chrome at the Web Development SIG this past September, and I've been using it as my primary web browser on at least one of my machines since a few months after it came out. The quirky part of my setup though with using Google Chrome is that my default search engine is ... wait for it... bing! As much as I love using Google search, it's time to expand my horizons and give bing a chance. (And yes, this came out at the Web Dev SIG in September, but I can take the teasing that people dish.)

So why is Chrome pinned to my taskbar? The pin makes it easier to run my current primary browser. And now you know the answer to ... Is that Google Chrome on Sarah's taskbar? Why is it there?

Labels: , ,


Share this post:             kick this!  live it!

posted by Sarah at 3 Comments Links to this post