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 RSS Feed

Featured Articles

More Featured Articles

Recent Activity RSS Feed

Whats New

  • Using Temp Tables in Data Flow Source Stored Procedure
    1 hours, 48 minutes ago
    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...
  • SQL REPLACE for editing Configuration Tables
    3/10/2010
    Package Configurations in SSIS are key to making your packaged portable across the entire development process.  The problem you being to face with configuration files is the quantity that you collect.  Recently I was working on a project where we had pacakge level configurations as well as a configu...
  • Calculate the Date of the Previous Sunday
    3/10/2010
    There are a number of ways that you can calculate dates using T-SQL.  A common practice is to find the first day of the week which can be accomplished easily by using the following function.select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)However, you will notice that this returns the date for Monday ...
  • Back to Basics
    3/10/2010
    Today I figured I go back to basics with this blog since a majority of the visitors to this site are primarily DBA's and Database Guru's. This may turn into a series but for now we will discuss a bit of a feared power of sql server, and that is the fact that sql server in fact sits on top of the .ne...
  • Using a CTE with a T-SQL Pivot Statement
    3/9/2010
    During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a Common Table Expression (CTE).  In other words, instead of using the method outlined in SQL Server Books Online that uses a derived table, replace the derived table with a CTE.  I have never attempted...
  • Execute a SSIS package from a remote server
    3/9/2010
    Hi ,   I have a package that i need to be able to execute form a remote server....   How can i do that?... i need to have an icon on the desktop so the user can click on it and the package be executed. This is a very simple package where i have s source file (text) that i strip bad data and create a...
  • Reflection of Cloud Camp -- Auckland
    3/9/2010
    I have attended a cloud camp that was held in Auckland on Feb 26th 2010.  Here are some points sent by Ben the Cloud camp organiser. Here's some post-CloudCamp reflections and some posts from different people about the event. I posted a roundup here  giving my thoughts on the event. Thanks to all ou...
  • Date Dimension Indexes why not?
    3/8/2010
    Probably the most no-brainer in a DataWarehouse scenario is to index the heck out of the Date dimension. The cost of an index involves a couple of things: 1. How many inserts are performed on the table? 2. Fragmentation that may occur. 3. How much gain can be achieved by selects against the tables. ...
  • Filtering by Function performance alternative
    3/6/2010
    Many times we are forced to use functions in a where clause to filter results. The issue is here that rarely can SQL take advantage of an index if a function is used. SQL can perform OK in most of these scenarios, but what if you have a query used over and over again and you need it to perform as fa...
  • Another error message that doesn’t make sense, or does it?
    3/5/2010
    I was going back through a project and cleaning up a few things (you know…trying to use best practices, etc.) and got this error: Error: Failed to lock variable "Dts.Variables("intAuditRowsInserted").Value = 0" for read/write access with error 0xC0010001 "The variable cannot be found. This occurs wh...

More Blog Entries

.
  • Everything you need to know to develop your first SSIS package
    3/1/2010
    This arcticle covers all of the basics that one should know before developing an SSIS package.
  • Applying Security to Calculated Measures
    2/21/2010
    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 ...
  • Use SQL from the Command Line
    2/17/2010
    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 ...
  • SSIS Master or Parent Package Handling Child Errors
    2/17/2010
    Learn how to call child packages and handle errors between them.
  • This Year - Last Year SSAS Calculated Member
    2/16/2010
    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
    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
    Learn how to set up a many to many relationship in SSAS 2008.
  • Developing an End to End Data Mining Report
    1/24/2010
    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
    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
    Interesting approach to tedious ETL development for systems with large amounts of source data - only accessible via ODBC

More Articles

  • 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
    18
    An Evening with Fusion-io
    Date &Time: Thu, March 18, 2010 to Thu, March 18, 2010
    Location: UCLA Anderson School of Business, B301, 110 Westwood Plaza , N/A, ,
    Posted: 3/9/2010
  • 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
    10
    SQL Saturday Auckland
    Date &Time: Sat, April 10, 2010 to Sat, April 10, 2010
    Location: Wolters Kluwer, 41 Centorian Drive, Mairangi Bay' North Shore, N/A, ,
    Posted: 3/9/2010
  • 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
Travel & Green Cove Springs (Outside of Jacksonville)
Business Intelligence Trainer and Architect
Pragmatic Works BI Consultant
12/3/2009
Green Cove Springs, FL (outside of Jacksonville)
BI Tech Support
Pragmatic Works BI Support Technician
12/3/2009
Welcome and Intro to BIDN.com

Quick Vote

Where do you spend most your time?

   

Top Members (last 30 days)

Latest Forum Posts

More Forum Posts

People RSS Feed

Top Contributors

  1.   MikeDavis
    Padawan1465 points Padawan
  2.   AdamJorgensen
    Padawan1370 points Padawan
  3.   DevinKnight
    Padawan1347 points Padawan
  4.   DustinRyan
    Padawan1002 points Padawan
  5.   BrianKnight
    Padawan724 points Padawan
  6.   PatrickLeBlanc
    Padawan610 points Padawan
  7.   BradSchacht
    Padawan460 points Padawan
  8.   nitya
    Padawan364 points Padawan
  9.   marcoadf
    Padawan316 points Padawan
  10.   MikeMollenhour
    Padawan304 points Padawan

More People

Business Intelligence Developer Network (BIDN.com) on Facebook