Hungry for information about business intelligence? The BI Developer Network (BIDN) contains the best information about bringing business intelligence into your company. Every resource in BIDN is free.

Featured Articles

More Featured Articles

Recent Activity RSS Feed

What's New

More Activity
  • Determine users connected to sqlserver database
    7 hours, 42 minutes ago by indupriya  - Views: 14  - Comments: 0
    There are three ways to find who is connected to a database in sqlserver.  First one: Use the SQL SERVER Management Studio -- Management -- Activity Monitor This gives a list of users, database names, status, command, transactions, application with which they are using the database, CPU, IO and Memory usage, Login time etc.   Second One : Use the built in stored procedure called sp_who2 Run the command exec sp_who2 This gives a list of users, database names, status, command, program with which t...
  • SSRS - Formatting Mutiple Columns
    3/19/2010 10:04:09 PM by PatrickLeBlanc  - Views: 17  - Comments: 0
    Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix. Since SSRS 2008 does not allow the developer to change the format of a column using Textbox Properties when multiple columns are selected, the developer must either: · Change the formatting one column at a time · Be familiar with the expression language. Neither of the aforementioned choices are difficult, but maybe time constraints eliminates both as viable options. Therefore, ...
  • Minimizing Fragmentation when Moving data using a Switch
    3/17/2010 11:53:13 PM by PatrickLeBlanc  - Views: 47  - Comments: 0
    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 by DevinKnight  - Views: 136  - Comments: 3
    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 by BillBrannen  - Views: 124  - Comments: 0
    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 by TonjaB  - Views: 93  - Comments: 0
    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 by DevinKnight  - Views: 147  - Comments: 0
    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...
  • DTS Runtime Required
    3/12/2010 10:49:40 AM by ShawnHarrison  - Views: 94  - Comments: 0
    Yesterday, I dealt with a client that was having issues converting his dts packages to SSIS 2008. He was using DTS xChange to convert the packages, but each time he tried to run the migration, he received the following error. "Can not load Tasks. Error : Unable to cast COM object of type 'System.__ComObject' to interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed d...
  • Missing AdventureWorks2008 Found
    3/12/2010 7:08:28 AM by timmurphy  - Views: 80  - Comments: 0
    So I finally got through all the SSIS Class Labs including the Group Labs and decided to figure out why I didn't have AdventureWorks2008. I had previously tried to enable FILESTREAM according to some blogs I had read about it but had no success. Maybe I just understand all this a little better now but when I exactly followed these steps right out of the help file it worked for me: 1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and t...
  • Using Temp Tables in Data Flow Source Stored Procedure
    3/11/2010 5:51:52 PM by MikeMollenhour  - Views: 96  - Comments: 0
    Many times while working with SSIS I have had issues where I would like to add a temp table to a stored procedure that is a source for my SSIS dataflow. One work around for this is create a temp table variable instead. The issue with this is if many rows are in this temp variable the performance can be severely degraded. So the other day I was searching for workarounds and found this link http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65112/ . Here Michael Cape gives a Wack...
More Blog Entries
  • Re: delay validation...
    3/19/2010 by MikeDavis  - Views: 39  - Replies: 1
    First, you can use the Trim function to avoid using RTrim and LTrim. You cannot get rid of the warning with delay valiadation. But you can place a data convertion transform after the derived column to create a columns with the proper length. Then map this new column to the destination column. Warnings are okay to see on a package. It is perfectly fine to run packages with warnings. It does not hurt the performance. It can hurt performance if you add extra transforms that are not needed. But I un ...
  • Re: Multi Select ...
    3/18/2010 by danamatson  - Views: 50  - Replies: 4
    I found this article that had exactly what I was looking for. http://arcanecode.com/2008/10/20/sql-server-reporting-services-oracle-and-multivalued-parameters/#comment-27573 Thanks for all your help. I really appreciated it.
  • Re: Group Totals I...
    3/16/2010 by DustinRyan  - Views: 83  - Replies: 3
    Have you tried creating a parent group based on Released Orders with the child group being Order Type?
  • Re: Conditiona...
    3/16/2010 by DustinRyan  - Views: 116  - Replies: 7
    Thanks for your help, Luke. I also did a little write up on a simple SCOPE statement: http://www.bidn.com/articles/mdx-and-dmx/94/mdx-scripting-with-scope-statement .
  • Conditional formatti...
    3/16/2010 by Christian  - Views: 36  - Replies: 0
    I'm trying to format the background color of some cells/text boxes in a report based on the current Hidden (Visible? Toggle? I'm not sure the right term) property/status of a Row Group (or it could be some other object--e.g., text box--in the report). I put a document with screenshots and annotations at http://www.christianbahnsen.com/ssrs_conditional_formatting.pdf The document may help better explain what I'm trying to accomplish.Essentially it boils down to being able to determine whether a g ...
  • Re: Report si...
    3/16/2010 by DevinKnight  - Views: 138  - Replies: 12
    Trying using netstat -ano on the command line to see what all is trying to use port 80. You may have other applications that you don't know about that are using the default port. You could also just quickly change the port to something like 8080 in the report configuration to test.
  • Re: SSIS - Import te...
    3/15/2010 by MikeDavis  - Views: 25  - Replies: 1
    You can do one of two things. You can do this with a script task and read in each line. Or you can set up a data flow and read in the entire line as one column. Then use a derived column transform to do the find replace on the entire line. Write this data to a staging flat file and read that in your regular data flow.
  • Re: Show Me The Requ...
    3/15/2010 by CurrentMember  - Views: 142  - Replies: 2
    Hi Ed and Adam, Adam, I'm very interested to see your article when it is available. Ed, Here is my two cents. We use an Agile methodology that iteratively gathers requirements as the the system is developed and users understand the the capabilities of the system. The Agile SDLC diagram in this link does a pretty good job of describing the project flow. http://www.agiledata.org/essays/dataWarehousingBestPractices.html As you know a traditional waterfall model doesn't work well for BI because it d ...
  • Re: Count Fact R...
    3/12/2010 by CurrentMember  - Views: 104  - Replies: 5
    Hi Scott, I think you were right to start with but are unsatisfied that the Phone intersection shows a value. Your expression is dead on but may need a little tweaking. - In your example the All member if using ([DimOrderType].[OrderTypeDesc].currentmember,[Measures].[FactOrder Count]) will be 15 and this is not what you want- Your original solution is correct for [DimOrderType].[OrderTypeDesc].&[Internet] and is 5- Your want [DimOrderType].[OrderTypeDesc].&[All] to be 5 for this calculated meas ...
  • Re: Solution Deploy...
    3/11/2010 by CurrentMember  - Views: 91  - Replies: 2
    Hi, Have you checked the CPU, memory, and Disk I/O Metrics on the server using Task Manager or Performance Monitor? You may override the default member with NULL and see if that speeds up your initial connection CREATE MEMBER CurrentCube.[MEASURES].NullMember AS null, VISIBLE = 0; ALTER CUBE CurrentCube UPDATE DIMENSION Measures, DEFAULT_MEMBER=[MEASURES].NullMember; Then run the Profiler to see what its do in SSAS A good resource is http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-442 ...
  • Re: MDX very slow ...
    3/11/2010 by CurrentMember  - Views: 118  - Replies: 4
    Hi Patrick, Not sure of the specifics of your user-defined Products hierarchy but you might be able to do something like this in your cube's MDX script. CREATE MEMBER CurrentCube.[Measures].[Level Specific Calculated Member] AS NULL; //Overwrite SKU level SCOPE([Measures].[Level Specific Calculated Member] , Descendants ([Product Dim].[Product Hierarchy] ,[Product Dim].[Product Hierarchy].[SKU] ,SELF)); this = iif([Measures].[QoH]-[Measures].[arws]<0,([Measures].[QoH]-[Measures].[arws]),NULL) ...
  • Re: PowerPivot?
    3/9/2010 by MattSmith  - Views: 170  - Replies: 1
    My impression is that its self service optimized for large data sets. In the past we have found limitations with Excel's ability to handle this (around 1 million records). PowerPivot exceeds this significantly. It also allows the ability create calculated columns and so on. The true value I see is integrating it into a collaborative tool such as SharePoint where the users do not have to have excel installed locally to do analysis on data allowing you to govern your solution and minimizing suppor ...
  • Re: Database Source...
    3/5/2010 by TonjaB  - Views: 277  - Replies: 4
    nitya said: Check into SVN using Tortoise Client from Explorer each time we make a change. My IT team uses SVN as well. I only wish it could work with VS2005 like Source Safe. Tonja B
  • Re: Script destinati...
    3/3/2010 by MikeDavis  - Views: 55  - Replies: 1
    The 171 is the lineage id of one of the columns. One of the columns may have changed during the building process. Try remapping the columns in the input columns. But why are you using a script task? Why not use the OLEDB command transform?
  • Re: File System Ta...
    3/3/2010 by gharwood  - Views: 91  - Replies: 3
    I was able to get it working by changing the variable "TgtPath" from \\dbserver\c$\staging to \\dbserver\staging . Since my SQL Agent runs under a plain vanilla domain account which is not in the Administrator's group, the agent can't use the Administrative share "C$". However, I can't explain why when I am signed in as the sql agent account on the db server, I can use C$ both in windows explorer and in batch files (e.g this works: "move \\ftpserver\FTP\file.txt \\dbserver\c$\staging\file.txt ") ...
  • Re: Provider not r...
    3/2/2010 by MikeDavis  - Views: 97  - Replies: 3
    The OLE DB provider may have extra registery entries that exist for the users profile. If you install the full application as the MSRS user and configuerd the applications DB connection, it should validate the connection and the report should work.
  • Re: Naming Conventio...
    3/2/2010 by DevinKnight  - Views: 74  - Replies: 1
    Was it SSIS naming conventions? He was probably refering to Jamie Thomson's blog here http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx .
  • Re: Can we have ...
    3/2/2010 by srinivasa  - Views: 117  - Replies: 7
    I will be trying my scenario based on the below url: http://blogs.msdn.com/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx I think this solution will work for me, I will have to test this though... :)
  • Re: Creating Monthly...
    2/28/2010 by MikeMollenhour  - Views: 163  - Replies: 1
    If you create a subscription you will then find a job on the SQL Server Agent of the reporting services box... While the RS Interface doesn't seem to have the ability for last day of month the sql server agent schedule does so you can just try changing it in the job after it is created in the web inteface... Hope this works for you.
  • Re: MS Cube Browser
    2/28/2010 by MikeDavis  - Views: 73  - Replies: 2
    The Bids browser is only in BIDS. The browser is just for testing. Excel is much more powerful. You can create charts also.
More Forum Posts
  • SSIS 2008 lookup Altering the SQL statement
    3/17/2010 2:15:39 PM by MikeDavis  - Views: 43  - Comments: 0
    Learn how to alter the SQL statement in a Lookup transform.
  • Using Checkpoints in SSIS
    3/16/2010 2:00:50 AM by ShawnHarrison  - Views: 16  - Comments: 0
    When executing SSIS packages, there is always the chance that something could go wrong and cause the package to fail. This can be extremely frustrating if you have a package that affects multiple tables and takes a considerably long amount of time to run. To help ease the pain, SSIS has the option of using checkpoints.
  • MDX Scripting with SCOPE Statement
    3/15/2010 9:57:26 AM by DustinRyan  - Views: 55  - Comments: 1
    In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.
  • Everything you need to know to develop your first SSIS package
    3/1/2010 12:52:25 AM by kylewalker  - Views: 121  - Comments: 3
    This arcticle covers all of the basics that one should know before developing an SSIS package.
  • Applying Security to Calculated Measures
    2/21/2010 6:05:32 PM by AdamJorgensen  - Views: 36  - Comments: 0
    Tired of not being able to secure your Calculate Measures through SSAS? One of the biggest issues facing Analysis Services Developers these days is applying security to calculated measures through roles. The problem is with the default behavior exhibited by Analysis Services. This article will show you one of the best ways to get past this roadbloc
  • Use SQL from the Command Line
    2/17/2010 11:50:27 AM by BradSchacht  - Views: 41  - Comments: 0
    In this article Brad will describe how to use SQLCMD for using SQL from the command line. He will also show you how to implement this into your SSIS package to create an output file of a stored SQL Query. Also covered are some of the common commands used as well as the methods for interacting with SQLCMD.
  • SSIS Master or Parent Package Handling Child Errors
    2/17/2010 10:56:29 AM by MikeDavis  - Views: 64  - Comments: 0
    Learn how to call child packages and handle errors between them.
  • This Year - Last Year SSAS Calculated Member
    2/16/2010 9:53:29 PM by tinocash  - Views: 95  - Comments: 1
    In this quick demo I’m going to add a calculated member to the AdventureWorks cube that allows an end user to do a This Year/ Last Year comparison for a given measure.
  • Using SSIS to Automate the Creation of Cube Partitions
    2/2/2010 6:01:42 PM by DevinKnight  - Views: 192  - Comments: 6
    This article will show you a method for using SSIS to create SSAS partitions in and automated process. No longer will you have to create partition in the designer. Create an SSIS package to do all the work for you the schedule it to run when needed.
  • Setting up Many to Many in SSAS 2008 Cube
    1/26/2010 2:23:44 PM by MikeDavis  - Views: 199  - Comments: 9
    Learn how to set up a many to many relationship in SSAS 2008.
  • Developing an End to End Data Mining Report
    1/24/2010 5:25:59 PM by DevinKnight  - Views: 96  - Comments: 1
    In this article you will learn how to develop an End to End Reporting Services report using a Data Mining dataset. The article assumes you already have a data mining model created but if you do not a sample is provided.
  • SSRS: Information about reports ran
    1/23/2010 6:12:54 PM by marcoadf  - Views: 106  - Comments: 0
    This article provides information about reports ran. In this article I show how can you know how often a reports is requested, it's duration, exporting format, users who ran the reports among other useful information.
  • MetaData Driven ETL (MDDE) System
    1/16/2010 2:14:18 PM by howarddiesel  - Views: 65  - Comments: 2
    Interesting approach to tedious ETL development for systems with large amounts of source data - only accessible via ODBC
  • Normalization vs. Dimensional Modeling
    1/11/2010 12:00:00 AM by ShawnHarrison  - Views: 263  - Comments: 3
    This article is a basic overview and comparison between normalization and dimensional modeling.
  • Don’t let the Fear Factor hold up approval of your Data Warehouse Project
    1/8/2010 9:25:59 AM by samvnw51  - Views: 168  - Comments: 7
    Adopting a Data Warehouse project methodology that shows results early in the investment cycle and delivers incremental results at short intervals can facilitate the approval process and improve outcomes significantly
  • Using Configuration Files in SSIS
    1/7/2010 9:25:59 AM by MikeDavis  - Views: 164  - Comments: 0
    Learn how to use configuration files in SSIS.
  • Variables and Expressions with Connections in SSIS
    1/6/2010 9:25:59 AM by MikeDavis  - Views: 110  - Comments: 1
    Learn how to use variable and expression to make your SSIS connection dynamic.
  • Showing Total in some Cells (and hinding in some) in Matrix reports
    1/5/2010 2:57:51 PM by ashishnaik1  - Views: 64  - Comments: 0
    This article is about showing/hiding total in cells in Matrix report in SSRS 2005.
  • Variable Best Practices in SSIS
    1/5/2010 9:25:59 AM by MikeDavis  - Views: 205  - Comments: 1
    Learn some of the best practices when using variables in SSIS.
  • Creating a Reporting Services Data Driven Subscription
    1/4/2010 9:25:59 AM by DevinKnight  - Views: 117  - Comments: 2
    In this article you will learn how to create a Data Driven Subscription so your reports will run unattended on a schedule dynamically.
More Articles
  • PREMIUM EVENT
    SQL Saturday #29 Birmingham
    12/16/2009 by DevinKnight  - Views: 122  - Comments: 0
    When:  Saturday, March 27, 2010 Saturday, March 27, 2010
    Where: Jefferson State Community College, 4600 Valleydale Road, , , United States
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Mar 27 2010 at Jefferson State Community College, 4600 Valleydale Road, Birmingham, AL 35242. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
  • PREMIUM EVENT
    SQL Saturday Auckland
    3/9/2010 by indupriya  - Views: 24  - Comments: 0
    When:  Saturday, April 10, 2010 Saturday, April 10, 2010
    Where: Wolters Kluwer, 41 Centorian Drive, Mairangi Bay' North Shore, N/A, , New Zealand
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Apr 10 2010 at Wolters Kluwer, 41 Centorian Drive, Mairangi Bay' North Shore, Auckland . Admittance to this event is free. All costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event. More details will be posted on the website closer to the date.
  • PREMIUM EVENT
    SQL Saturday
    12/4/2009 by bretupdegraff  - Views: 127  - Comments: 0
    When:  Saturday, April 17, 2010 Saturday, April 17, 2010
    Where: Holidy Inn Elk Grove Village, 1000 Busse Rd, , , United States
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Apr 17 2010 at Holidy Inn Elk Grove Village, 1000 Busse Rd, Elk Grove Village, IL. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
  • PREMIUM EVENT
    SQL Saturday 44
    3/9/2010 by nitya  - Views: 21  - Comments: 0
    When:  Saturday, April 24, 2010 Saturday, April 24, 2010
    Where: Goldenwest College, 5744 Goldenwest St, Huntington Beach, CA , N/A, , United States
    Free Day long event with various presentations by several MVP's
  • PREMIUM EVENT
    SQL Saturday #38 Jacksonville
    1/8/2010 by DevinKnight  - Views: 95  - Comments: 0
    When:  Saturday, May 08, 2010 Saturday, May 08, 2010
    Where: University of North Florida, 1 UNF Drive, , ,
    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 8 2010 at The University of North Florida Campus, 1 UNF Drive, Jacksonville, FL 32224. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
More Events
  • Business Intelligence Trainer and Architect
    12/3/2009 by AdamJorgensen  - Views: 23
    Pragmatic Works  - Travel & Green Cove Springs (Outside of Jacksonville)  - BI Consultant
    Jump on this opportunity to join an exciting and growing MVP Business Intelligence Firm! Pragmatic Works is searching for a Business Intelligence Trainer to deliver innovative mentoring solutions with the Microsoft framework. Job Description Pragmatic Works is searching for a Business Intelligence Trainer/Mentor with experience delivering end to end training and solutions with the Microsoft framework. The candidate must possess the following credentials: ○ 5-6 years experience training/mentoring ...
  • BI Tech Support
    12/3/2009 by BrianKnight  - Views: 18
    Pragmatic Works  - Green Cove Springs, FL (outside of Jacksonville)  - BI Support Technician
    This entry level position supports the Pragmatic Works products (Task Factory, BI xPress, DTS xChange and BI Documenter). Must have good written and communication skills. Must be comfortable demoing products and speaking to a group of professionals. Prior knowledge of T-SQL and SQL Server is a must.
More Jobs
Welcome and Intro to BIDN.com

Quick Vote

Where do you spend most your time?

   
Business Intelligence Developer Network (BIDN.com) on Facebook