Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (RSS)

What’s Happening on SQL Server When My Package Fails?

We encountered an issue recently in an ETL process during the extract portion. When extracting from one very large table, using a NOLOCK hint, we were encountering errors indicating that the data was changing while we were extracting it. Since no other Read More...
Posted Friday, January 30, 2009 3:32 AM by jwelch | 2 Comments

SQL Server Launch Event

The launch event in Charlotte went very well – we had over 100 people in attendance, and the sessions were packed. We had a lot of good information on the new features in SQL Server 2008, covering the new T-SQL features, server consolidation, dimensional Read More...
Posted Sunday, January 18, 2009 7:16 PM by jwelch | 0 Comments
Filed under: ,

SQL Server 2008 Firestarter Event

There is a SQL Server 2008 Firestarter event at the Charlotte Microsoft campus next Thursday, January 15th. If you want to learn more about the new features in 2008, or just get a chance to network, it’s a great opportunity. We’ll have 5 SQL Server MVPs Read More...
Posted Wednesday, January 07, 2009 4:51 PM by jwelch | 0 Comments
Filed under:

Presentation at the Triad SQL Server User Group

On May 15th I'll be presenting at the Triad SQL Server User Group , located in High Point, NC. The presentation will be focusing on new features in SQL Server 2008 for business intelligence and data warehousing. If you're in the area, please stop in and Read More...
Posted Friday, May 09, 2008 1:01 AM by jwelch | 0 Comments
Filed under:

February CTP for SQL Server 2008

The February CTP for SQL Server 2008 has been released, and is available to download at https://connect.microsoft.com/SQLServer/ . Microsoft is also sponsoring a bug bash contest, with prizes for the most bugs, most critical bug, etc. The rules are posted Read More...
Posted Wednesday, February 20, 2008 5:20 AM by jwelch | 0 Comments
Filed under:

The November CTP for SQL Server 2008 Is Out!

The download link is here: http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en Evidently there have been some issues getting it on the Connect site, so they are hosting it in Microsoft's Download Read More...
Posted Monday, November 19, 2007 6:45 PM by jwelch | 0 Comments

SQL Server 2008 CTP 4 is Out

And you can download it from here . It looks like there are a few new improvements in Reporting Services, and some new data types in SSIS (to complement the new data types in the relational engine), but nothing too major. Hopefully, I'll have time to Read More...
Posted Thursday, August 02, 2007 12:35 AM by jwelch | 0 Comments
Filed under:

SQL Server 2008 - Using Merge From SSIS

In my last post, I talked about using the new MERGE statement in SQL Server 2008. It allows you to merge the data in a result set with a table, based on a join condition that you specify. This is a common scenario in data warehousing, where you often Read More...
Posted Thursday, July 05, 2007 4:18 AM by jwelch | 3 Comments

Using the Merge Statement in SQL Server 2008

It's been a busy couple of weeks, but I've finally found some time to play around with the June CTP of SQL Server 2008. One of the items that caught my interest was the MERGE statement. This is a new addition to the T-SQL language that lets you perform Read More...
Posted Saturday, June 16, 2007 10:45 PM by jwelch | 3 Comments
Filed under: