Who is online?  0 guests and 0 members
Home  »  Blogs  »  JeffRush

Communifire Blogs

Blogs RSS Feed

JeffRush : Most Recent postings

JeffRush

Meme Monday 4-4-2011

4/4/2011 by JeffRush  -  Comments: 0  -  Views: [1573]

Oh little box. Schrodinger's Data Flow Task. Success -and- Failure intertwined.

Read More

JeffRush

Everything old is new again is old again is new again

3/6/2011 by JeffRush  -  Comments: 3  -  Views: [1388]

Subtitled: What a long strange year it has been. Last April, I left my position as a database developer with Fellowship Technologies to become a full-time employee doing BI Consulting for a company called WaveTwo. For a number of reasons, this was made clear to not have been the right time to make that move and after 4 months, I received an offer from Fellowship Technologies to return and help them with a new reporting strategy they were implementing. I felt compelled to do so as I felt strongly...

Read More

JeffRush

Creating and Using a C# Class Library for SSRS

12/20/2010 by JeffRush  -  Comments: 8  -  Views: [13701]

In this blog post I am going to attempt to show how to create a quick and dirty C# class library as a simple way to provide end-user customization across reports. The sample I will use will be to facilitate Name formatting but this can extended to suit whatever needs you have. For example, we also use it for address formatting, custom encryption/decryption algorithms, .ToUpper/.ToLower functionality and HTML character stripping, to list a few. The first step will be to launch BIDS and create a V...

Read More

JeffRush

SSRS Subreports - The available options are not always ALL of the available options

12/17/2010 by JeffRush  -  Comments: 4  -  Views: [4454]

I'm going to be making a concerted effort to blog more going into the new year, so I will begin doing small little posts when I come across something I think others might find useful. The backstory: We have several reporting projects to organize reporting across various functional areas of our product suite. Today, I came across a situation where I wanted to use a report from a different project as a subreport. The problem: The drop down box for the report selection will only allow you to pick f...

Read More

JeffRush

SSRS Memory Pressure Zones

12/10/2010 by JeffRush  -  Comments: 3  -  Views: [6459]

Imagine the following scenario: You are an unpopular high-school kid who is desperate to make friends. To try and realize that goal, every Friday night you throw a party and pass out invitations to anyone you see (with a question-mark for the party end time because that’s just how happening you are). From time to time one or two people might show up, but it is usually dead. Then, one Friday night, for whatever reason people actually showed up - a lot of people. You are excited and nervous and ar...

Read More

JeffRush

Using Google Static Maps API to Facilitate Simple Mapping

11/30/2010 by JeffRush  -  Comments: 4  -  Views: [5860]

We recently had a need to implement a basic map plotting the top 10 zip codes that sales leads originated from within a specified date range. Here is how we implemented a quick and dirty solution using the Google Static Maps API. Here is some sample data: create table #Temp_MapZipCodes (Latitude float, Longitude float) insert into #Temp_MapZipCodes (Latitude, Longitude) select 40.1479, -79.8301 UNION select 36.5958, -121.884 UNION select 37.6637, -121.873 UNION select 38.6868, -121.352 UNION sel...

Read More

JeffRush

Thank You to the Community subtitled: The Power of Twitter

7/21/2010 by JeffRush  -  Comments: 2  -  Views: [1754]

As I begin my journey down the ol' blogging trail I wanted to make my inaugural post about something that has been a vital component of my personal and professional growth -- The SQL Community. Without the open nature of this great community I would not be sitting where I am today and I am thankful to be where I am. I am also incredibly fortunate that I came to this career path during the explosive rise of www.Twitter.com . This 'Fad' gave me unprecedented access to some of the best, brightest a...

Read More

Page 1 of 1 (7 items)