Tech4Him – Technology with Integrity

A Christian technology chaos wrangler and his thoughts

SSWUG Fall 2009 Virtual Conference Plan

Posted by Tom On October - 21 - 2009

So the SSWUG Fall 2009 Virtual Conference begins today. I’ve setup at home to hibernate for hours watching the live and pre-recorded sessions on a wide range of SQL Server and business intelligence topics. An extra LCD monitor brought home, the trackball mouse from the office, headphones and webcam. The kitchen is stocked for my “conference” meals and snacks thanks to my lovely bride. I am ready!

Oh yeah, the sessions. I almost forgot. ;)

Read the rest of this entry »

Popularity: 1% [?]

[Job] BI/Database Developer – Christian Mission

Posted by Tom On October - 21 - 2009

The Seed Company is hiring for a Database / Business Intelligence developer. D/FW Texas area preferred but telecommuting might be considered for the ideal candidate. So, if you have Business Intelligence experience including SQL Server, SSIS, SSRS and SSAS and want to put your skills to work for a very direct impact towards God’s kingdom work, submit your resume.

Read the rest of this entry »

Popularity: 1% [?]

SSWUG vConf – How to Avoid Common Pitfalls with SSIS

Posted by Tom On April - 24 - 2009

2479409190_446536d89b

Presenter: Matt Masson
http://blogs.msdn.com/mattm/

Starting up a new project with SQL Server Integration Services? Save time and money by learning about how to avoid common issues that users hit when implementing their ETL solutions. Drawing on the most frequently asked questions in the MSDN Integration Services forum and some of the more interesting packages we’ve seen over the years, well highlight common mistakes, clear up some misconceptions, and provide best practices to help you efficiently and effectively use Integration Services. Read the rest of this entry »

Popularity: 10% [?]

398476167_018e914c89Presenter: Josh Jones

Just like any other application, OLAP solutions designed and built in Visual Studio 2008 for SQL Server Analysis Service 2008 must be managed from source code to server. In this session, learn different methods for managing your OLAP solutions. Well cover TFS and VSS storage, manual deployment methods using the Visual Studio GUI, as well as command line build automation methods specific to SQL Server Analysis Services project deployments. Read the rest of this entry »

Popularity: 9% [?]

2978728372_8aea386cb5Presenter: Ted Malone
http://portal.sqltrainer.com

One of the problems that presents those new to Business Intelligence development is how to configure the development and production environments for maximum efficiency. This session will cover the installation and configuration of SSAS for both development and production environments. Attendees will leave this session with a good understanding of the options available and the specific needs in an SSAS environment. Read the rest of this entry »

Popularity: 9% [?]

SSWUG vConf – Intro to SQL Server Analysis Services

Posted by Tom On April - 24 - 2009

312795799_42d968acecPresenter: Brian Knight
bknight@pragmaticworks.com

Is your customer looking for drag and drop reports or capabilities inside of Excel. SQL Server Analysis Services (SSAS) is the answer for you then. You’ll be amazed how quickly you can develop sophisticated reports after watching the basics of this session. Read the rest of this entry »

Popularity: 10% [?]

2419154427_04dd3da737Presenter: Matt Masson
http://blogs.msdn.com/mattm/

This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. Well cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you’re interested in learning best practices for this new SQL Server 2008 functionality, you won’t want to miss this session! Read the rest of this entry »

Popularity: 14% [?]

SSWUG vConf – Loading a Data Warehouse in SSIS

Posted by Tom On April - 23 - 2009

2089748072_b60a211f97Presenter: Brian Knight
bknight@pragmaticworks.com
Owner, Pragmatic Works

In this session, you’ll learn how to load a typical data warehouse in SSIS efficiently. You’ll start by seeing some of the strengths and weaknesses of the Slowly Changing Dimension (SCD) Wizard in SSIS and how you can get around some of the weaknesses including your own home-brewed solution. You’ll then see how to load a fact table using SSIS and how to make the common components scale. Read the rest of this entry »

Popularity: 19% [?]