Search Results: Symbol

• 
  SSAS – Using the Euro or Pound currency Symbol in a measure Format String

  SSAS – Using the Euro or Pound currency Symbol in a measure Format String If you have a set of measures and some of them are US dollars, some are Euros, and some are UK Pounds, you want to format them correctly in SSAS. First you will need to know the ASC

  Author:  MikeDavis     Date: 6/3/2011     Section: Blog

  tags : currency, Format String, measure, Pound, Symbol, .Euro, formatstring, SSAS
• 
  Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer

  Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more than willing to put in the time to achieve this monumental task. J At any rate, as a network bandwidth conscientious guy that I am, I wanted to decrease the s

  Author:  briankmcdonald     Date: 7/19/2010     Section: Blog

  tags : Data Source View, Explore Data Options, Increase or Decrease Sampling Size, SSAS
• 
  Alternating Group Colors

  Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my reports. I start off with a blank canvas (report), get my materials to paint with (data for my report) and then I get to paint my masterpiece (repo

  Author:  briankmcdonald     Date: 6/2/2010     Section: Blog

  tags : Alternating Colors, Alternating Group Colors, Reporting Services, SSRS
• 
  What’s New In Denali for SSRS

  I was so excited when I found out that Denali was released last week. Like it was Christmas time, I almost immediately went to download it and then I looked for what was new. J Unfortunately though, in the CTP that was released, there are no changes to Re

  Author:  briankmcdonald     Date: 11/23/2010     Section: Blog

  tags : Brian K McDonald, New in SSRS for Denali, SSRS, Denali
• 
  Expression Based Interactive Sorting using Reporting Services 2008 – Part 2 Dynamic Sort By

  In a previous blog written back in June, I showed you how to use the interactive sort option on a table header text box using values returned from a data set. I also wrote this back in June, but it got lost in my “blogpile”. J At any rate, in this blog, I

  Author:  briankmcdonald     Date: 11/4/2010     Section: Blog

  tags : Brian K. McDonald, Expression Based Interactive Sorting, Reporting Services, SSRS
• 
  Updating Email Addresses in SSRS Subscriptions

  Creating subscriptions in SQL Server Reporting Services is a great way to distribute files to end users. If it has been a while since you have begun using subscriptions and you have a bunch of them out there, there will more than likely come a time when a

  Author:  briankmcdonald     Date: 7/19/2010     Section: Blog

  tags : Reporting Services, Subscriptions, Updating Receivers Email Address, SSRS
• 
  PASS, Keynotes and Tweeting

  I have never had the opportunity to go to PASS before, but even though I was unable to attend this year, I sort of felt like I did! J The reason that I felt like I was there is because I was able to watch recordings of the keynotes and I read quite a bit

  Author:  briankmcdonald     Date: 11/15/2010     Section: Blog

  tags : Brian K McDonald, Keynotes and Tweeting, PASS
• 
  It's an Opportunity! Not an Obstacle!

  Write this down… No really… Write it, print it, send it to all of your friends and loved ones. J All kidding aside, I believe this to be a good quote to remember! There are many variations out there of this saying, but this is one version that I really li

  Author:  briankmcdonald     Date: 11/15/2010     Section: Blog

  tags : Brian K McDonald, Opportunity not Obstacle, Positive Perspective
• 
  Who Am I

  If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these are on computers you use during working hours and some during your non-working hours. Well, let’s just call these non-working hours, non-billab

  Author:  briankmcdonald     Date: 6/25/2011     Section: Blog

  tags : brian k mcdonald, sqlbigeek, whoami command
• 
  Columbus GA SQL Server Users Group Webinar Tomorrow

  I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that they needed a speaker and would love to have me talk about SSRS. Since I have given SSRS presentations for the past two years, I should be able to whip

  Author:  briankmcdonald     Date: 7/25/2011     Section: Blog

  tags : Brian K Mc, Columbus GA SQL Server Users Group, Introduction to SSRS Report Development and Delivery
• 
  Time Saver – Presentation Preparation

  Presenting is a huge fear for many and it is no different for me. I have been presenting at SQL Saturdays, Code Camps, User Groups and internal developer training sessions for the past few years. But for some reason, the initial knots in my stomach cause

  Author:  briankmcdonald     Date: 10/10/2010     Section: Blog

  tags : Time Saver, Presenting
• 
  SSIS Package Annotation in Denali

  If you are anything like me, you document your SSIS packages for those who may have to maintain them after you move on to other projects. One thing that have disliked is how annotations worked in SSIS. There is no word wrap setting to automatically wrap t

  Author:  briankmcdonald     Date: 11/30/2010     Section: Blog

  tags : Brian K McDonald, SSIS Annotations in Denali
• 
  Blogging and Saving Money at the Same Time

  I enjoy blogging. I enjoy passing on the information that I have gathered over the years. I also enjoy doing this while watching television. Currently I subscribe to Directv, but that is all about to change. This blog is about blogging in general, but mor

  Author:  briankmcdonald     Date: 11/9/2010     Section: Blog

  tags : Streaming Video, Blogging
• 
  Data warehouse vs. OLAP

  Data warehouse ad OLAP terms are commonly used in the Business Intelligence world. Below are some points that differentiate them as per my understanding. Data Warehouse (DW) – Data warehouse is a term used in conjunction with data · Data from different da

  Author:  indupriya     Date: 7/19/2010     Section: Blog

  tags : Data warehouse, OLAP
• 
  SSAS Dimension Attribute Discretization Methods

  Discretization (one of my favorite tech words to say J ) is a really great feature of Analysis Services that is often forgotten. Basically what discretization does is it can take a dimension attribute and automatically place its members in buckets for you

  Author:  DevinKnight     Date: 1/27/2011     Section: Blog

  tags : SSAS
• 
  Case Transform from Task Factory

  Below I will show you how to use the Case Transform (CT) that’s available from Task Factory. The (CT) provides a way to properly case, upper case or lowercase all the text in a source column. This is great tool that will help you clean up your sourc

  Author:  ChrisAlbrektson     Date: 11/9/2011     Section: Blog

  tags : Case Transform, task factory
• 
  Paradigms in programming

  For many people just beginning to learn how to program, they encounter a wall of confusing jargon, abstract ideas, and sometimes just plain nonsense. Programming languages by definition are tools to encapsulate repeated ideas or machine operations into co

  Author:  Bevans     Date: 2/22/2011     Section: Blog
• 
  SSIS Containers- Part 4: For Loop Container

  The next Container type I would like to discuss is the For Loop Container. The For Loop will loop through your package “For” as long as its EvalExpression value remains True. When you setup the For Loop Container you will have three important properties t

  Author:  DonnyJohns     Date: 3/24/2011     Section: Blog

  tags : SSIS Package For Loop Container Variable Expressions
• 
  Upgrading from 2005 to 2008 (R2?)

  Hey Kieth, Here is some information that I have found, and tested. · The main new items introduced in SQL Server 2008 R2 are listed in this Books Online topic: http://msdn.microsoft.com/en-us/library/bb500435.aspx The biggest feature is the Power Pivot te

  Author:  coleasicec     Date: 10/18/2010     Section: Forum
• 
  SSIS 2008- Design optimization / Best Practices

  Thank you Brain, Your approach will definitely help achieving the task. I am concerned about the No. of tables that needs to be loaded. There are about 80 tables that needs to be truncated and re-loaded based on certain parameters. This will also take lon

  Author:  Ranjit_Adi     Date: 11/4/2010     Section: Forum
• 
  Creating a Reporting Services Data Driven Subscription

  In this article you will learn how to create a Data Driven Subscription so your reports will run unattended on a schedule dynamically.

  Author:  DevinKnight     Date: 1/4/2010     Section: Article

  tags : SSRS
• 
  SQL Server 2008 R2 Update for Developers Training Kit (January 2011 Update)

  SQL Server 2008 R2 Developers training kits contains the following · 31 presentations (PowerPoint slides, videos and transcripts included) · 27 demos (installer scripts, videos and transcripts included) · 12 hands on labs (installer scripts included) Whic

  Author:  meganathank     Date: 2/14/2011     Section: Blog

  tags : SQL Server 2008 R2 Training Kits
• 
  rsErrorReadingNextDataRow

  I just ran it in management studio, and this is the error message I got: The server sent an unrecognizable response. '(there was a symbol here.. the female sex symbol)'', hexadecimal value 0x0C, is an invalid character. Line 1, position 3197024.

  Author:  britmccullar     Date: 11/30/2010     Section: Forum
• 
  Root element is missing

  hi whenevr i am copying my reprot to different server ans try to execute ,it shows me error like roor element is missing and another problem is ,my all rdl file shows as a notepad symbol.how to get back to rdl symbol thanks

  Author:  ssrsnew     Date: 6/23/2012     Section: Forum
• 
  Derived Column for specific criteria?

  Hello, I am a newbie to SSIS 2008 R2. I have a table of patient results. I need to move all of the results to a destination table in the data warehouse...with ETL modifications). Along the way to the destination database/table, I want to remove the % symb

  Author:  daveddvf     Date: 2/2/2013     Section: Forum

  tags : derived column