SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2010

Connecting to DB2 using SSIS

To start, first download and install the Microsoft OLE DB Provider for DB2. Click here to download. After it is installed I suggest rebooting your machine. In some cases a reboot is not required; however I have encountered problems without rebooting.

Next open an SSIS project and create a new… Read more

2 comments, 8,979 reads

Posted in SQLDownSouth on 26 May 2010

Upcoming SQL Events

I realized this morning that I will be participating in three SQL Events this week and I want to share the event information with everyone.  Two of the events are available online and the other is a local user group meeting.  If you have time logon onto one of the… Read more

3 comments, 566 reads

Posted in SQLDownSouth on 23 May 2010

Report Builder 3.0 - Using Report Parts

Report Builder 3.0 offers many new features to its users.  One of the best features, in my opinion, is the ability to search and use Report Parts that have been published to the Report Server.  If you are looking for a tool that will provide Self-Service to your end-users this…

Read more

0 comments, 1,813 reads

Posted in SQLDownSouth on 18 May 2010

SQL Server Reporting Services R2 - Publishing Report Parts

SQL Server Reporting Services R2 – Publishing Report Parts

SQL Server Reporting Services R2 (SSRS) allows report developers to not only publish reports and data sources to the report server, but now they have the ability to publish report parts.  You can publish parts of a report, such as charts,…

Read more

2 comments, 4,163 reads

Posted in SQLDownSouth on 16 May 2010

Upcoming SQL Lunch Webcasts

First, I would like to thank all that have attended and supported the SQL Lunch during our first year.  We are continuing on and have some great Lunches scheduled for May and June.  In May I will be presenting Configuring, Deploying and Scheduling SSIS Packages and Max Trinidad will be… Read more

1 comments, 681 reads

Posted in SQLDownSouth on 13 May 2010

Creating Sparklines in PowerPivot

Sparklines are new to Microsoft Excel 2010 and Reporting Services 2008 R2.  In this post I will outline the steps required to create sparklines in an existing PowerPivot workbook.  Sparklines provide you with the ability to create a trending graph inline with your data.  So how do create these Sparklines. Read more

1 comments, 2,382 reads

Posted in SQLDownSouth on 9 May 2010

SQL Server 2008 Performance Tuning Webcast

I recently gave a presentation on SQL Server Performance Tuning via Live Meeting.  I discussed how you could use the DMVs, SQL Server Profiler and Execution Plans to solve some of your performance problems.  There were over One hundred attendees in the session.  I was asked several times if I… Read more

0 comments, 1,034 reads

Posted in SQLDownSouth on 7 May 2010

2010 1st Quarter Goals Review

I know it’s kind of late to write a review of my first quarter goals, since we are well into the second quart of 2010.  However, I did state in my blog post earlier this year, 2010 1st Quarter Goals, that I would keep you all abreast of my… Read more

2 comments, 1,087 reads

Posted in SQLDownSouth on 7 May 2010