home  »  blogs  »   » 

change text size: A A A

posted 1/1/0001 12:00:00 AM by

To rate this blog entry please  register or login

Author

 (Member since: 1/1/0001 12:00:00 AM)

View 's profile

Comments (no comments yet)

Post a comment

Comment (No HTML)  

Type the characters:
 *
 
   

Join Business Intelligence Developer Network for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

Blogs RSS Feed

DevinKnight's latest blog posts

  • Using SSAS MDX Calculation Color Expressions
    3/17/2010 12:10:25 AM
    Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also have another little feature that adds just a little more wow when your end users browse the cube.  By building a color expression on a calculation you can change either the fore color or background color of a measure value.  Here you can write an MDX expression that will change the font or background color of a cell when a user selects the calculation.  A very basic example is...
  • Solving All Versus (Select All) SSRS End User Confusion
    3/12/2010 11:11:39 PM
    When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters.  Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option that Reporting Services adds that make for an easy way to check off each item in the parameter dropdown.   If you followed most of the defaults when developing you dimensions in Analysis Services you likely also have an opt...
  • Using Excel 2007 in SSIS 2005
    3/2/2010 10:16:14 PM
    Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade.  This results in the majority of companies still running previous versions of SQL Server (2005, 2000, and even earlier).  Many times as the developer you are forced to work with older server components but new file sources like Excel 2007 with SQL Server and SSIS 2005.  In this case, there are some workarounds that will allow using what seem like two incompatible platforms.  This is a highly bl...
  • Using Database Transactions across multiple SSIS Tasks
    3/2/2010 8:17:55 AM
    If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed.  For example, if you have a transaction running on an entire package some tasks may not rollback on a failure.  A file system task is one of the major culprits that on a failure will not rollback the file operation it is performing.  I wish I was writing to give you a solution to that problem today but I’m actually writing to show how you could use a typical database transaction acr...
  • IntelliSense Slow to Refresh
    2/23/2010 11:36:14 AM
    IntelliSense in SQL Server 2008 can sometimes not be very intelligent.  It’s there to help you can sometimes cause more problems than it does solve problems.  Here’s one of those problems cases: Create a table without using the UI.  Just type a basic script to create a table.   Try to select from that newly created table and your IntelliSense can’t find the new table.   The problem is SQL Server knows you have a new table but IntelliSense does not.  If you refresh the Local Cache IntelliSense wi...
Blogs RSS Feed

Latest community blog posts

  • Minimizing Fragmentation when Moving data using a Switch
    3/17/2010 11:53:13 PM
    Yesterday was the first day of the SQL Server 2008 R2 airlift.  I attended a great session on Implementing a Fast Track Data Warehouse.    Lots of really interesting information was discussed during the meeting. However, an offline discussion about switching partitioned data in from a stage table provided a good tip that could help reduce fragmentation. If you are constantly switching data into your partition table you could potentially introduce some unwanted fragmentation in your database.  Th...
  • Using SSAS MDX Calculation Color Expressions
    3/17/2010 12:10:25 AM
    Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also have another little feature that adds just a little more wow when your end users browse the cube.  By building a color expression on a calculation you can change either the fore color or background color of a measure value.  Here you can write an MDX expression that will change the font or background color of a cell when a user selects the calculation.  A very basic example is...
  • Free and Discounted Microsoft Learning Resources
    3/15/2010 11:06:43 AM
    I was browsing the Microsoft Learning portal over the weekend and came across the following free or dicounted learning resources for SQL Server. Free Resources: Clinic 6188: What's New in Microsoft SQL Server 2008 for Enterprise Data Platform (1 hour)   Clinic 6189: What's New in Microsoft SQL Server 2008 for Business Intelligence (1 hour) Clinic 6190: What's New in Microsoft SQL Server 2008 for Database Development (1 hour) Clinic 6258: New Features Of Microsoft SQL ...
  • SQL Agent jobs
    3/14/2010 2:46:26 PM
    Recently I was asked to provide a list of all sql jobs on a certain server running between 2 and 3 in the morning.  We have quite a few jobs and it would be time consuming to look through each to determine the time of day each runs.  So I used the sysjobs, sysjobsschedules tables to return the job name and times the jobs run. There are several jobs related tables in the msdb database: sysjobs sysschedules sysjobhistory sysjobsteps syscategories   The table names are pretty self explanatory.  The...
  • Solving All Versus (Select All) SSRS End User Confusion
    3/12/2010 11:11:39 PM
    When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters.  Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option that Reporting Services adds that make for an easy way to check off each item in the parameter dropdown.   If you followed most of the defaults when developing you dimensions in Analysis Services you likely also have an opt...