SQL Server 2008 R2 August CTP Available for Download

If you’re interested in the next release of SQL Server, the BI-focused SQL Server 2008 R2, you’ll be pleased to know that the August CTP is available for download here for MSDN and TechNet members. Here’s the skinny from the download page: SQL Server 2008 R2 expands on the value delivered in SQL Server 2008…

0

New To SSIS? Come Take A Guided Tour..

One of the more interesting and perhaps challenging aspects of a SQL Server 2000 to SQL Server 2005 upgrade is the migration from DTS to SSIS for ETL (Extract-Transform-Load) activities.  SSIS isn’t an upgrade of DTS, but is in fact an entirely new, and greatly enhanced, component.  While it’s possible to run DTS packages under SSIS, SSIS offers so many…

0

An Update For Cousin Tom: Classroom Stories, Business Intelligence, and Career News

Hey there cousin..   It’s been almost two months since we discussed data warehousing here.  I apologize for the long delay since my last correspondence.  It’s been a very busy time here; we’ve been preparing the first offering of our four-week SQL Server Microsoft Certified Architect OLTP/Ranger certification training.  We started teaching 18 students this…

1

Data Warehousing: A Open Note To Cousin Tom

Dear Tom, It’s been almost three weeks since you wrote.  I’ve been real busy with work and summer and everything, so I haven’t had a chance until now to do the thinking I need to do to answer your questions. You do remember your questions, don’t you?  It’s been that long? Okay.. My company is…

1

Scott's Answer, Completed: Temp Tables and Recompiles In SQL Server 2005

When I posted yesterday on this topic (first broached here), I’d found some good information pertinent to SQL Server 2000 in Tom Davidson’s MSDN article.  However, at that point I hadn’t had much luck finding the equivalent information for SQL Server 2005. I dropped an email to Tom, and he very helpfully pointed me towards two TechNet articles of interest: Batch Compilation, Recompilation,…

4

The Start of An Answer For Scott: Temp Tables and Recompiles

Kimberly Tripp, one of the most incredibly astute SQL poeple on the planet, calls her blog, “Improving *my* SQL skills through your questions”.  I would never steal her line, but after a bit of research on MSDN this afternoon, I can certainly relate to it, thanks to Scott Whigham of LearnSQLServer.com. In response to my recent…

3

Database Programming: Temp Tables or Table Variables?

On the occasion of this blog’s one hundredth post, I thought I’d pass along some information I recently discussed with my youngest cousin, Tom, who is like me an otherwise rational person who’s been bitten by the database development bug.  In a conversation on the subject topic, Tom wrote: My concern with using temp tables is partly…

9