BI Developer Network Community

• Day 1 in SQL Training
  3 hours, 28 minutes ago
  Today was my first day in the SQL training offered by PragmaticWorks. Though I am challenged, it is an excellent environment to learn new information. I am enjoying the laid back atmosphere and the willingness to help as many times as necessary to get what you are attempting to learn. Learning the T...
• My First day
  3 hours, 37 minutes ago
  My first day was interesting espceicially for a person that has a legacy systems background. I am experienced using cobol, cics, vsam and have very little experience with current technologies.  A couple of times I struggled on parts of some exercises, but for the most part I felt comfortable with th...
• Pragmatic Works Foundation First Day
  3 hours, 54 minutes ago
  This blog is a great way to exhale after our first day of class. This non-profit organization provides a great opportunity for those interested in entering the business intelligence world. Fit with a clean, new lap top and a positive teacher, we have been led through scores of TSQL introductory acti...
• Foundation Day 1
  4 hours, 18 minutes ago
  Devin just finished pouring as much as he could into our brains. It started easy and progressed to more difficult as the day went on. At this rate we will know everything about the known universe by Wednesday. Thanks Brian for giving us this great opportunity for training.
• First Day
  4 hours, 36 minutes ago
  I can describe the first day in one word, WOW! I feel like I am back in school but this time around I'm learning so much more in so little time. Today was more of a refresher of everything I learned in school but this time I actually think I will remember all that I have learned. I am not new to SQL...
• Remember The Show Blossom
  4 hours, 38 minutes ago
  WOW!!   Slight information overload.  Thank God I was prepping a little before stepping into my first day of training at Pragmatic Works.  I am definitely new to the IT industry and this is going to be a serious learning experience.  Fortunately, most of the participants in this class have as much e...
• Keep it simple... use the Import and Export Wizard
  20 hours, 46 minutes ago
  For some reason, a lot of us make things harder (or more time consuming) than they need to be.  In a field where there are plenty of difficult tasks to spend hours developing and completing, there are a few tasks that have shortcuts available.  The Import and Export Wizard is an example of a tool th...
• GROUP BY WITH ROLLUP
  2/7/2010
  The ROLLUP operator is useful when summarizing data. Its useful when generating reports that contain subtotals and totals. I use it a lot in my audit/daily queries, because table/matrix/tablix has subtotals. Basically ROLLUP generates a result set that shows aggregates for a hierarchy of values in t...
• MDX Parameter with Multiple Members Consolidated into Single Value
  2/5/2010
  Today I was working on a report built on a cube and stumbled on to an interesting requirement by some of our client's end users (EU). EU wanted to be able to consolidate multiple, specific members into a single parameter value. For example, if EU selected the parameter item A, they should see all me...
• SSRS Commonly Required Date Expressions
  2/5/2010
  Reporting Services has many expressions that can manipulate date fields.  These expressions can be used just about anywhere in SSRS including object properties, displayed data, and parameters.  Recently I’ve worked on some projects that required date parameters to do things that you would typically ...

More Blog Entries

• Feb

  11
  MEM-PASS: Joe Webb - SQL Server Locking & Blocking Made Simple
  Date &Time: Thu, February 11, 2010 to Thu, February 11, 2010
  Location: New Horizons, 4775 American Way, , ,
  Posted: 12/1/2009
• Mar

  06
  SQL Saturday #33 Charlotte
  Date &Time: Sat, March 06, 2010 to Sat, March 06, 2010
  Location: Central Piedmont Community College, 2800 Campus Ridge Rd, , ,
  Posted: 12/16/2009
• Mar

  13
  SQL Saturday #37 Philadelphia
  Date &Time: Sat, March 13, 2010 to Sat, March 13, 2010
  Location: St. Joseph's University, 5600 City Line Ave, , ,
  Posted: 12/16/2009
• Mar

  27
  SQL Saturday #29 Birmingham
  Date &Time: Sat, March 27, 2010 to Sat, March 27, 2010
  Location: Jefferson State Community College, 4600 Valleydale Road, , ,
  Posted: 12/16/2009
• Apr

  17
  SQL Saturday
  Date &Time: Sat, April 17, 2010 to Sat, April 17, 2010
  Location: Holidy Inn Elk Grove Village, 1000 Busse Rd, , ,
  Posted: 12/4/2009