Welcome to stevienova.com. Since 2004, I have enjoyed blogging about programming, business intelligence, SharePoint, Microsoft, Google, Apple and everything to do with technology. Thoughts on life, the world or my new favorite brew, may also be shared. I currently work at Trek Bicycle Corporation, managing both the BI team and .NET software dev groups. The opinions on this blog are solely my own.
I live in Sun Prairie, WI with my girlfriend and our 2 year old daughter. Besides my love for family and technology, I am passionate about music. I play the piano, guitar and I also sing. Everyday I learn something new, and I hope to share it with you.
The other day, someone requested that a report in SSRS be sorted differently by default. While that might make sense if everyone wants it that way, more than likely you might have people that want a report sorted differently by default. How to do it? There are probably a few ways, but this is what…
One thing I usually run into when creating SQL Server Reporting Services (SSRS) Reports is this: You have a smallish size dataset back, maybe somewhere between 50 and 150 rows, but if it hits that row limit on the page break, you get 3 records on the next page. Annoying. What I usually do for…
The third meeting for the Madison Area SQL Server Users Group (MADPASS) is tonight. The talk is about SQL Server Clustering for High Availability. Meetings are always FREE and food is provided. Details about the next meeting can be found below. In an ongoing attempt to make the content presented useful to our members we…
In the previous 2 parts (see Part 1 and Part 2) of this series I showed you how to get your data ready, and how to get your report started and your Datasets and parameters where you need them. In this part, we will get the graph functional, and in the next part, we will…
In the previous post in this series, Agile: Creating an SSRS Burndown Chart Part 1, I explained what data you would need to prepare to create an SSRS Burndown Chart (Sprint_Dates, Stories, Story_History). In this part of the series I will explain how to get a basic burndown report in SSRS. First, fire up Report…
The burndown chart. A must have for any ScrumMaster and Agile team. What it should show you is the rate at which you are “burning” down story points. As you can see from the chart above, 3 lines. Red is your “points scheduled”, Green is the “goal” and blue is “points left”. While it is…
I have been managing two different groups @ Trek - (Business Intelligence and .NET Software Development) for a while now, and we have some openings we are trying to file, so that is why I am putting this out here. First role, looking to hire a Microsoft .NET Windows Forms developer, or someone with web…
You can whip out reports in SSRS (SQL Server Reporting Services) very quickly with the report builders (2.0 and 3.0 are money). But what should you remember to do each time, or information to get? Where does the data come from (GL, Sales, etc) – we could use a cube or datawarehouse, or staging, or…
So, I previously blogged about using PivotViewer in your Web Applications, but you can also just consume Pivot collections using the “Pivot” tool from Microsoft Live Labs You can download it here What does this tool offer? Well first it has a library/homepage of collections you can browse You can do some slicing and dicing…
Figured out today that in SSRS, if you add a filter to your dataset, and you want to use “Like”, that the operand for everything is * instead of % like you might be used to in SQL, sometimes it is just the little things :)