Agile BI Community

Community site for agile business intelligence developers
Welcome to Agile BI Community Sign in | Join | Help
in Search
Home Blogs Downloads

Browse by Tags

All Tags » SQL Server

  • PASS Summit 2008

    Last post on presentations for a while, I think / hope. I'll be presenting on Unit Testing in SSIS at the PASS Summit 2008, occurring in Seattle, WA from Nov. 18-21. There's lots of great content planned at PASS this year, and it's definitely worth attending. If you are there, drop by the session and say hello.
    Posted to BI Thoughts and Theories (Weblog) by jwelch on September 17, 2008

  • SQL Saturday in Greenville, SC

    There's a SQL Saturday coming up in Greenville, SC on October 11th. It's a free, day long event with a number of great speakers doing sessions. I don't include myself in the great speaker category, but I was asked to present a couple of sessions on SSIS, including one on data profiling in the ETL process, one of my favorite topics. Again, it's ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on September 17, 2008

  • Testing the SQL Database at TechED

    While at TechEd this summer, I participated in a panel discussion on testing the database and related technologies. The panel also included Gert Drapers and Jamie Laflen of the Visual Studio Team System - Database Edition team, David Reed (who manages the SQL Server community samples on CodePlex), and Adam Machanic as the moderator. The discussion ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on August 18, 2008

  • New Tool to Help With Partitioned Tables

    Stuart Ozer on the SQL Server Customer Advisory Team (CAT) has posted a new tool to CodePlex to help with the management of "staging" tables for swapping data in and out of partitioned tables. Since this is a common scenario in data warehousing scenarios, I'm really looking forward to trying this out on my next project. If you are ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on January 29, 2008

  • Checking for Overlapping Rows in a Slowly Changing Dimension

    A question was posted on the MSDN forums about validating that there are no overlapping rows in a slowly changing dimension (SCD). It is common to use a start and end date in a type 2 SCD to designate when each version of the dimension member was in effect. However, it can create problems if the date ranges for one version of the row overlap with ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on May 4, 2007

  • Open Source SQL Server Stuff (OSSSS)

    I was on the CodePlex (www.codeplex.com) site today looking for the Analysis Services Stored Procedure project, and found that they have a number of SQL Server related projects available. First, all of the SQL Server samples have been uploaded to the site, which is nice if you only want to grab one or two of them. There is also the ...
    Posted to BI Thoughts and Theories (Weblog) by jwelch on March 30, 2007
Powered by Community Server (Personal Edition), by Telligent Systems