It may just be saying something about the data/respondents, but I thought it was fascinating to see the dip in salary for the 6-9 years of experience across several job...

If you have permission, open the SQL Server Management Studio and make a new connection to the Integration Services on the target server. Then just right-click on the folder...

I've always been surprised that more IT professionals haven't been involved in music. I've been immersed in it since I was five (piano to violin to saxophone (alto then...

I've had great luck using the sp_send_dbmail inside of an execute t-sql task.

The setup for that is pretty easy:

EXEC msdb.dbo.sp_send_dbmail

@profile_Name = 'ProfileName',

@recipients = ' recip@yourcompany.com',

@body = 'Here's the query...

I think it's worth mentioning that there's also an INTERSECT function for finding the overlapping rows. I spend many, many hours validating data and even I don't use intersect...

I was in more or less the same boat when I was moved into a BI position. I can't agree more about the advice about Itzik Ben Gan (he's...

michael.wiles (12/22/2009)

---

... To me, that business model seems too propieatary and monopolistic for me and seems to run counter to the free market place we pride ourselves of having. ...