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 data source. On the Connection Manager screen select Microsoft OLE DB Provider for DB2 from the drop down list labeled Provider. In the text box labeled Server or file name enter the IP address of your serv...
Read More
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 webcasts or join me at the Baton Rouge SQL Server User Group . The events are as follows: Baton Rouge SQL Server User Group Date and Time: 5/25/2010 5:45 PM CST Event Location: Lamar Advertising, 5551 Corporate BLVD, Baton Rouge, LA 7080...
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 is a tool that you should consider adding to your arsenal. During many of my client engagements I am asked to create reports. I will typically spend time reviewing existing reports and then I will recreate a report or two ad...
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, tables, logos, etc… In addition to the report part, any data set and/or parameter that the part depends on accompanies it as metadata. End-users will have the ability, using Report Builder 3.0, to create...
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 presenting SQL Server and PowerShell Working with Databases . In June, we will have first time SQL Lunch Speaker, Stefan Bauer, presenting Warehouse Disk Layout 101 . The SQL Lunch Team has several upcoming topics o...
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. Let’s assume that you already have a PowerPivot workbook that contains data. In this example I will be using the AdventureWorks2008 database. I have imported the following tables: DimDate, DimSale...
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 would share my presentation and the demo scripts. Since emailing each individual would be a true pain I stated that I would post all of the information in a blog post. So for all of you that attended my sessio...
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 progress. So, how did it do? Unfortunately, I failed miserably on a few goals, but, on the other hand,I exceeded my expectations on others. Here is the list from my initial post with a few comments about my progress: 1. Learn everything I can about SQL Server ...