While flipping through this month’s SQL Server Magazine (December 2010), I came across what I thought was a very interesting top 10 list of “Favorite Go-To Websites for SQL Server Solutions”. I could not find the list on the website, but if you have the December… Read more

If you are anything like me, you document your SSIS packages for those who may have to maintain them after you move on to other projects. One thing that have disliked is how annotations worked in SSIS. There is no word wrap setting to automatically wrap to the next line,… Read more

Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had seen a session about column based indexing. The client was really eager to begin testing in their environment to see what kind of performance boosts they would gain. As an… Read more

I was so excited when I found out that Denali was released last week. Like it was Christmas time, I almost immediately went to download it and then I looked for what was new. J Unfortunately though, in the CTP that was released, there are no changes to Reporting Services.… Read more

I was so excited when I found out that Denali was released last week. Like it was Christmas time, I almost immediately went to download it and then I looked for what was new. J Unfortunately though, in the CTP that was released, there are no changes to Reporting Services.… Read more

I have never had the opportunity to go to PASS before, but even though I was unable to attend this year, I sort of felt like I did! J The reason that I felt like I was there is because I was able to watch recordings of the keynotes and… Read more

Write this down… No really… Write it, print it, send it to all of your friends and loved ones. J All kidding aside, I believe this to be a good quote to remember! There are many variations out there of this saying, but this is one version that I really… Read more

I was creating an SSIS package recently and ran into the “TargetInvocationException: Exception has been thrown by the target of an invocation” error as shown in figure 1 below.

Figure 1: Target Invocation Error

This happened to me a year or so ago, but I think my resolution was to… Read more

Recently, a friend of mine asked me how he could have the date appended to the end of a file name when creating a standard subscription in Reporting Services. At first the requirement was straight forward as it only needed date and it would need to be saved to a… Read more

I enjoy blogging. I enjoy passing on the information that I have gathered over the years. I also enjoy doing this while watching television. Currently I subscribe to Directv, but that is all about to change. This blog is about blogging in general, but more importantly it is about blogging… Read more

I recently became aware of a special hack in Windows 7. It is called GodMode and can very simply be one of the easiest hacks that I’ve ever seen. I guess technically it’s not a hack because it is more or less a hidden feature. A feature which allows you… Read more

Read more

Read more

Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated frequently! A while ago, I showed you how to find out what indexes were on a table using the GUI. Then, I showed you how to generate a listing…

In a previous blog written back in June, I showed you how to use the interactive sort option on a table header text box using values returned from a data set. I also wrote this back in June, but it got lost in my “blogpile”. J At any rate, in… Read more

A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well. While playing around with SSAS, I tried to open up SQL Server Management Studio (SSMS) and connect up to Analysis Services. The screenshot below shows how I tried to connect. Read more