Subscribe to this blog
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…
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, 1,474 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, 92 reads
Posted in SQLDownSouth on 23 May 2010
Report Builder 3.0 - Using Report Parts
0 comments, 747 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,…
1 comments, 1,306 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, 109 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, 669 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, 459 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, 180 reads
Posted in SQLDownSouth on 7 May 2010