Idera SQL Tools – An evaluation (Part 2)

This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first...

Labor Day Bloopers

Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple...

Let’s get Dimensional – from Requirements to Dimensional Design

Hey folks!

You asked for it – so coming up on September 8th we’re doing a SQL Lunch that is going to...

Managing Contacts

This is one of those posts that has little to do with SQL Server and more to do with helping...

Parallelism in SSIS - Multiple Lookups

This question just came up in the forums, and it highlights how difficult it can be to try to optimize...

PASS BI Virtual Chapter – Adaptive BI: Engineering a BI Solution

Hey there folks – PASS Virtual BI Chapter Event Alert!
Don’t forget to come out on Sept 20th and get Adaptive with...

PASS BI Virtual Chapter Event - SSRS 2008 R2 The New Stuff

Quick update from your PASS BI Virtual Chapter folks!
September 29th, Mike Davis is doing a session on SSRS R2: The New...

PASS Data Warehousing/Business Intelligence Virtual Chapter Live Meeting Sessions

Quick hit mid-week folks! Make sure not to miss the BI Virtual Chapter’s Presentation of Data Mining with PowerPivot with...

Renaming a column in Sql Server

 We often need to change the name of a column of a table to a new name. We  can do...

SQL Lunch #31 – SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns

Don’t miss Andy Leonard presenting his PArt Deaux of Design Patterns for SSIS.
Important Info from our SQL Lunch site….
Date and...