Archive | Uncategorized RSS feed for this section

Why SSMA?

     Can someone please explain to me what the benefit of using the SSMA tool to migrate Access databases is? I have looked at it on and off for a week now and don’t really see why it would be used over the simple Import feature of SQL Server 2005. So if someone has some […]

Read more

ASP.NET 2.0 and “allowDefinition=’MachineToApplication'”

Another interesting error came up today when I was working on a project remotely using Team Foundation Server. It seems that I pulled down latest version and attempted to rebuild the application when this error popped up. ASP.NET 2.0 & “allowDefinition=’MachineToApplication’”     So after some poking around I noticed that somehow the folder mappings or […]

Read more

SSIS: Use those Variables!

    One of the most understated objects that can be used within SSIS is the variable. Variables are accessable through the variables pane within Business Intelligence Development Studio(BIDS). This pane will show you the various variable names, their scope, and also the current value of the variable as shown in the screen shot below.     […]

Read more

Working with SSIS Part#1

It is often necessary when working with customer data to do import routines that will input each individual customer’s data. One way whihc is often implemented in Sales is to have the individual sales personnel input their weekly prospects into a predefined Excel spreadsheet and then to send that off to be placed on a […]

Read more

AS2005 Many-to-Many Relationships

I have been working for the past couple of months with Analysis Services 2005 and trying to get a hold on the Many-to-Many relationships. It si a pretty simple concept when you get down to it. AS2005 takes care of the many-to-many relationship and all that is required of you is to provide it with […]

Read more

Distinct Component for SSIS

If anyone has read Jamie Thomson’s piece A Distinct Component Please! .. I would like to ititerate his frustration. This seems like a simple thing for the powers that be on the business intelligence end to come up with. Of course, there have been some simple illustrations on how to do this via hash-tables and […]

Read more

SQL Server 2005 SP2

Okay so it has been about a month now since the SP2 CTP for December has been released and I am still awaiting the official release of the service pack. For those of you that are uninitiated with what the service pack contains …well, the biggest thing for me is the addition of vardecimal type. […]

Read more

New Book is Out!

Okay my latest book that I have had a hand is out now. Learn SQL In 24 Hours

Read more